Yang Chao, Liang Bo, Dai Wei, Wei Shoulin, Deng Hui, Wang Feng. Research on Cone Search of Distributed MySQL for Massive Astronomical Data[J]. Astronomical Techniques and Instruments, 2021, 18(3): 397-404. DOI: 10.14005/j.cnki.issn1672-7673.20201112.001
Citation: Yang Chao, Liang Bo, Dai Wei, Wei Shoulin, Deng Hui, Wang Feng. Research on Cone Search of Distributed MySQL for Massive Astronomical Data[J]. Astronomical Techniques and Instruments, 2021, 18(3): 397-404. DOI: 10.14005/j.cnki.issn1672-7673.20201112.001

Research on Cone Search of Distributed MySQL for Massive Astronomical Data

  • With the progress of sky survey projects, traditional database technology cannot satisfy the requirements of massive astronomical data storage and retrieval performance. In this paper, aiming at the high concurrency and performance of massive astronomical data storage and cone search, database middleware technology is used. When massive data reaches the limit of traditional database storage, it can be stored in the form of sub-database and sub-table through middleware technology. In the database cluster, the characteristics of the relational databases and distributed technology are fully integrated. In this article, with the application of MySQL database integrated DIF plug-in technology a pseudo-spherical index in a distributed database is established, which can meet the needs of spatial indexing in massive astronomical data.
  • loading

Catalog

    Turn off MathJax
    Article Contents

    /

    DownLoad:  Full-Size Img  PowerPoint
    Return
    Return