Journal of Terahertz Science and Electronic Information Technology , Volume. 22, Issue 10, 1154(2024)

Historical data migration technology of domestic database based on domestic CPU environment

MAO Dong11... ZHANG Chen11, CHEN Youyong2, LIU Yongqing3 and JIAO Yanbin3 |Show fewer author(s)
Author Affiliations
  • 1Information Communication Branch of State Grid Zhejiang Electric Power Co., Ltd, Hangzhou Zhejiang 310007
  • 2Fujian Yirong Information Technology Co., Ltd, Fuzhou Fujian 350001, China
  • 3State Grid Information & Telecommunication Group Co., Ltd, Beijing 102211, China
  • show less

    In view of the problems of long data migration, high maximum occupancy rate of storage space, high error rate of transfer learning and low online probability of visited data, the historical data migration technology of domestic database based on domestic Central Processing Unit(CPU) environment is studied. Firstly, the system software and hardware are clustered and deployed in the domestic CPU environment to improve the migration rate of historical data between domestic databases. Secondly, an isolation forest model is established, and the historical data is input into the isolation forest model for trend prediction, thereby eliminating the abnormal data in the domestic database, and reducing the amount of data to be migrated. Finally, a data migration model is constructed, and an alternating optimization strategy is adopted to find the optimal solution of the model, thus completing the migration of historical data in domestic databases. The experimental results show that the data migration time of this method is 18 minutes, and the maximum occupancy rate of storage space is between 10% and 25%, the ALC(Area under the Learning Curve) index value is 0.78~0.95, and the online probability of the accessed data can always be maintained at more than 97%, proving that this method has a short data migration time, a low maximum occupancy rate of storage space, a low error rate of migration learning, and high access efficiency, demonstrating good application effects.

    Tools

    Get Citation

    Copy Citation Text

    MAO Dong1, ZHANG Chen1, CHEN Youyong, LIU Yongqing, JIAO Yanbin. Historical data migration technology of domestic database based on domestic CPU environment[J]. Journal of Terahertz Science and Electronic Information Technology , 2024, 22(10): 1154

    Download Citation

    EndNote(RIS)BibTexPlain Text
    Save article for my favorites
    Paper Information

    Category:

    Received: Dec. 28, 2022

    Accepted: Dec. 10, 2024

    Published Online: Dec. 10, 2024

    The Author Email:

    DOI:10.11805/tkyda2022250

    Topics