A multi-element visualized data model construction method and system

Abstract

A kind of multi-element visual data model construction method and system, characterized in that, the method includes the following steps: step 1, real-time acquisition database in the entity table with merging demand, and all attributes in each described information of all attributes in the entity table;Step 2, based on the information in step 1, the association between two entity tables is obtained in turn, the association between multiple transition business tables;Step 3, based on the association in step 2, automatically generate database query statement, to generate final business table.The method of the application solves the dilemma that power grid operation and maintenance personnel face when facing multiple entity tables, and associates the entity table selected by the operation and maintenance personnel in real time, and judges and improves the most reasonable generation mode of the final business table according to the content of the transition business table.

Description

TECHNICAL FIELD

[0001] The present application relates to the field of database, more particularly, to a multi-element visualized data model construction method and system. BACKGROUND

[0002] With the rapid development of information technology such as Internet, Internet of Things, cloud computing, a large amount of unstructured information is constantly emerging, and the demand for data visualization and visualization analysis of data platforms is increasing, and the cost of visualization development is increasing. In the era of big data, the previous data storage method cannot meet the needs of social development, for example, in the process of the development of the power system, a large amount of power grid operation data cannot be effectively analyzed and managed, and the value of data is difficult to play. Through the visualization technology, the data of the power system can be displayed, which is convenient for quickly and accurately understanding the data, and thus improving the response ability of solving the problems of the power system. For the operation and maintenance personnel of the power system, the correlation between various data entities is obtained through the visualized data model, and the connotation and essence of the data are accurately grasped, and the establishment process of the visualized data model is essential.

[0003] On the other hand, the distribution network refers to the power grid that accepts electric energy from the transmission network or the regional power plant and distributes it to various users through distribution facilities or step by step according to voltage. In the distribution network, the types of automatic data are various, the data structures are different, and the data volume is large. The current traditional method of describing the monitoring process and monitoring results of the distribution network in the form of report and fixed picture and text has been unable to meet the increasing business monitoring, risk early warning, geographic information analysis and other business needs. Data modeling of distribution network automation data can handle increasingly complex visualization needs and reduce the complexity of visualization data processing, and according to the specific situation and needs, the most suitable data model is selected to achieve the best visualization effect.

[0004] However, there is no visualized data processing method convenient for the power grid operation and maintenance personnel to associate data in the prior art. SUMMARY

[0005] In order to solve the problems in the prior art, the purpose of the present application is to provide a multi-element visualized data model construction method and system, which generates a final business table by associating a transition business table after combining entity tables existing in a database in pairs.

[0006] The present application adopts the following technical solutions.

[0007] The first aspect of the present application relates to a multi-element visualized data model construction method, wherein the method comprises the following steps: step 1, acquiring in real time an entity table with merging requirements in a database, and all attributes in each entity table and description information of all attributes; step 2, based on the information in step 1, acquiring in sequence the association relationship between two entity tables and the association relationship between a plurality of transition business tables; and step 3, based on the association relationship in step 2, automatically generating a database query statement to generate a final business table.

[0008] Preferably, the association relationship between the two entity tables is realized by selecting an attribute in a certain entity table and selecting an attribute in another entity table, and then one-to-one correspondence of the attributes.

[0009] Preferably, the description information of the selected attribute in a certain entity table and the attribute in another entity table is the same.

[0010] Preferably, the transition business table is acquired based on the association relationship between the two entity tables.

[0011] Preferably, the association relationship between the plurality of transition business tables is generated based on the association relationship between any two transition business tables in the plurality of transition business tables; the association relationship between any two transition business tables is realized by selecting an attribute in a certain transition business table and selecting an attribute in another transition business table, and then one-to-one correspondence of the attributes.

[0012] Preferably, the final business table is acquired based on the association relationship between the plurality of transition business tables; wherein the description information of all attributes in the final business table is determined, and when the description information is time or region, the attribute is added as a dimension index of the final business table.

[0013] Preferably, the one-to-one correspondence mode includes left join, right join, inner join and outer join; based on the different connection modes, all attributes in the transition business table and the final business table are sorted.

[0014] Preferably, the attribute value under a plurality of attributes in the final business table is calculated based on a self-defined comprehensive index to obtain a value of the comprehensive index; the comprehensive index and the value of the comprehensive index are added to the final business table as a new attribute in the final business table.

[0015] Preferably, the database query statement is used to directly extract the corresponding attribute from each entity table to generate the transition business table or the final business table.

[0016] The second aspect of the present application relates to a multi-element visualized data model construction system, which adopts the multi-element visualized data model construction method described in the first aspect of the present application.

[0017] The beneficial effects of the present application are that, compared with the prior art, the multi-element visualized data model construction method and system in the present application can generate a final business table by combining existing entity tables in a database two by two and then associating the transition business table. The method of the present application solves the dilemma of power grid operation and maintenance personnel when facing multiple entity tables, associates the entity table selected by the operation and maintenance personnel in real time, and judges and improves the most reasonable generation method of the final business table according to the content of the transition business table.

[0018] The beneficial effects of the present application also include:

[0019] 1. Since the method can judge the next operation mode according to the number of entity tables selected by the operation and maintenance personnel in real time, the operation and maintenance personnel can be prompted at any time about the number of existing entity tables and the need to increase the selection of entity tables, so that the visualized process is more friendly.

[0020] 2. The two entity tables are connected in multiple different connection modes, so that the display order of multiple attributes in the generated transition business table can be conveniently adjusted to meet the needs of the operation and maintenance personnel.

[0021] 3. The final business table is generated through multiple steps, and when a temporary transition business table is generated, the display content of the data in the visualized transition business table is provided, which enables the operation and maintenance personnel to more clearly understand whether the synthesized transition business table can meet the needs of the operation and maintenance business, thereby facilitating the operation and maintenance personnel to generate the optimal final business table through multiple adjustments.

[0022] 4. The present application automatically generates a database query statement, which enables the actual data extraction process in the final business table to be implemented in the simplest programming mode, although there is a lot of redundancy in the visualized generation process of the final business table, so that the processing process of massive data minimizes the occupation of processors and storage devices, and the generation of the final business table is more rapid and accurate. BRIEF DESCRIPTION OF DRAWINGS

[0023] Figure 1 The figure is a step schematic diagram of the multi-element visualized data model construction method of the present application. DETAILED DESCRIPTION

[0024] The present application will be further described below in conjunction with the drawings. The following examples are only used to more clearly illustrate the technical solutions of the present application, and cannot limit the protection scope of the present application.

[0025] Figure 1 The figure is a step schematic diagram of the multi-element visualized data model construction method of the present application. As Figure 1As shown, a multi-element visualized data model construction method, the method comprising steps 1 to 3.

[0026] Step 1, real-time acquisition of all entity tables in the database, and all attributes in each entity table, all attribute description information.

[0027] Firstly, the method can acquire all entity tables in the database, and extract the entity, attribute and attribute description information of the entity table. Generally, the entity is the name of a raw data table in the database, and the attribute includes the column name of each column in the raw data table. For each column name, some description information can be included, such as what content is recorded in the column, and the data format that can be recorded in the column, etc. These information are the description information in the present application.

[0028] In the present application, the entity is referred to as Entry, the attribute is referred to as Attr, and the description information of the attribute is referred to as Info. When all the related information in the database is acquired, it can be stored in the set D. The content of the set can be D={Entry1:{Attr1:{info1},Attr2:{info2},…,Attr m :{info m}}, Entry2:{Attr1:{info1},Attr2:{info2},…,Attr n :{info n}}, …, Entryi:{Attr1:{info1},Attr2:{info2},…,Attr l :{info l}}}, wherein i is the total number of entities in the set, and m, n and l are the total number of attributes in different entities, respectively.

[0029] In addition, in the present application, the needs of the operation and maintenance personnel can be collected, for example, the operation and maintenance personnel can select the entity tables that they want to merge through the visual interface, and the number of the entity tables selected by the operation and maintenance personnel is recorded and determined according to the number.

[0030] If the number is 0, this step will continuously realize the collection of the operation and maintenance personnel's demand information, and when the number is 1, the method will display the selected entity table and the information recorded therein in the visual interface based on the database query statement. If the number is 2 or more, the method will prompt the operation and maintenance personnel to associate the tables.

[0031] The operation and maintenance personnel can automatically select two tables for different connections according to the prompt.

[0032] Step 2, based on the information in step 1, the association relationship between the two entity tables and the association relationship between the plurality of transition business tables are acquired in turn.

[0033] Specifically, the association relationship between the two entity tables and the association relationship between the plurality of transition business tables in the present application are based on the designation of the operation and maintenance personnel, i.e., the user of the method.

[0034] Preferably, the association relationship between the two entity tables is realized by selecting an item of attribute in one entity table and selecting an item of attribute in another entity table, and then corresponding the attributes one by one.

[0035] Generally, the association relationship between the two entity tables can be associated by selecting an attribute from each of the two entity tables.

[0036] Preferably, the description information of the selected item of attribute in one entity table is the same as that of the item of attribute in another entity table.

[0037] In order to realize the association between the attributes, the two attributes can generally be the same content, for example, the device name of power distribution network equipment is included in both of the different entity tables, and then the attribute of device name can be used as the association relationship between the two entity tables.

[0038] Preferably, the transition business table is acquired based on the association relationship between the two entity tables.

[0039] It can be understood that, by using the method in the prior art, a transition business table can be generated according to the association between the two entity tables, by adding the column of other attributes and the information recorded therein. In the present application, after each transition business table is generated, the method can generate a temporary database query statement according to the generation information of the transition business table, and display all the information queried by the statement to the visual interface.

[0040] In the present application, the first N data results can also be generated according to the database query statement, and the first N data results are quickly returned to generate the visual data table content, which is used for the preliminary judgment of the operation and maintenance personnel.

[0041] Preferably, the association relationship between the plurality of transition business tables is generated based on the association relationship between any two of the plurality of transition business tables; the association relationship between any two of the plurality of transition business tables is realized by selecting an item of attribute in one transition business table and selecting an item of attribute in another transition business table, and then corresponding the attributes one by one.

[0042] It can be understood that the plurality of transition service tables in the application can be realized by merging two by two. For example, two transition service tables can be merged first, and then the merged one is merged with another transition service table which has not been merged. This way is very consistent with the operation habit of the operation and maintenance personnel and the convenience of the operation and maintenance personnel for the selection of a large number of data tables.

[0043] Preferably, the final service table is obtained based on the association relationship between the plurality of transition service tables; wherein the description information of all attributes in the final service table is judged, and when the description information is time or region, the attribute is added as a dimension index of the final service table.

[0044] After multiple selections, screenings, reselections and combinations by the operation and maintenance personnel, a final service table most suitable for the operation and maintenance personnel to judge by experience can be generated. Since the generated final service table still needs subsequent further data processing process, it can be preliminarily adjusted in the application. For example, the attributes whose description information is time or region are taken as the dimension information of the final service table. Since the service table has the dimension, the operation and maintenance personnel can conveniently extract different ranges of entity content based on different dimensions when processing massive data, so as to more conveniently realize the arrangement of data and the judgment of the implicit information in the data.

[0045] Preferably, the one-to-one correspondence of the attributes includes left join, right join, inner join and outer join; all attributes in the transition service table and the final service table are sorted based on the different connection modes.

[0046] The attribute correspondence method in the application can adopt a plurality of different methods. Since the left join, right join, inner join and outer join methods are commonly used methods in the prior art, their contents will not be described here. However, in the visualization method of the application, these methods can be integrated on the user interface, so that the operation and maintenance personnel can realize different merging results of a plurality of tables and the sorting of a plurality of attributes by simply selecting.

[0047] Preferably, the attribute values under a plurality of attributes in the final service table are calculated based on a self-defined comprehensive index to obtain a value of the comprehensive index; the comprehensive index and the value of the comprehensive index are added to the final service table as a new attribute in the final service table.

[0048] The visualization interface in the application also allows the operation and maintenance personnel to add a comprehensive index as a new attribute, and in addition, the interface can also provide a formula editing function, so that the method can obtain more intuitive comprehensive data recorded in the final service table by calculating the attribute values of a plurality of entities corresponding to different attributes in a plurality of tables according to the user's needs.

[0049] Step 3, based on the association relationship in step 2, automatically generating a database query statement to generate the final business table.

[0050] Preferably, the database query statement is used to directly extract the corresponding attributes from each entity table to generate the transition business table or the final business table.

[0051] It can be understood that the aforementioned operation steps in the present application are all interactions between the visualization platform of the method and the operation personnel, although they can provide a pre-display of part of the entity data with higher priority, but in fact they cannot generate a complete data table. When the operation personnel completely determine the association method to be used to realize data association, the method of the present application will use the way of automatically generating a database query statement to directly extract the corresponding attributes from each entity table and realize the final business table.

[0052] As described above, the temporary database query statement can generate a display of part of the data in the transition business table, and the final database query statement can generate complete information of all entities contained in the final business table.

[0053] The second aspect of the present application relates to a multi-element visualized data model construction system, wherein the system uses the multi-element visualized data model construction method of the first aspect of the present application.

[0054] The present application has the beneficial effect that, compared with the prior art, the multi-element visualized data model construction method and system of the present application can generate a final business table by combining two existing entity tables in the database and then associating the transition business table. The method of the present application solves the dilemma that the power grid operation personnel do not know where to start when facing multiple entity tables. The method of the present application associates the entity table selected by the operation personnel in real time, and judges and improves the most reasonable generation method of the final business table according to the content of the transition business table.

[0055] The applicant of the present application has made a detailed description and explanation of the embodiments of the present application in combination with the drawings of the specification, but those skilled in the art should understand that the above embodiments are only preferred embodiments of the present application, and the detailed description is only to help the reader better understand the spirit of the present application, and is not a limitation on the protection scope of the present application. On the contrary, any improvement or modification based on the spirit of the present application should fall within the protection scope of the present application.

Claims

1. A method for constructing a data model for multi-dimensional visualizations, characterized in that, The method comprises the following steps: Step 1, acquiring entity tables with merging requirements in a database in real time, and all attributes in each of the entity tables and description information of all the attributes; The real-time acquisition is implemented through a visual interface to collect entity tables that a power grid operation and maintenance personnel wants to merge, and a connection mode between any two entity tables; Step 2, based on the information in step 1, acquiring a correlation between two entity tables and a correlation between a plurality of transition business tables in sequence; The correlation between the plurality of transition business tables is selected by the power grid operation and maintenance personnel; According to the correlation between the two entity tables, a column where other attributes are located and information recorded in the column are added to generate a transition business table, after each transition business table is generated, a temporary database query statement is automatically generated according to generation information of the transition business table, and the first N data results in all information queried through the temporary database query statement are displayed to the visual interface; The first N data results are used to provide a basis for selection adjustment of the power grid operation and maintenance personnel; the plurality of transition business tables are realized by merging the transition business tables two by two, two transition business tables are first merged, and then the merged transition business table is merged with another transition business table that has not been merged; Step 3, based on the correlation in step 2, automatically generating a database query statement to generate a final business table; The automatically generated database query statement comprises complete information corresponding to a plurality of temporary database query statements; the description information of the attributes in the final business table is determined, when the description information is time or region, the attribute is set as a dimension index of the final business table.

2. The multi-element visual data model construction method according to claim 1, wherein: The correlation between the two entity tables is realized by selecting an attribute in a certain entity table and selecting an attribute in another entity table, and then one-to-one corresponding the attributes.

3. The multi-element visual data model construction method according to claim 2, wherein: The description information of the selected attribute in the certain entity table and the attribute in the another entity table is the same.

4. The multi-element visual data model construction method according to claim 3, wherein: The transition business table is acquired based on the correlation between the two entity tables.

5. The multi-element visual data model construction method according to claim 4, wherein: The correlation between the plurality of transition business tables is generated based on a correlation between any two transition business tables in the plurality of transition business tables; The correlation between the any two transition business tables is realized by selecting an attribute in a certain transition business table and selecting an attribute in another transition business table, and then one-to-one corresponding the attributes.

6. The multi-element visual data model construction method according to claim 5, wherein: The final business table is obtained based on the association relationship between the plurality of transition business tables; The description information of all attributes in the final business table is determined, and when the description information is time or region, the attribute is added as a dimension index of the final business table. 7.The method of claim 6, wherein: the one-to-one correspondence of the attributes comprises left join, right join, inner join, and outer join; and all attributes in the transition business tables and the final business table are sorted based on the different join manners. 8.The method of claim 7, wherein: a comprehensive index is defined based on a plurality of attributes in the final business table; and a value of the comprehensive index is calculated based on the plurality of attributes in the final business table. 9.The method of claim 8, wherein: the database query statement is used to directly extract the corresponding attribute from each of the entity tables to generate the transition business table or the final business table. 10.A system for constructing a multi-dimensional visualized data model, comprising: a memory; a processor; and a computer program stored in the memory and executable on the processor, wherein when the computer program is loaded into the processor, the computer program performs the method of any one of claims 1-9. ​ ​ ​ ​ ​ ​

Images