Multi-source power big data hybrid storage method, device and system

• Main Authors: ZUO QIONG, QIAN LIPENG, SUN GUANQUN, LEE DAE-HO, ZHU HONG, WANG ERXI, CAO ZHONGSHENG
• Format: Patent
• Language: Chinese; English
• Published: 21.11.2023
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention discloses a multi-source electric power big data hybrid storage method, device and system, and belongs to the technical field of power grid big data, and the method comprises the steps: S1, integrating multi-source electric power big data from three dimensions of equipment, topological relation and time sequence; s2, under the equipment dimension, establishing a type data table corresponding to each equipment type so as to store attribute information of each equipment under the corresponding equipment type; under the topological relation dimension, establishing a relation data table to store relation information among different equipment types; under the time sequence dimension, establishing a time sequence data table corresponding to each device so as to store state data of the corresponding device; s3, connecting the data tables with the dependency relationship among the dimensions by adopting primary and foreign keys; and S4, storing the data table under the equipment dimension and the topolo