skip to main content
10.1145/3695080.3695120acmotherconferencesArticle/Chapter ViewAbstractPublication PagesiccbdConference Proceedingsconference-collections
research-article

Research on Multi-database Parallel Query Methods for Massive Electricity Businesses

Published: 12 October 2024 Publication History

Abstract

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%.

References

[1]
Liu Gi-Chao, Du J-H, Xie H-S, Liu Xiao-Yan & Xie Zhao-Gan. (2022). 2011 A new species of the genus Gastrodactylus (Hymenoptera, Staphylinidae). A multi-concurrent OLAP-type query performance prediction method for distributed databases. Computer Measurement and Control (10), 209-215+221.
[2]
Xie, Nyunu. (2023). Automated target data querying techniques for streaming data processing systems. Automation and Instrumentation (09), 237-240.
[3]
Youngho Song,Hyeong Jin Kim,Hyun Jo Lee & Jae Woo Chang. (2024). A Parallel Privacy-Preserving k-Means Clustering Algorithm for Encrypted Databases in Cloud Computing.Applied Sciences(2).
[4]
Velykodniy Stanislav,Burlachenko Zhanna & Zaitseva Velykodna Svitlana. (2021). Modelling the behavioral component of the emergent parallel processes of working with graph databases using Petri net-tools.International Journal of Parallel, Emergent and Distributed Systems(6),498-515.
[5]
Yang, Yi & Xiong, Ying. (2023). Simulation of multi-database parallel scheduling algorithm based on cloud computing platform. Computer Simulation(06),459-462+527.
[6]
Shu-Lin Wu, Gang Wu, Shu-Le Mao, Zhen Shao, Xiao-Hua Wu & Qing-Ru Zheng. (2022). 2011 A new species of the genus Pterocarpus (Hymenoptera, Braconidae, Pterocarpini) from China. A Dynamic Evaluation Method for Healthiness of Electric Power Business Information System in Massive Log Environment. Journal of Hefei University of Technology (Natural Science Edition)(06),858-864.
[7]
Wanyan Shao-Peng & Yu Jia. (2022). Matchability analysis of 5G technology performance and power service. Shandong Power Technology(07),1-7.
[8]
Wijethilaka, S., & Liyanage, M. (2021). Survey on network slicing for Internet of Things realization in 5G networks. IEEE Communications Surveys & Tutorials, 23(2), 957-994.
[9]
Li, Y., Wang, L., Wang, S., Sun, Y., Zheng, B., & Peng, Z. (2024). A learned cost model for big data query processing. Information Sciences, 670, 120650.
[10]
Zexue Yang, Yi Zhang, Lu Li, Weidong Liu & Chao Jiang. (2022). Spark-based parallel inverse k-nearest neighbor query. Computer Engineering and Design (12), 3340-3347.
[11]
Chang, B., Kamali, A., & Kantere, V. (2024). A Novel Technique for Query Plan Representation Based on Graph Neural Networks. arXiv preprint arXiv:2405.04814.
[12]
Hao-Nan Liu, Bao-Ning Niu & Y. Cheng. (2022). Parallel query interaction metric and execution plan selection. Computer Engineering and Applications (17),72-80.

Index Terms

  1. Research on Multi-database Parallel Query Methods for Massive Electricity Businesses

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Other conferences
    ICCBD '24: Proceedings of the 2024 International Conference on Cloud Computing and Big Data
    July 2024
    647 pages
    ISBN:9798400710223
    DOI:10.1145/3695080
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 12 October 2024

    Permissions

    Request permissions for this article.

    Check for updates

    Qualifiers

    • Research-article
    • Research
    • Refereed limited

    Conference

    ICCBD 2024

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • 0
      Total Citations
    • 15
      Total Downloads
    • Downloads (Last 12 months)15
    • Downloads (Last 6 weeks)7
    Reflects downloads up to 02 Mar 2025

    Other Metrics

    Citations

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    HTML Format

    View this article in HTML Format.

    HTML Format

    Figures

    Tables

    Media

    Share

    Share

    Share this Publication link

    Share on social media