CN114254160A - Construction method of data navigation map for power grid company - Google Patents

Construction method of data navigation map for power grid company Download PDF

Info

Publication number
CN114254160A
CN114254160A CN202111404965.3A CN202111404965A CN114254160A CN 114254160 A CN114254160 A CN 114254160A CN 202111404965 A CN202111404965 A CN 202111404965A CN 114254160 A CN114254160 A CN 114254160A
Authority
CN
China
Prior art keywords
data
service function
menu
function point
service
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111404965.3A
Other languages
Chinese (zh)
Inventor
周里涛
杨迎春
徐厚东
张瑞强
曾愚
龚燕
游雨嘉
李赋欣
粟之梁
王宇飞
唐剑
刘琪
卿岛
金鑫
蒋何
王锐杰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Sichuan Electric Power Co Ltd
Original Assignee
State Grid Sichuan Electric Power Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by State Grid Sichuan Electric Power Co Ltd filed Critical State Grid Sichuan Electric Power Co Ltd
Priority to CN202111404965.3A priority Critical patent/CN114254160A/en
Publication of CN114254160A publication Critical patent/CN114254160A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/901Indexing; Data structures therefor; Storage structures
    • G06F16/9024Graphs; Linked lists
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/06Electricity, gas or water supply

Abstract

The invention discloses a construction method of a data navigation map for a power grid company, which comprises the following steps: creating a system menu structure diagram; creating a data resource structure chart; creating a data relation structure chart; establishing a data application flow chart and communicating the data application flow chart with a data source of a data center station; creating a middle station data automatic acquisition module; and fusing a visual report tool. According to the method, a system menu structure chart, a data resource structure chart and a data relation structure chart are established according to a business system-menu hierarchy-business function point-data table relation mode, a data middle station data and a visual report tool are fused, a data navigation system of a basic layer one-line business visual angle is established, a bridge connecting foreground business data requirements and system background data resources is established, data traceability efficiency and data use efficiency of basic layer one-line business personnel are improved, and the problems that basic layer one-line personnel data are difficult to find, understand, acquire and use are solved.

Description

Construction method of data navigation map for power grid company
Technical Field
The invention relates to the technical field of power grid data processing, in particular to a construction method of a data navigation map for a power grid company.
Background
The development of mass data processing technology is accelerated due to the arrival of the big data and cloud computing era, centralized convergence and unified management of enterprise data resources are realized by data middlings and data catalogs constructed by power grid companies at different times, and with the deep advance of digital transformation of power grid enterprises to the basic level, the data innovation application requirement of the basic level is more and more vigorous, and higher requirements are provided for the visibility, the viewability, the accessibility and the availability of data. On the whole, the problems that the business requirements and data are difficult to correspond, the data cannot be directly used and the like exist when a power grid company pushes data to enable the first line at the basic level, and the effects of data superposition, multiplication and amplification are still not fully released. Firstly, the business demand corresponds the difficulty with data, the phenomenon of basic level an organic whole line "difficult finding, difficult reading understand" data still exists, the current data directory of electric wire netting company mainly uses technical visual angle as the main structure, business language and data language lack the high-efficient bridge of connecting, a line of user in basic level is difficult to directly read and understands backstage data table, IT supports to need IT personnel, and IT personnel are difficult to be familiar with the business comprehensively, lead to that conversion efficiency is lower between data and the business demand, the data demand often will be through a large amount of check-ups and confirm repeatedly, just can final satisfaction. Secondly, data cannot be directly used, the phenomenon that the primary-line data is difficult to acquire and use still exists, a data service of a power grid company based on a data center platform is mainly provided by means of an API (application program interface) interface and the like, the data acquisition strongly depends on IT (information technology) technicians, a simple and easy-to-use data analysis tool is lacked after the data is acquired, a threshold exists in the use of the data, the primary-line data analysis of the primary level needs to obtain no timely response, and the autonomous acquisition and the rapid analysis of the primary-line data personnel on the primary level to the data are restricted. How to realize data business oriented to the basic level and enable data to the basic level becomes a difficult problem in front of a power grid company.
Disclosure of Invention
The invention aims to overcome one or more defects in the prior art and provides a construction method of a data navigation map for a power grid company.
The purpose of the invention is realized by the following technical scheme: the construction method of the data navigation map facing to the power grid company comprises the following steps:
creating a system menu structure chart, wherein the system menu structure chart comprises a corresponding relation among a service system, a system menu and service function points;
creating a data resource structure chart, wherein the data resource structure chart comprises a corresponding relation between a service function point and a background data table;
creating a data relation structure chart, wherein the data relation structure chart comprises an incidence relation between a data table and the data table;
establishing a data application flow chart and communicating the data application flow chart with a data source of a data center station;
creating a central data automatic acquisition module, wherein the central data automatic acquisition module is used for generating an access SQL statement for accessing after a data application order in the data application flow chart takes effect, and presenting an access result in the data application order;
and the visual report tool is fused and used for accessing the data of the access result according to the table name information of the access result corresponding to the data application order and generating a BI data set according to the data of the access result.
Preferably, the creating a system menu structure diagram includes:
defining a system menu of a service system from a first-level menu to a last-level menu, from the last-level menu to a first-level service function point, and from the first-level service function point to a last-level service function point;
establishing a hierarchical structure corresponding relation of a system menu based on a relational database;
on the basis of establishing the corresponding relation of the hierarchical structure of the system menu, service function points corresponding to a final menu page are refined step by step, and the corresponding relation between the final menu and the service function points is established on the basis of a relational database;
on the basis of establishing a hierarchical structure corresponding relation of a system menu and a corresponding relation between a final menu and a service function point, constructing an atlas model of the service system, the system menu and the service function point by taking a service system, the system menu and the service function point as nodes, and taking a corresponding relation between the service system and a first-level menu, a corresponding relation between the upper level and the lower level of the system menu, a corresponding relation between the final menu and the first-level service function point and an upper-lower level relation among the service function points as edges on the basis of a graph database;
and visually presenting the atlas model of the service system-system menu-service function point.
Preferably, the creating a data resource structure diagram includes:
on the basis of a system menu structure diagram, establishing a corresponding relation between a service function point and a data table and a field in a background database based on a relational database;
on the basis of the corresponding relation between the service function point and the data table and field in the background database, packaging access logic SQL corresponding to the service function point based on a data intermediate station distributed data warehouse, and forming a service wide table view corresponding to the service function point;
and visually presenting the service wide table view corresponding to the service function point.
Preferably, the creating a data relationship structure diagram includes:
on the basis of the data resource structure chart, establishing an incidence relation between a background data table and a data table of the service function point based on a relational database;
on the basis of establishing an incidence relation between a data table and a data table, constructing a map model of the service function point-the data table based on a map database, by taking the service function point and the data table as nodes, and taking the relation between the service function point and the data table and the main foreign key relation between the data tables as edges;
and visually presenting the atlas model of the business function point-data sheet.
Preferably, the data application process comprises checking data resources to join a shopping cart, submitting the shopping cart, submitting a data application and examining and approving the data application.
Preferably, the fusion visualization reporting tool includes:
setting a visual report tool;
and adding a button for jumping to a visual report tool in a data application order fetching result presentation interface.
Preferably, the system menu structure diagram is visually presented in a mapping form.
Preferably, the data resource structure diagram is visually presented in a shared wide-list view form.
Preferably, the data relation structure chart is visually presented in an E-R chart form.
The invention has the beneficial effects that:
(1) according to the method, a system menu structure chart, a data resource structure chart and a data relation structure chart are constructed in a mode of 'business system-menu hierarchy-business function point-data table relation', a data navigation system of a basic level one-line business visual angle is established, a bridge connecting foreground business data requirements and system background data resources is built, data tracing efficiency of basic level one-line business personnel is improved, and the problem that basic level one-line personnel data are difficult to find and understand is solved;
(2) the method is based on a system menu structure chart, a data resource structure chart and a data relation structure chart, constructs a data application flow chart, integrates a data access flow and a visual analysis tool which run through a data center, realizes autonomous application, automatic data access and self-service analysis of required data, gets through the last kilometer used by base layer user data, improves data application efficiency and acquisition efficiency, reduces the data use threshold of base layer first-line business personnel, and solves the problem that the data of the base layer first-line personnel is difficult to obtain and use;
(3) the invention changes the basic level oriented data service mode of the power grid company from the prior mode of 'requirement initiation and repeated confirmation' into the self-service mode of 'multi-party participation and co-construction sharing'; the basic level line can effectively exert subjective initiative and develop autonomous tracing through the data navigation map, so that required data can be acquired more conveniently and accurately, enthusiasm of basic level users for using data is stimulated, and data value is released continuously; the data service provider has more energy to concentrate on the construction of data service capacity, the transformation from data operation and maintenance to data operation is realized, and a co-construction shared data operation system is constructed.
Drawings
FIG. 1 is a flow chart of a method for constructing a data navigation map for a power grid company;
FIG. 2 is a flow chart for creating a system menu structure diagram;
FIG. 3 is a flow chart of creating a data resource structure diagram;
FIG. 4 is a flow chart of creating a data relationship structure diagram;
FIG. 5 is a schematic diagram of the architecture of a data navigation map.
Detailed Description
The technical solutions of the present invention will be described clearly and completely with reference to the following embodiments, and it should be understood that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without inventive effort based on the embodiments of the present invention, are within the scope of the present invention.
Referring to fig. 1 to 5, the embodiment provides a method for constructing a data navigation map for a power grid company:
as shown in fig. 1, the method for constructing a data navigation map for a power grid company includes:
s1, creating a system menu structure chart, wherein the system menu structure chart comprises a service system, a system menu and a corresponding relation between service function points.
The embodiment establishes a corresponding relation between a system menu level structural relation final-stage menu and a service function point of a service system around a core service system in the field of power grid production and operation management, realizes the visual output of corresponding relation information between the service system, the system menu and the service function point based on a knowledge graph, provides functions of step-by-step penetration, content expansion, global search and the like for a basic level line of a power grid company, and assists a user to quickly search and locate data resource positions according to a graph-solicited relation according to the original use habit of the service system.
In some embodiments, as shown in fig. 2, the creating a system menu structure diagram includes:
s11, defining a system menu of the service system, wherein the system menu comprises a first-level menu to a last-level menu, the last-level menu to a first-level service function point, and the first-level service function point to a last-level service function point.
And S12, establishing a corresponding relation of a hierarchical structure of the system menu based on the relational database.
Specifically, a core service system in the fields of power grid production and operation management is surrounded, a hierarchical structure corresponding relation of a system menu of the service system is established based on a relational database, and information such as system codes, system names, menu codes, menu names, menu hierarchies, menu sequencing, whether a last-level menu is coded or not, upper-level menu codes and the like is related.
And S13, on the basis of establishing the corresponding relation of the hierarchical structure of the system menu, refining the service function points corresponding to the final menu page step by step, and establishing the corresponding relation between the final menu and the service function points on the basis of a relational database.
Specifically, on the basis of establishing the hierarchical structure corresponding relation of the system menu, service function points corresponding to a last-stage menu page are refined step by step, wide table names of the service function points are defined, and the corresponding relation between the last-stage menu and the service function points is established on the basis of a relational database, relating to information such as system codes, menu codes, function point names, function point sequencing, function point hierarchies, upper-stage function point codes, corresponding wide table names and the like.
S14, on the basis of establishing the corresponding relation of the hierarchical structure of the system menu and the corresponding relation between the final menu and the service function points, based on the graph database, the service system, the system menu and the service function points are taken as nodes, and the graph model of the service system, the system menu and the service function points is constructed by taking the corresponding relation between the service system and the first-level menu, the corresponding relation between the upper level and the lower level of the system menu, the corresponding relation between the final menu and the first-level service function points and the upper level and the lower level of the service function points as edges.
Specifically, on the basis of establishing a hierarchical structure corresponding relationship of a system menu and a corresponding relationship between a last-level menu and a service function point, a map model of 'service system- > system menu- > service function point' is established by taking the service system, the system menu and the service function point as nodes, taking the corresponding relationship between the service system and a first-level menu, the corresponding relationship between the system menu and the upper and lower levels, the corresponding relationship between the last-level menu and the first-level service function point and the upper and lower levels of the service function point as edges, so that 'ternary' conversion from the service system to the menu hierarchy to the service function point is realized.
And S15, visually presenting the atlas model of the service system, the system menu and the service function point.
Specifically, a service system-system menu-service function point atlas model in a background graph database is called, a system menu structure diagram visual display function is developed at the front end, and a layer-by-layer progressive relation from a service system to a menu level to a service function point is presented in an atlas manner.
The embodiment provides the functions of step-by-step penetration and content expansion and contraction on the basis of the visual output of the system menu structure diagram, and a user can locate the position of a data resource in the system menu structure diagram according to an original using habit of an original service system by a clue; the embodiment provides a global retrieval function, and a user can search and traverse a map model by inputting keywords such as a service system, a system menu, a service function point and the like at a front end and outputting a relation path of 'service system- > system menu- > service function point' meeting service requirements, so as to assist the user in quickly searching data resource positions.
And S2, creating a data resource structure chart, wherein the data resource structure chart comprises a corresponding relation between a background data table and the service function point.
In the embodiment, the corresponding relation between the service function point and the data table and the field in the background database is established on the basis of the system menu structure diagram, the wide table view of the service function point is established on the basis of the data center, the visual output of the data resource details, the background data table and the corresponding relation of the field related to the service function point of the foreground interface of the service system based on the shared wide table view is realized, the data resource understanding capability of the service view angle is provided for the first line of the base layer of the power grid company, and the user is assisted to quickly search the required data by combining with the service requirements.
In some embodiments, as shown in fig. 3, the creating a data resource structure diagram includes:
and S21, on the basis of the system menu structure chart, establishing a corresponding relation between the service function point and a data table and a field in a background database based on a relational database.
Specifically, on the basis of a system menu structure diagram, a corresponding relation between a service function point and a data table and a field in a background database is established based on a relational database, and the information relates to system codes, menu codes, function point service fields, corresponding background database user names, corresponding background table names, corresponding background field names, whether fields are enumerated or not, corresponding wide table field names and the like.
And S22, on the basis of the corresponding relation between the service function point and the data table and the field in the background database, packaging the access logic SQL corresponding to the service function point based on the distributed data warehouse of the data center, and forming a service wide table view corresponding to the service function point.
And S23, visually presenting the service wide table view corresponding to the service function point.
Specifically, on the basis of establishing the corresponding relation between the service function point and the data table and field in the background database and forming a service wide table view, the front end develops a visual display function of a data resource structure diagram, visually presents the information of the corresponding background data table and field of the service function point of the foreground interface of the service system in the form of sharing the wide table view, moves the corresponding relation between the foreground function point and the background data table of the service system to the on-line, and builds a bridge for connecting the service data requirement and the background data resource of the service system.
In this embodiment, the user can directly trace to the background data table corresponding to the foreground service function point of the service system through the data resource structure diagram, so that the previous links of repeated communication and confirmation with an IT technician familiar with the service system are omitted, the time for identifying and judging the data resources is reduced, and the required data resources are quickly searched.
And S3, creating a data relation structure chart, wherein the data relation structure chart comprises an incidence relation between a data table and the data table.
In this embodiment, on the basis of the data resource structure diagram, an association relationship between the data tables is established, a bottom layer data relationship logic corresponding to the service function point is drawn, visual output of data table information and inter-data table association relationship information based on an E-R graph form is realized, data resource understanding ability of a service view angle is provided for a first line of a base layer of a power grid company, and a user is assisted in quickly reading and understanding an assembly logic between background data tables.
In some embodiments, as shown in fig. 4, the creating the data relationship structure diagram includes:
and S31, on the basis of the data resource structure chart, establishing an association relation between a background data table and a data table of the service function point based on the relational database.
Specifically, on the basis of the data resource structure diagram, an association relationship between a background data table of a service function point and the data table is established based on a relational database, and information such as a main table system code, a main table database user name, a main table name, a main table field name, an association table system code, an association table database user name, an association table field name and the like is related.
S32, on the basis of establishing the incidence relation between the data tables, based on the graph database, the graph model of the business function point-data table is constructed by taking the business function point and the data tables as nodes, taking the relation between the business function point and the data tables and the main foreign key relation between the data tables as edges.
Specifically, on the basis of establishing an association relationship between a background data table and a data table, a bottom layer data relationship logic corresponding to a service function point is drawn based on a graph database, the service function point and the data table are used as nodes, a main foreign key relationship between the service function point and the data table and between the data tables is used as an edge, and a map model of 'service function point- > data table' is established, so that 'ternary' conversion between the service function point and the data table and between the data table and the data table is realized.
And S33, visually presenting the atlas model of the business function point, the data sheet and the data sheet.
Specifically, on the basis of building a 'service function point- > data table' map model, a front end develops a data relation structure diagram visual display function, presents the association relation between the data tables under the service function point in an E-R graph mode, realizes the transverse expansion of the relation between the data tables, and provides data resource understanding capability of a service view angle for a first line of a power grid company base level.
In the embodiment, a user can visually check the relation between the data tables under the service function point through the data relation structure chart, and the data relation map is transversely expanded through clicking to assist the user in quickly reading and understanding the assembly logic between the background data tables.
And S4, creating a data application flow chart and communicating the data application flow chart with a data source of the data center station.
On the basis of a data resource structure diagram and a data relation structure diagram, a data application approval flow is fused to construct a data application flow guide, a user can select required wide-form or single-form data resources, add a shopping cart, submit the shopping cart, fill application affairs, select a data range and submit a data application through the data resource structure diagram or the data relation structure diagram, the system automatically generates a data application order, the non-negative list data 'application, namely approval' is realized, and the workload of manually filling the data application by the user is saved.
The data application process comprises the steps of checking data resources, adding the data resources into a shopping cart, submitting the shopping cart, submitting data applications and examining and approving the data applications. Specifically, the data application process is as follows: a user selects required wide-list or single-list data resources from the data resource structure chart or the data relation structure chart and adds the data resources into a shopping cart; a user enters a shopping cart, a data resource to be applied is selected, the shopping cart is submitted, and a data application order in an application state is automatically generated by the system; the user enters the My order, clicks the data application order in the 'application in' state, fills the application foundation, selects the data range and submits the data application; the system fuses data application approval flows, judges whether the applied data comprise negative lists, and transfers the data to a corresponding data gate department for approval and then takes effect aiming at the data of the non-negative lists, namely the data of the application is approved.
And S5, creating a middle station data automatic acquisition module, wherein the middle station data automatic acquisition module is used for generating an access SQL statement for accessing after a data application order in the data application flow chart takes effect, and presenting an access result in the data application order.
The automatic access process comprises the following steps: after the data application order in the data application flow chart takes effect, the background of the system dynamically splices and generates an access SQL statement by combining the data resources of the wide table or the single table and the access range, accesses a distributed data warehouse of a data center, automatically acquires data, generates an access result table corresponding to the data application order, realizes 'examination and approval as execution' of data acquisition, and improves the acquisition efficiency of data requirements; automatically acquiring the middlebox data based on the data application order, and after generating the data acquisition result table, synchronously establishing a corresponding relation between the 'order application number' of the data application order and the 'table name' of the data acquisition result table by the system background; the system accesses a data access result table automatically generated by a distributed data warehouse in the data, and presents corresponding data content of the data access result in the data application order.
According to the embodiment, on the basis of a data application flow chart, a data application and data intermediate station access link is run through, based on a data application result, a service function point wide table view is constructed in advance by combining the data intermediate station, automatic access is realized, a manual access link is replaced, data acquisition' examination and approval are realized, and the acquisition efficiency of data requirements is improved.
And S6, fusing a visual report tool, wherein the visual report tool is used for accessing data of the access result according to the table name information of the access result corresponding to the data application order and generating a BI data set according to the data of the access result.
On the basis of the automatic acquisition of the data of the middle station, the visual report tool is integrated, the data acquisition result is skipped to the visual report tool by one key, the basic personnel can directly use the applied data conveniently, the self-service analysis can be carried out on line immediately, the data can be communicated for use for the last kilometer, and the use efficiency of the data is improved.
Specifically, the fusion visualization report tool includes: setting a visual report tool; and adding a button for jumping to a visual report tool in a data application order fetching result presentation interface.
The working process of the visual report is as follows: a user clicks a skip button in a data application order, skips to a visual report tool, and transmits the name information of the data acquisition result in the data intermediate platform distributed data warehouse corresponding to the data application order to the visual report tool; the visualization report tool obtains the 'table name' of the data access result table in the data corresponding to the data application order, accesses the data of the data access result table in the data and automatically generates a BI data set; the user can immediately carry out the self-service analysis of the data on line on the basis of the BI data set, get through the last kilometer of the data, and improve the use efficiency of the data.
In some embodiments, the architecture of the constructed data navigation map is shown in FIG. 5.
The foregoing is illustrative of the preferred embodiments of this invention, and it is to be understood that the invention is not limited to the precise form disclosed herein and that various other combinations, modifications, and environments may be resorted to, falling within the scope of the concept as disclosed herein, either as described above or as apparent to those skilled in the relevant art. And that modifications and variations may be effected by those skilled in the art without departing from the spirit and scope of the invention as defined by the appended claims.

Claims (9)

1. The construction method of the data navigation map facing to the power grid company is characterized by comprising the following steps:
creating a system menu structure chart, wherein the system menu structure chart comprises a corresponding relation among a service system, a system menu and service function points;
creating a data resource structure chart, wherein the data resource structure chart comprises a corresponding relation between a service function point and a background data table;
creating a data relation structure chart, wherein the data relation structure chart comprises an incidence relation between a data table and the data table;
establishing a data application flow chart and communicating the data application flow chart with a data source of a data center station;
creating a central data automatic acquisition module, wherein the central data automatic acquisition module is used for generating an access SQL statement for accessing after a data application order in the data application flow chart takes effect, and presenting an access result in the data application order;
and the visual report tool is fused and used for accessing the data of the access result according to the table name information of the access result corresponding to the data application order and generating a BI data set according to the data of the access result.
2. The method for constructing the data navigation map for the power grid company as claimed in claim 1, wherein the creating a system menu structure diagram comprises:
defining a system menu of a service system from a first-level menu to a last-level menu, from the last-level menu to a first-level service function point, and from the first-level service function point to a last-level service function point;
establishing a hierarchical structure corresponding relation of a system menu based on a relational database;
on the basis of establishing the corresponding relation of the hierarchical structure of the system menu, service function points corresponding to a final menu page are refined step by step, and the corresponding relation between the final menu and the service function points is established on the basis of a relational database;
on the basis of establishing a hierarchical structure corresponding relation of a system menu and a corresponding relation between a final menu and a service function point, constructing an atlas model of the service system, the system menu and the service function point by taking a service system, the system menu and the service function point as nodes, and taking a corresponding relation between the service system and a first-level menu, a corresponding relation between the upper level and the lower level of the system menu, a corresponding relation between the final menu and the first-level service function point and an upper-lower level relation among the service function points as edges on the basis of a graph database;
and visually presenting the atlas model of the service system-system menu-service function point.
3. The method for constructing the data navigation map for the power grid company as claimed in claim 1, wherein the creating the data resource structure diagram comprises:
on the basis of a system menu structure diagram, establishing a corresponding relation between a service function point and a data table and a field in a background database based on a relational database;
on the basis of the corresponding relation between the service function point and the data table and field in the background database, packaging access logic SQL corresponding to the service function point based on a data intermediate station distributed data warehouse, and forming a service wide table view corresponding to the service function point;
and visually presenting the service wide table view corresponding to the service function point.
4. The method for constructing the data navigation map for the power grid company as claimed in claim 1, wherein the creating the data relationship structure diagram comprises:
on the basis of the data resource structure chart, establishing an incidence relation between a background data table and a data table of the service function point based on a relational database;
on the basis of establishing an incidence relation between a data table and a data table, constructing a map model of the service function point-the data table based on a map database, by taking the service function point and the data table as nodes, and taking the relation between the service function point and the data table and the main foreign key relation between the data tables as edges;
and visually presenting the atlas model of the business function point-data sheet.
5. The method for constructing the data navigation map facing the power grid company as claimed in claim 1, wherein the data application process comprises checking data resources to join a shopping cart, submitting the shopping cart, submitting a data application and examining and approving the data application.
6. The method for constructing the data navigation map for the power grid company as claimed in claim 1, wherein the fusion visualization report tool comprises:
setting a visual report tool;
and adding a button for jumping to a visual report tool in a data application order fetching result presentation interface.
7. The method for constructing the data navigation map for the power grid company as claimed in claim 1, wherein the system menu structure map is visually presented in a mapping form.
8. The method for constructing the data navigation map for the power grid company as claimed in claim 1, wherein the data resource structure map is visually presented in a shared wide-form view.
9. The construction method of the data navigation map for the power grid company as claimed in claim 1, wherein the data relationship structure diagram is visually presented in an E-R diagram form.
CN202111404965.3A 2021-11-24 2021-11-24 Construction method of data navigation map for power grid company Pending CN114254160A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111404965.3A CN114254160A (en) 2021-11-24 2021-11-24 Construction method of data navigation map for power grid company

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111404965.3A CN114254160A (en) 2021-11-24 2021-11-24 Construction method of data navigation map for power grid company

Publications (1)

Publication Number Publication Date
CN114254160A true CN114254160A (en) 2022-03-29

Family

ID=80791120

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111404965.3A Pending CN114254160A (en) 2021-11-24 2021-11-24 Construction method of data navigation map for power grid company

Country Status (1)

Country Link
CN (1) CN114254160A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115357671A (en) * 2022-10-19 2022-11-18 成都飞机工业(集团)有限责任公司 Method, device, equipment and medium for constructing aircraft assembly data

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115357671A (en) * 2022-10-19 2022-11-18 成都飞机工业(集团)有限责任公司 Method, device, equipment and medium for constructing aircraft assembly data
CN115357671B (en) * 2022-10-19 2023-01-10 成都飞机工业(集团)有限责任公司 Method, device, equipment and medium for constructing aircraft assembly data

Similar Documents

Publication Publication Date Title
CN111192004A (en) Method for displaying current to-do task and subsequent to-do workflow
CN114186984B (en) Two-dimensional and three-dimensional integrated collaborative design system for architectural design enterprise
CN102208064A (en) Administrative collaborative approval system and approval method
Xu et al. Developing an IFC-based database for construction quality evaluation
Zhu et al. Web-based construction document processing via malleable frame
TWI453608B (en) System and method for managing a large number of multiple data
CN113204329A (en) Control method for driving business application by unified data model and application system thereof
CN110795848B (en) Large-scale commercial complex logistics intelligent operation and maintenance method
CN115757689A (en) Information query system, method and equipment
CN111061756B (en) Data platform, data processing method and electronic equipment
CN114254160A (en) Construction method of data navigation map for power grid company
CN113642850A (en) Data fusion method and terminal for power distribution network planning
CN113722564A (en) Visualization method and device for energy and material supply chain based on space map convolution
CN111784192A (en) Industrial park emergency plan executable system based on dynamic evolution
CN111581302A (en) Decision-making assisting system based on data warehouse
CN112116320A (en) Intelligent scoring method for talent evaluation
CN111708827A (en) Real estate unit coding system
CN106155665B (en) Conformity evidence-presenting system and method
CN113342987A (en) Composite network construction method of special corpus for power distribution DTU acceptance
CN112328667A (en) Shale gas field ground engineering digital handover method based on data blooding margin
CN111178026A (en) Method for realizing operation analysis report of special line for collecting passenger
US20240028822A1 (en) Contextual answer generation in spreadsheets
KR102443722B1 (en) Computerized managing system for deriving building authorizing regulations and for providing checklist of each regulations, and method for the same
Engels et al. INTEGRATED NETWORK DEVELOPMENT & PLANNING-from forecasting to grid screening and concepts
Borges et al. Towards an approach to elicit domain requirements from social networks: The case of emergency systems

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination