Research and implementation of large data management in the field of astronomy

Research and implementation of large data management in the field of astronomy

Harbin Institute of Technology Yao Hua

This article will optimize the database performance of Oracle's real application cluster, testing to see if the existing Oracle real application cluster meets the needs of the project. In addition, this article will compare the performance of query statements in Oracle's real application cluster and other database management systems in the same situation. This article will also test the scalability of Oracle's true application cluster to see if Oracle's true application cluster supports adding, expanding clusters, and its fault tolerance, scalability, and usability. Accordingly, in order to better test query statements in Oracle Database management system performance, an auxiliary software will be developed to simplify the test query performance process, reduce workload. In practical application, this article will provide the combination of index, partitioning, parallel and other techniques to optimize the existing database. Moreover, as a part of the Large-scale Survey Telescope project, this part of the optimization strategy for large Survey telescope existing database management system will also have a certain significance. Software that assists in testing database performance will also be used directly by the project team to test other database system performance.

Research and implementation of large data management in the field of astronomy