Graph Database Design for Power Industry Applications Integrating OLTP and OLAP Workflows
摘要
The paper shows that large and interrelated data processing is a challenge in the power industry because traditional RDBMSs are not supported by real-time analytics. It suggests a graph database solution with tasks divided between OLTP in real time tasks and OLAP in general analyses. The system is fast and efficient with the use of Graph Neural Networks and Temporal Graph Networks. Findings indicate a 35% response time (120ms to 78ms) and 40% reduction in complexity of OLAP (0.45s to 0.27s). The predictive maintenance is 25% more accurate (MAP 92% vs. 67%), and redundancy is decreased by 20%, reducing the storage costs and increasing scalability.