A method for constructing data navigation maps for power grid companies

Abstract

The present invention discloses a method for constructing a data navigation map for a power grid company, including: creating a system menu structure diagram; creating a data resource structure diagram; creating a data relationship structure diagram; creating a data application flow chart, and connecting the data application flow chart with the data source of the data middle station; creating a middle station data automatic acquisition module; integrating a visualization report tool. The present invention constructs a system menu structure diagram, a data resource structure diagram, and a data relationship structure diagram in the manner of business system-menu level-business function point-data table-data table relationship, and integrates data from the data middle station and visualization report tools to establish a data navigation system from the perspective of grassroots front-line business, build a bridge connecting the front-end business data requirements and the system back-end data resources, improve the data tracing efficiency and data use efficiency of grassroots front-line business personnel, and solve the problem that the data of grassroots front-line personnel is difficult to find, difficult to understand, difficult to obtain, and difficult to use.

Description

Technical Field

[0001] The present invention relates to the technical field of power grid data processing, and in particular to a method for constructing a data navigation map for a power grid company. Background Art

[0002] The advent of the era of big data and cloud computing has accelerated the development of massive data processing technology. Power grid companies have built data middle platforms and data directories to achieve centralized aggregation and unified management of enterprise data resources. As the digital transformation of power grid companies is further promoted to the grassroots level, the demand for innovative data applications at the grassroots level is becoming more and more vigorous, and higher requirements are put forward for the "visibility, traceability, accessibility, and usability" of data. Overall, power grid companies still have problems such as difficulty in matching business needs with data and inability to use data directly in promoting data empowerment at the grassroots level. The superposition, multiplication and amplification effects of data have not been fully released. First, it is difficult to match business needs with data. The phenomenon of "difficult to find and understand" data at the grassroots level still exists. The existing data directory of power grid companies is mainly constructed from a technical perspective. There is a lack of efficient connection bridge between business language and data language. It is difficult for grassroots users to directly understand the backend data table and requires support from IT personnel. However, it is difficult for IT personnel to be fully familiar with the business, resulting in low conversion efficiency between data and business needs. Data needs often have to go through a lot of verification and repeated confirmation before they can be finally met. Second, data cannot be used directly. The phenomenon of "difficult to obtain and use" data still exists at the grassroots level. The data services of power grid companies based on data middle platforms are mainly provided by API interfaces and other methods. Data acquisition is highly dependent on IT technicians. After obtaining data, there is a lack of simple and easy-to-use data analysis tools. There are barriers to data use, and the grassroots data analysis needs cannot be responded to in a timely manner, which restricts the grassroots front-line personnel from independently obtaining and quickly analyzing data. How to realize data business for the grassroots and empower the grassroots with data has become a difficult problem facing power grid companies. Summary of the invention

[0003] The purpose of the present invention is to overcome one or more deficiencies of the prior art and to provide a method for constructing a data navigation map for a power grid company.

[0004] The object of the present invention is achieved through the following technical solutions: a method for constructing a data navigation map for a power grid company, comprising:

[0005] Creating a system menu structure diagram, wherein the system menu structure diagram includes a correspondence between a business system, a system menu, and business function points;

[0006] Creating a data resource structure diagram, wherein the data resource structure diagram includes a correspondence between business function points and background data tables;

[0007] Creating a data relationship structure diagram, wherein the data relationship structure diagram includes association relationships between data tables;

[0008] Create a data application flow chart and connect the data application flow chart with the data source of the data center;

[0009] Create a middle-end data automatic acquisition module, which is used to generate a data acquisition SQL statement to acquire data after the data application order in the data application flow chart takes effect, and present the data acquisition result in the data application order;

[0010] A fusion visualization reporting tool is used to access the data of the data acquisition result according to the table name information of the data acquisition result corresponding to the data application order, and generate a BI data set based on the data of the data acquisition result.

[0011] Preferably, the step of creating a system menu structure diagram includes:

[0012] The system menu of the business system is defined from the first-level menu to the last-level menu, from the last-level menu to the first-level business function point, and from the first-level business function point to the last-level business function point;

[0013] Establish the hierarchical structure correspondence of the system menu based on the relational database;

[0014] On the basis of establishing the hierarchical structure correspondence of the system menu, the business function points corresponding to the last-level menu page are refined step by step, and the correspondence between the last-level menu and the business function points is established based on the relational database;

[0015] On the basis of establishing the hierarchical structure correspondence of the system menu and the correspondence between the final menu and the business function point, based on the graph database, with the business system, system menu and business function point as nodes, and with the correspondence between the business system and the first-level menu, the upper-lower correspondence between the system menu, the correspondence between the final menu and the first-level business function point, and the upper-lower relationship in the business function point as edges, a graph model of the business system-system menu-business function point is constructed;

[0016] The graph model of the business system-system menu-business function point is visualized.

[0017] Preferably, the step of creating a data resource structure diagram includes:

[0018] On the basis of the system menu structure diagram, the corresponding relationship between business function points and data tables and fields in the background database is established based on the relational database;

[0019] Based on the correspondence between business function points and data tables and fields in the backend database, the data retrieval logic SQL corresponding to the business function points is encapsulated based on the distributed data warehouse of the data center to form the business wide table view corresponding to the business function points;

[0020] The business wide table view corresponding to the business function point is visualized.

[0021] Preferably, the step of creating a data relationship structure diagram includes:

[0022] On the basis of the data resource structure diagram, the relationship between the background data tables of business function points and data tables is established based on the relational database;

[0023] On the basis of establishing the association relationship between data tables, based on the graph database, with business function points and data tables as nodes, and the relationship between business function points and data tables, and the primary and foreign key relationship between data tables as edges, a graph model of business function points-data tables-data tables is constructed;

[0024] The business function point-data table-data table graph model is visualized.

[0025] Preferably, the data application process includes checking the data resource to add to the shopping cart, submitting the shopping cart, submitting the data application and approving the data application.

[0026] Preferably, the fusion visualization reporting tool includes:

[0027] Set up visual reporting tools;

[0028] Add a button to jump to the visual reporting tool in the data application order retrieval result presentation interface.

[0029] Preferably, the system menu structure diagram is visually presented in a graphical form.

[0030] Preferably, the data resource structure diagram is visually presented in the form of a shared wide table view.

[0031] Preferably, the data relationship structure diagram is visually presented in the form of an ER diagram.

[0032] The beneficial effects of the present invention are:

[0033] (1) The present invention constructs a system menu structure diagram, a data resource structure diagram, and a data relationship structure diagram in the manner of "business system-menu level-business function point-data table-data table relationship", establishes a data navigation system from the perspective of grassroots front-line business, and builds a bridge connecting the front-end business data requirements and the system back-end data resources, thereby improving the data tracing efficiency of grassroots front-line business personnel and solving the problem that the data of grassroots front-line personnel is "difficult to find and difficult to understand";

[0034] (2) The present invention constructs a data application flow chart based on the system menu structure diagram, data resource structure diagram and data relationship structure diagram, integrates the data acquisition process and visual analysis tools of the data center, realizes the independent application, automatic data acquisition and self-service analysis of the required data, opens up the "last mile" of data use for grassroots users, improves the efficiency of data application and acquisition, lowers the threshold for data use by grassroots front-line business personnel, and solves the problem of "difficulty in obtaining and using" data for grassroots front-line personnel;

[0035] (3) The present invention changes the data service mode of the power grid company for the grassroots from the previous "demand initiation, repeated confirmation" mode to a self-service mode of "multi-party participation, co-construction and sharing"; the grassroots front-line can effectively exert their subjective initiative through the data navigation map and carry out independent traceability, so as to obtain the required data more conveniently and accurately, stimulate the enthusiasm of grassroots users to use data, and continuously release the value of data; data service providers have more energy to focus on building data service capabilities, realize the transformation from data operation and maintenance to data operation, and build a co-construction and sharing data operation system. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Figure 1 A flow chart of a method for constructing a data navigation map for a power grid company;

[0037] Figure 2 A flow chart for creating a system menu structure diagram;

[0038] Figure 3 A flow chart for creating a data resource structure diagram;

[0039] Figure 4 A flow chart for creating a data relationship structure diagram;

[0040] Figure 5 A diagram of the architecture for navigating maps for data. DETAILED DESCRIPTION

[0041] The technical solution of the present invention will be clearly and completely described below in conjunction with the embodiments. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of the present invention.

[0042] See also Figure 1-Figure 5 , this embodiment provides a method for constructing a data navigation map for a power grid company:

[0043] like Figure 1 As shown, the method for constructing a data navigation map for a power grid company includes:

[0044] S1. Create a system menu structure diagram, which includes the corresponding relationship between the business system, system menu and business function points.

[0045] This embodiment focuses on the core business systems in the field of power grid production, operation and management, establishes the correspondence between the system menu-level structure relationship of the business system and the final menu and business function points, realizes the visual output of the correspondence information between "business system-system menu-business function points" based on the knowledge graph, and provides functions such as step-by-step penetration, content scaling, and global search for the grassroots frontline of power grid companies, assisting users to quickly search and locate data resource locations according to the original usage habits of the business system.

[0046] In some embodiments, Figure 2 As shown, the creation of the system menu structure diagram includes:

[0047] S11. Define the system menu of the business system, including the first-level menu to the last-level menu, the last-level menu to the first-level business function point, and the first-level business function point to the last-level business function point.

[0048] S12. Establishing a hierarchical structure correspondence of the system menu based on a relational database.

[0049] Specifically, centering on the core business systems in the field of power grid production, operation and management, a hierarchical structure correspondence of system menus of business systems is established based on a relational database, involving information such as system code, system name, menu code, menu name, menu level, menu sorting, whether it is the last-level menu, and upper-level menu code.

[0050] S13. On the basis of establishing the hierarchical structure correspondence of the system menu, the business function points corresponding to the last-level menu page are refined step by step, and the correspondence between the last-level menu and the business function points is established based on the relational database.

[0051] Specifically, on the basis of establishing the correspondence between the hierarchical structure of the system menu, the business function points corresponding to the last-level menu page are refined step by step, and the broad table names of the business function points are defined. Based on the relational database, the correspondence between the last-level menu and the business function points is established, involving information such as system code, menu code, function point code, function point name, function point sorting, function point hierarchy, parent function point code, and corresponding broad table name.

[0052] S14. On the basis of establishing the hierarchical structure correspondence of the system menu and the correspondence between the last-level menu and the business function point, based on the graph database, with the business system, system menu and business function point as nodes, and the correspondence between the business system and the first-level menu, the upper and lower correspondence of the system menu, the correspondence between the last-level menu and the first-level business function point, and the upper and lower relationships in the business function point as edges, a graph model of the business system-system menu-business function point is constructed.

[0053] Specifically, on the basis of establishing the hierarchical structure correspondence of the system menu and the correspondence between the last-level menu and the business function point, based on the graph database, with the business system, system menu, and business function point as nodes, and the correspondence between the business system and the first-level menu, the upper and lower correspondence of the system menu, the correspondence between the last-level menu and the first-level business function point, and the upper and lower relationships in the business function point as edges, a "business system->system menu->business function point" graph model is constructed to realize the "ternary" conversion of the relationship from business system to menu level to business function point.

[0054] S15. Visually present the graph model of the business system-system menu-business function point.

[0055] Specifically, the "Business System->System Menu->Business Function Point" graph model in the background graph database is called, and the front-end develops the system menu structure diagram visualization function to graphically present the progressive relationship from the business system to the menu level to the business function point.

[0056] Based on the visual output of the system menu structure diagram, this embodiment provides step-by-step penetration and content scaling functions. Users can locate data resources in the system menu structure diagram according to the original usage habits of the original business system. This embodiment provides a global search function. Users can enter keywords such as business system, system menu, business function point, etc. at the front end, and the back-end graph database will explore and traverse the graph model, output the "business system->system menu->business function point" relationship path that meets business needs, and then assist users to quickly search for data resource locations.

[0057] S2. Create a data resource structure diagram, which includes the correspondence between background data tables and business function points.

[0058] This embodiment establishes the correspondence between business function points and data tables and fields in the background database based on the system menu structure diagram, and constructs a wide table view of business function points based on the data middle platform, so as to realize the correspondence between data resource details involved in the business function points of the front-end interface of the business system and the background data tables and fields. Based on the visual output of the shared wide table view, it provides the ability to understand data resources from a business perspective for the grassroots front-line of the power grid company, and assists users to quickly find the required data according to business needs.

[0059] In some embodiments, Figure 3 As shown, the creation of the data resource structure diagram includes:

[0060] S21. On the basis of the system menu structure diagram, a corresponding relationship between business function points and data tables and fields in the background database is established based on a relational database.

[0061] Specifically, on the basis of the system menu structure diagram, the correspondence between the business function points and the data tables and fields in the background database is established based on the relational database, involving information such as system code, menu code, function point code, function point business field, corresponding background database user name, corresponding background table name, corresponding background field name, whether to enumerate fields, corresponding wide table field name, etc.

[0062] S22. Based on the correspondence between business function points and data tables and fields in the background database, based on the distributed data warehouse of the data center, encapsulate the data retrieval logic SQL corresponding to the business function points to form the business wide table view corresponding to the business function points.

[0063] S23. Visually present the business wide table view corresponding to the business function point.

[0064] Specifically, on the basis of establishing the correspondence between business function points and data tables and fields in the background database and forming a business wide table view, the front-end develops a visual display function of the data resource structure diagram, which intuitively presents the information of the business function points corresponding to the background data tables and fields in the front-end interface of the business system in the form of a shared wide table view, and moves the "correspondence between the front-end function points and the background data tables" of the business system online, building a bridge connecting business data needs and the background data resources of the business system.

[0065] In this embodiment, users can directly trace back to the background data table corresponding to the front-end business function point of the business system through the data resource structure diagram, eliminating the previous repeated communication and confirmation steps with IT technicians familiar with the business system, reducing the time for data resource identification and judgment, and quickly finding the required data resources.

[0066] S3. Create a data relationship structure diagram, which includes the association relationship between data tables.

[0067] Based on the data resource structure diagram, this embodiment establishes the association relationship between data tables, draws the underlying data relationship logic corresponding to the business function points, and realizes the visualization output of data table information and the association relationship information between data tables in the form of ER diagram, providing the grassroots front-line of power grid companies with data resource understanding capabilities from a business perspective, and assisting users to quickly understand the assembly logic between background data tables.

[0068] In some embodiments, Figure 4 As shown, the creation of the data relationship structure diagram includes:

[0069] S31. On the basis of the data resource structure diagram, establish the association relationship between the background data tables of the business function points and the data tables based on the relational database.

[0070] Specifically, on the basis of the data resource structure diagram, the association relationship between the background data tables and data tables of the business function points is established based on the relational database, involving information such as the main table system code, the main table database user name, the main table name, the main table field name, the related table system code, the related table database user name, the related table name, and the related table field name.

[0071] S32. On the basis of establishing the association relationship between data tables, based on the graph database, with business function points and data tables as nodes, and the relationship between business function points and data tables, and the primary and foreign key relationships between data tables as edges, a graph model of business function points-data tables-data tables is constructed.

[0072] Specifically, on the basis of establishing the association relationship between the background data tables and the data tables, the underlying data relationship logic corresponding to the business function points is drawn based on the graph database. With business function points and data tables as nodes, and the relationship between business function points and data tables, and the primary and foreign key relationship between data tables as edges, a "business function point->data table->data table" graph model is constructed to realize the "ternary" conversion of the relationship between business function points and data tables, and between data tables.

[0073] S33. Visually present the business function point-data table-data table graph model.

[0074] Specifically, based on the construction of the "business function point -> data table -> data table" graph model, the front-end develops a data relationship structure diagram visualization function, presents the relationship between data tables under the business function point in the form of an ER diagram, and realizes the horizontal expansion of the relationship between data tables, providing the grassroots front-line of power grid companies with data resource understanding capabilities from a business perspective.

[0075] In this embodiment, the user can intuitively view the relationship between data tables under the business function point through the data relationship structure diagram, and expand the data relationship diagram horizontally by clicking, so as to help the user quickly understand the assembly logic between the background data tables.

[0076] S4. Create a data application flowchart and connect the data application flowchart with the data source of the data center.

[0077] Based on the data resource structure diagram and the data relationship structure diagram, the data application approval flow is integrated to build a data application process guide. Users can check the required wide table or single table data resources through the data resource structure diagram or the data relationship structure diagram, add to the shopping cart, submit the shopping cart, fill in the application reason, select the data range, and submit the data application. The system automatically generates a data application order, realizing "application and approval" for non-negative list data, saving users the workload of manually filling out data applications.

[0078] The data application process includes checking the data resources and adding them to the shopping cart, submitting the shopping cart, submitting the data application, and data application approval. Specifically, the data application process is as follows: the user checks the required wide table or single table data resources in the data resource structure diagram or the data relationship structure diagram and adds them to the shopping cart; the user enters the "shopping cart", checks the data resources to be applied for, submits the shopping cart, and the system automatically generates a data application order in the "application in progress" status; the user enters "my order", clicks on the data application order in the "application in progress" status, fills in the application reason, selects the data range, and submits the data application; the system integrates the data application approval flow, determines whether the applied data includes the negative list, and "approves upon application" for non-negative list data, and for negative list data, it is transferred to the corresponding data management department for approval before it takes effect.

[0079] S5. Create a middle-end data automatic acquisition module, which is used to generate a data acquisition SQL statement to acquire data after the data application order in the data application flow chart takes effect, and present the data acquisition result in the data application order.

[0080] The process of automatic data acquisition is as follows: after the data application order in the data application flow chart takes effect, the system background combines the applied wide table or single table data resources and the data acquisition range to dynamically generate the data acquisition SQL statement, access the distributed data warehouse of the data center, automatically acquire the data, and generate the data acquisition result table corresponding to the data application order, so as to realize the "approval and execution" of data acquisition and improve the efficiency of acquiring data needs; based on the data application order, the middle-office data is automatically acquired, and after the data acquisition result table is generated, the system background synchronously establishes the corresponding relationship between the "application order number" of the data application order and the "table name" of the data acquisition result table; the system accesses the data acquisition result table automatically generated by the distributed data warehouse of the data center, and presents the corresponding data content of the data acquisition result in the data application order.

[0081] Based on the data application flow chart, this embodiment connects the data application and data acquisition links of the data middle platform. Based on the data application results and in combination with the pre-construction of the business function point wide table view by the data middle platform, automatic data acquisition is realized, replacing the manual data acquisition link, and realizing "approval and execution" for data acquisition, thereby improving the efficiency of acquiring data needs.

[0082] S6. A fusion visualization reporting tool is used to access the data of the data acquisition result according to the table name information of the data acquisition result corresponding to the data application order, and generate a BI data set according to the data of the data acquisition result.

[0083] Based on the automatic acquisition of middle-end data, this embodiment integrates a visual reporting tool to achieve one-click jump of data acquisition results to the visual reporting tool, which is convenient for grassroots personnel to directly use the applied data and conduct self-service analysis online in real time, thus opening up the "last mile" of data use and improving data use efficiency.

[0084] Specifically, the integrated visualization reporting tool includes: setting up the visualization reporting tool; adding a button for jumping to the visualization reporting tool in the data application order data acquisition result presentation interface.

[0085] The working process of the visual report is as follows: the user clicks the jump button in the data application order to jump to the visual reporting tool, and transmits the data acquisition result table name information in the distributed data warehouse of the data center corresponding to the data application order to the visual reporting tool; the visual reporting tool obtains the "table name" of the data acquisition result table of the data center corresponding to the data application order, accesses the data of the data acquisition result table of the data center, and automatically generates a BI data set; based on the BI data set, users can conduct self-service data analysis online in real time, open up the "last mile" of data use, and improve data use efficiency.

[0086] In some embodiments, the architecture of the constructed data navigation map is as follows Figure 5 shown.

[0087] The above is only a preferred embodiment of the present invention. It should be understood that the present invention is not limited to the form disclosed herein, and should not be regarded as excluding other embodiments, but can be used in various other combinations, modifications and environments, and can be modified within the scope of the concept described herein through the above teachings or the technology or knowledge of the relevant field. The changes and modifications made by those skilled in the art shall not deviate from the spirit and scope of the present invention, and shall be within the scope of protection of the claims attached to the present invention.

Claims

1. A method for constructing a data navigation map for a power grid company, characterized in that: include: Creating a system menu structure diagram, wherein the system menu structure diagram includes a correspondence between a business system, a system menu, and business function points; Creating a data resource structure diagram, wherein the data resource structure diagram includes a correspondence between business function points and background data tables; Creating a data relationship structure diagram, wherein the data relationship structure diagram includes association relationships between data tables; Create a data application flow chart and connect the data application flow chart with the data source of the data center; Create a middle-end data automatic acquisition module, which is used to generate a data acquisition SQL statement to acquire data after the data application order in the data application flow chart takes effect, and present the data acquisition result in the data application order; A fusion visualization report tool is used to access the data of the data acquisition result according to the table name information of the data acquisition result corresponding to the data application order, and generate a BI data set according to the data of the data acquisition result; The creation of the system menu structure diagram includes: The system menu of the business system is defined from the first-level menu to the last-level menu, from the last-level menu to the first-level business function point, and from the first-level business function point to the last-level business function point; Establish the hierarchical structure correspondence of the system menu based on the relational database; On the basis of establishing the hierarchical structure correspondence of the system menu, the business function points corresponding to the last-level menu page are refined step by step, and the correspondence between the last-level menu and the business function points is established based on the relational database; On the basis of establishing the hierarchical structure correspondence of the system menu and the correspondence between the final menu and the business function point, based on the graph database, with the business system, system menu and business function point as nodes, and with the correspondence between the business system and the first-level menu, the upper-lower correspondence between the system menu, the correspondence between the final menu and the first-level business function point, and the upper-lower relationship in the business function point as edges, a graph model of the business system-system menu-business function point is constructed; The graph model of the business system-system menu-business function point is visualized.

2. The method for constructing a data navigation map for a power grid company according to claim 1, characterized in that: The creating of the data resource structure diagram comprises: On the basis of the system menu structure diagram, the corresponding relationship between business function points and data tables and fields in the background database is established based on the relational database; Based on the correspondence between business function points and data tables and fields in the backend database, the data retrieval logic SQL corresponding to the business function points is encapsulated based on the distributed data warehouse of the data center to form the business wide table view corresponding to the business function points; The business wide table view corresponding to the business function point is visualized.

3. The method for constructing a data navigation map for a power grid company according to claim 1, characterized in that: The creating of the data relationship structure diagram comprises: On the basis of the data resource structure diagram, the relationship between the background data tables of business function points and data tables is established based on the relational database; On the basis of establishing the association relationship between data tables, based on the graph database, with business function points and data tables as nodes, and the relationship between business function points and data tables, and the primary and foreign key relationship between data tables as edges, a graph model of business function points-data tables-data tables is constructed; The business function point-data table-data table graph model is visualized.

4. The method for constructing a data navigation map for a power grid company according to claim 1, characterized in that: The data application process includes checking the data resources to add to the shopping cart, submitting the shopping cart, submitting the data application and data application approval.

5. The method for constructing a data navigation map for a power grid company according to claim 1, characterized in that: The fusion visualization reporting tool includes: Set up a visual reporting tool; add a button to jump to the visual reporting tool in the data application order retrieval result presentation interface.

6. The method for constructing a data navigation map for a power grid company according to claim 1, characterized in that: The system menu structure diagram is visually presented in a graphical form.

7. The method for constructing a data navigation map for a power grid company according to claim 1, characterized in that: The data resource structure diagram is visually presented in the form of a shared wide table view.

8. The method for constructing a data navigation map for a power grid company according to claim 1, characterized in that: The data relationship structure diagram is visually presented in the form of an ER diagram.

Images