Research on Multi-database Parallel Query Methods for Massive Electricity Businesses
Siyu Chen, Hongchen Lu, Zhicai Lin, Xinyi Jiang, Guohui Wei · 2024
With the continuous expansion of electric power business and the improvement of intelligence, the amount of data shows explosive growth. Therefore, the demand for efficient and fast data processing is increasingly urgent. This paper takes the background of the multi-database application for massive data as the background, and integrates multiple databases to form a unified data processing platform based on the detailed analysis of parallel query processing technology. On this basis, according to the characteristics of electric power business and data characteristics, the data is reasonably divided, so that the data between different databases can be processed in parallel, and the aggregated query processing and optimization of massive data and how to improve the reliability of the massive data system is studied. After testing, this method is used, fault recovery and fault tolerance mechanism to ensure the stability and reliability of the query, and the synchronization rate of electric power business between different databases reaches 100%.