Power Data Integration Method Based on Database-table Metadata Semantic
Lei Na Zheng, Jianhong Pan, Kai Zhang · Journal of Physics Conference Series · 2022
Abstract Aiming at the characteristic of power data with multiple sources, wide distribution and complex association, this paper proposes a power data integration method based on Database-Table Metadata Semantic (DTMS), which can realize the integration of grid data at the metadata layer. Firstly, based on the structure of the database, the semantic expression is established between database and table; Secondly, this paper combines the Jaccard distance similarity method and the edit distance similarity method to achieve semantic matching between metadata and technical terms, which can solve the shortcomings of the single similarity method. Finally, according to the characteristics of power data assets, a power data integration scheme based on DTMS is proposed for multi-source power data integration. Through experiments, the accuracy of the algorithm in this paper has reached 95.8%.