Data query method and system of electric power business system

Abstract

The invention relates to a data query method and system of electric power business systems. The data query method includes the following steps that: the database information of the electric power business systems is registered, and the database information of the electric power business systems is recorded in database tables; connection information of the databases of the electric power business systems is configured according to the database information in the database tables; with the primary keys and foreign keys of the database tables of the electric power business systems adopted as related conditions, correlation relations of the database tables of the electric power business systems are configured; inputted data query conditions are acquired, the database information of electric power business systems which satisfies the data query conditions is acquired according to the correlation relations; the databases of corresponding electric power business systems are connected according to corresponding connection information, and a data result set can be obtained, and the data result set is displayed. With the data query method and system of the invention adopted, the data of a plurality of business systems can be queried simultaneously, and the data can be displayed for users in a unified manner, and therefore, great conveniences can be brought about.

Description

technical field [0001] The present invention relates to the technical field of power business systems, in particular to a data query method of the power business system and a data query system of the power business system. Background technique [0002] In the actual operation of the power system, there are a wide variety of business systems that generate a large amount of real-time data all the time, and require the submission of corresponding reports at regular intervals, such as daily, weekly, monthly, quarterly, and annual reports. By summarizing and statistically analyzing the data collected within a certain period of time, the report can reflect the operating status of the system to users at multiple levels and from multiple angles. [0003] The current business model needs to query certain types of information. It needs to log in to different systems to search multiple times, and to search information across multiple platforms. It is impossible to intuitively display t...

AI Technical Summary

Problems solved by technology

[0003] The current business model needs to query certain types of information. It needs to log in to different systems to search multiple times, and to search information across multiple platforms. It is impossible to intuitively display the required information in full and intuitively, and it is impossible to integrate the result information accurately and efficiently. , which results in poor timeliness of information feedback and long query cycle, which has a great impact on the actual work of users

[0004] Now generally all provincial power supply companies operate in the same network, but since the information systems of each municipal power supply company are usually independently developed, this creates great difficulties for the communication between the municipal company and the provincial company

[0005] The difficulty is mainly manifested in that due to multiple data sources, the consistency of data cannot be guaranteed; because the data is scattered in multiple subsystems, it is difficult to realize comprehensive query; because the entire power system and management mechanism are constantly changing, increasing , Change some statistical indicators, the statistical reports must be changed accordingly, and the existing subsystems cannot integrate information simply and quickly, and the data reported by some departments with different key indicators may be contradictory, which is very important Affects the efficiency of operation control to a certain extent

Images