CN114840530A - Multi-element visual data model construction method and system - Google Patents
Multi-element visual data model construction method and system Download PDFInfo
- Publication number
- CN114840530A CN114840530A CN202210581434.XA CN202210581434A CN114840530A CN 114840530 A CN114840530 A CN 114840530A CN 202210581434 A CN202210581434 A CN 202210581434A CN 114840530 A CN114840530 A CN 114840530A
- Authority
- CN
- China
- Prior art keywords
- entity
- tables
- data model
- attributes
- transition
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24558—Binary matching operations
- G06F16/2456—Join operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Abstract
A method and a system for constructing a data model of multivariate visualization are 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 and description information of all attributes in each entity table; step 2, acquiring the incidence relation between two entity tables and the incidence relation between a plurality of transition service tables in sequence based on the information in the step 1; and 3, automatically generating a database query statement based on the incidence relation in the step 2 so as to generate a final business table. The method solves the problem that power grid operation and maintenance personnel have no trouble when facing a plurality of entity tables, associates the entity tables selected by the operation and maintenance personnel in real time, and judges and improves the most reasonable generation mode of the final service table according to the content of the transition service table.
Description
Technical Field
The invention relates to the field of databases, in particular to a method and a system for constructing a multi-element visual data model.
Background
With the rapid development of information technologies such as the internet, the internet of things and cloud computing, a large amount of unstructured information is emerging continuously, the requirements of a data platform on data visualization and visualization analysis are increased continuously, and the visualization development cost is increased continuously. In the big data era, the conventional data storage mode cannot meet the requirements of social development, for example, in the process of development and growth of a power system, a large amount of power grid operation data cannot be effectively analyzed and managed, and the value of the data is difficult to exert. And through visual technique, can demonstrate each item data of electric power system, be convenient for know these data fast, accurately, and then improve the reaction ability who solves the electric power system problem. For operation and maintenance personnel of the power system, the incidence relation between various data entities is obtained through the visual data model, the connotation and the essence of the data are accurately grasped, and the establishment process of the visual data model is essential.
On the other hand, a distribution network refers to an electric power network that receives electric power from a transmission network or a regional power plant, and distributes it locally through distribution facilities or stepwise by voltage to various users. In a power distribution network, the automation data are various in types, large in data structure difference and large in data volume. At present, the traditional method for describing the monitoring process and the monitoring result of the power distribution network in the forms of reports, fixed pictures and characters cannot meet the ever-increasing business requirements of power grid business monitoring, risk early warning, geographic information analysis and the like. The increasingly complex visualization requirements can be processed and the complexity of visualization data processing can be reduced by performing data modeling on the automatic data of the power distribution network, and the best visualization effect can be obtained only by selecting the most appropriate data model according to specific conditions and requirements.
However, a visualized data processing method facilitating data association of power grid operation and maintenance personnel does not exist in the prior art.
Disclosure of Invention
In order to solve the defects in the prior art, the invention aims to provide a method and a system for constructing a multi-element visual data model, wherein a final business table is generated by combining two existing entity tables in a database and then associating transition business tables.
The invention adopts the following technical scheme.
The invention relates to a method for constructing a data model of multivariate visualization, which comprises the following steps: step 1, acquiring entity tables with merging requirements in a database in real time, and all attributes and description information of all attributes in each entity table; step 2, acquiring the incidence relation between two entity tables and the incidence relation between a plurality of transition service tables in sequence based on the information in the step 1; and 3, automatically generating a database query statement based on the association relation in the step 2 so as to generate a final business table.
Preferably, the association relationship between the two entity tables is realized by selecting a certain attribute in one entity table and selecting a certain attribute in the other entity table, and corresponding the attributes one to one.
Preferably, the description information of the certain attribute in the selected certain entity table is the same as that of the certain attribute in the other entity table.
Preferably, the transition business table is obtained based on an association relationship between two entity tables.
Preferably, the association relationship between the multiple transition service tables is generated based on the association relationship between any two transition service tables in the multiple transition service tables; the association relation between any two transition service tables is realized by selecting a certain attribute in one transition service table and selecting a certain attribute in the other transition service table, and corresponding the attributes one by one.
Preferably, the final service table is obtained based on the association relationship among the plurality of transition service tables; and when the description information is time or area, adding the attribute as the dimension index of the final service table.
Preferably, the one-to-one attribute correspondence mode comprises a left connection, a right connection, an inner connection and an outer connection; and ordering all attributes in the transition service table and the final service table based on different connection modes.
Preferably, attribute values under multiple attributes in the final service table are calculated based on the self-defined comprehensive index to obtain a value of the comprehensive index; and adding the comprehensive index and the value of the comprehensive index into the final service table to become a new attribute in the final service table.
Preferably, the database query statement is used to directly extract the corresponding attributes from each entity table to generate a transition business table or a final business table.
The second aspect of the present invention relates to a data model construction system for multivariate visualization, which is implemented by using the data model construction method for multivariate visualization described in the first aspect of the present invention.
Compared with the prior art, the method and the system for constructing the multi-element visual data model have the advantages that the transition business table can be associated after the existing entity tables in the database are combined pairwise to generate the final business table. The method solves the problem that power grid operation and maintenance personnel have no trouble when facing a plurality of entity tables, associates the entity tables selected by the operation and maintenance personnel in real time, and judges and improves the most reasonable generation mode of the final service table according to the content of the transition service table.
The beneficial effects of the invention also include:
1. the method can judge the next operation mode in real time according to the number of the entity tables selected by the operation and maintenance personnel, so that the operation and maintenance personnel can be prompted to increase the number of the existing entity tables and the selection of the entity tables at any time, and the visualization process is more friendly.
2. The two entity tables are connected according to different connection modes, so that the display sequence of the attributes in the generated transition service table can be conveniently adjusted, and the requirements of operation and maintenance personnel are met.
3. The final service table is generated through multiple steps, and when a temporary transition service table is generated, the display content of data in the visual transition service table is provided, so that operation and maintenance personnel can more clearly know whether the synthesized transition service table can meet the requirements of operation and maintenance services, and the operation and maintenance personnel can conveniently generate the optimal final service table through multiple adjustments.
4. According to the invention, the database query statement is automatically generated, so that although more redundancy exists in the visual generation process of the final business table, the actual data extraction process in the final business table is realized in the simplest programming mode, the occupation of a processor and storage equipment in the processing process of mass data is reduced as much as possible, and the generation of the final business table is quicker and more accurate.
Drawings
FIG. 1 is a schematic step diagram of a data model construction method for multivariate visualization according to the present invention.
Detailed Description
The present application is further described below with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present application is not limited thereby.
FIG. 1 is a schematic step diagram of a data model construction method for multivariate visualization according to the present invention. As shown in fig. 1, a method for constructing a data model of a multivariate visualization includes steps 1 to 3.
Step 1, all entity tables in a database, all attributes in each entity table and description information of all attributes are obtained in real time.
Firstly, the method of the invention can obtain all entity tables in the database and extract the information of the entity, the attribute description and the like of the entity tables. Generally, an entity is the name of a raw data table in a database, and an attribute includes the column name of each column in the raw data table. For each column name, some description information may be included, such as what contents are described in the column, the data format that can be recorded in the column, and the like, and the description information in the present application is included in the column name.
In the present invention, an entity is called Entry, an attribute is called Attr, and description information of the attribute is called Info. When all relevant information in the database is obtained, it can be stored in the set D. The content of the set may be D ═ { Entry1: { Attr: } 1 :{info 1 },Attr 2 :{info 2 },…,Attr m :{info m }}，Entry2:{Attr 1 :{info 1 },Attr 2 :{info 2 },…,Attr n :{info n }}，……，Entryi:{Attr 1 :{info 1 },Attr 2 :{info 2 },…,Attr l :{info l And f, 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.
In addition, in the application, the requirements of the operation and maintenance personnel can be collected, for example, the operation and maintenance personnel can select the entity table which is desired to be combined through a visual interface, and meanwhile, the number of the entity tables which have been selected by the operation and maintenance personnel is recorded and judged according to the number.
If the number is 0, the step continuously realizes the collection of the operation and maintenance personnel requirement information, and if the number is 1, the method displays the selected entity table and the information recorded therein in the visual interface based on the database query statement. And if the number is 2 or more, the method prompts the operation and maintenance personnel to perform table association.
The operation and maintenance personnel can automatically select to connect the two forms in different ways according to the prompt.
And 2, acquiring the association relationship between the two entity tables and the association relationship between the plurality of transition service tables in sequence based on the information in the step 1.
Specifically, the incidence relation between two entity tables and the incidence relation between a plurality of transition service tables in the invention are all specified based on operation and maintenance personnel, namely the user of the method.
Preferably, the association relationship between the two entity tables is realized by selecting a certain attribute in one entity table and selecting a certain attribute in the other entity table, and corresponding the attributes one to one.
In general, an association relationship between two entity tables may be associated by a user selecting an attribute from each of the two entity tables.
Preferably, the description information of the certain attribute in the selected certain entity table is the same as that of the certain attribute in the other entity table.
In order to implement the association between the attributes, the two attributes may be generally the same content, for example, if two different entity tables both include the device name of the distribution network device, the attribute of the device name may be used as the association relationship between the two entity tables.
Preferably, the transition business table is obtained based on an association relationship between two entity tables.
It can be understood that, by using the method in the prior art, a transition service table can be generated by adding the columns where other attributes are located and the information recorded therein according to the association between two entity tables. In the invention, after each transition business table is generated, the method can generate a temporary database query statement according to the generated information of the transition business table, and all the information queried by the statement is displayed in the visual interface.
In the application, the first N data results can be generated according to the database query statement, and the first N data results are quickly returned to generate visual data table contents for preliminary judgment of operation and maintenance personnel.
Preferably, the association relationship between the multiple transition service tables is generated based on the association relationship between any two transition service tables in the multiple transition service tables; the association relation between any two transition service tables is realized by selecting a certain attribute in one transition service table and selecting a certain attribute in the other transition service table, and corresponding the attributes one by one.
It is understood that the transition service tables in the present invention can be implemented by pairwise merging. For example, two transition service tables may be merged first, and then one merged transition service table is merged with another transition service table that is not merged. This approach is well suited to the operational habits of the operation and maintenance personnel and the ease of selection of large numbers of data sheets by the operation and maintenance personnel.
Preferably, the final service table is obtained based on the association relationship among the plurality of transition service tables; and when the description information is time or area, adding the attribute as the dimension index of the final service table.
After the operation and maintenance personnel select, screen, reselect and combine for multiple times, a most appropriate final service table judged by the operation and maintenance personnel through experience can be generated. Since the generated final service table also requires a subsequent further data processing process, it can be preliminarily adjusted in the present application. For example, the attributes in which the description information of the attributes is time or region are used as the dimension information of the final service table. Due to the fact that the service table has the dimensionality, when the operation and maintenance personnel process mass data, the operation and maintenance personnel can conveniently extract entity contents in different ranges based on different dimensionalities, and therefore data arrangement and judgment on implicit information in the data are achieved more conveniently.
Preferably, the one-to-one attribute correspondence mode comprises a left connection, a right connection, an inner connection and an outer connection; and sequencing all attributes in the transition service table and the final service table based on different connection modes.
The attribute correspondence in the present application may take a variety of different approaches. Since the left connection, the right connection, the inner connection, the outer connection and other methods are commonly used in the prior art, the content thereof is not described herein again. However, in the visualization method of the present invention, these manners may be integrated on the user interface, so that the operation and maintenance personnel can implement different merging results for a plurality of tables and sorting of a plurality of attributes by simple selection.
Preferably, attribute values under multiple attributes in the final service table are calculated based on the self-defined comprehensive index to obtain a value of the comprehensive index; and adding the comprehensive index and the value of the comprehensive index into the final service table to become a new attribute in the final service table.
The visual interface in the application also allows operation and maintenance personnel to add the comprehensive indexes as the newly added attributes, and in addition, a formula editing function can be provided in the interface, so that the method can record the obtained comprehensive data in the final service table more visually after calculating the attribute values of a plurality of entities corresponding to different attributes in a plurality of tables according to the requirements of users.
And 3, automatically generating a database query statement based on the association relation in the step 2 so as to generate a final business table.
Preferably, the database query statement is used to directly extract the corresponding attributes from each entity table to generate a transition business table or a final business table.
It can be understood that the foregoing operation steps in the present invention are interactions between the visualization platform where the method is located and the operation and maintenance personnel, and although a previous presentation of part of the entity data with higher priority can be provided, a complete data table cannot be generated in practice. After the operation and maintenance personnel completely determine which association mode is adopted to realize data association, the method can adopt a mode of automatically generating a database query statement to directly extract corresponding attributes from each entity table and realize a final service table.
As described above, the temporary database query statement may generate an exposure of partial data in the transition business table, while the final database query statement may generate complete information for all entities contained in the final business table.
The second aspect of the present invention relates to a data model construction system for multivariate visualization, wherein the system is implemented by using the data model construction method for multivariate visualization in the first aspect of the present invention.
Compared with the prior art, the method and the system for constructing the multi-element visual data model have the advantages that the transition business table can be associated after the existing entity tables in the database are combined pairwise to generate the final business table. The method solves the problem that power grid operation and maintenance personnel have no trouble when facing a plurality of entity tables, associates the entity tables selected by the operation and maintenance personnel in real time, and judges and improves the most reasonable generation mode of the final service table according to the content of the transition service table.
The present applicant has described and illustrated embodiments of the present invention in detail with reference to the accompanying drawings, but it should be understood by those skilled in the art that the above embodiments are merely preferred embodiments of the present invention, and the detailed description is only for the purpose of helping the reader to better understand the spirit of the present invention, and not for limiting the scope of the present invention, and on the contrary, any improvement or modification made based on the spirit of the present invention should fall within the scope of the present invention.
Claims (10)
1. A method for constructing a data model of multivariate visualization, which is characterized by comprising the following steps:
step 1, acquiring entity tables with merging requirements in a database in real time, and all attributes and description information of all attributes in each entity table;
step 2, acquiring the incidence relation between two entity tables and the incidence relation between a plurality of transition service tables in sequence based on the information in the step 1;
and 3, automatically generating a database query statement based on the incidence relation in the step 2 so as to generate a final business table.
2. The method for constructing a data model of multivariate visualization as defined in claim 1, wherein:
and the incidence relation between the two entity tables is realized by selecting a certain attribute in one entity table and selecting a certain attribute in the other entity table, and corresponding the attributes one to one.
3. The method for constructing a data model of multivariate visualization as defined in claim 2, wherein:
and the selected attribute in the certain entity table is the same as the description information of the attribute in the other entity table.
4. The method for constructing a data model of multivariate visualization as defined in claim 3, wherein:
the transition business table is obtained based on the incidence relation between the two entity tables.
5. The method for constructing a data model of multivariate visualization as recited in claim 4, wherein:
the incidence relation between the transition service tables is generated based on the incidence relation between any two transition service tables in the transition service tables;
the incidence relation between any two transition service tables is realized by selecting a certain attribute in one transition service table and selecting a certain attribute in the other transition service table, and corresponding the attributes one by one.
6. The method for constructing a data model of multivariate visualization as recited in claim 5, wherein:
the final service table is obtained based on the incidence relation among the transition service tables;
and when the description information is time or area, adding the attribute as the dimension index of the final service table.
7. The method for constructing a data model of multivariate visualization as recited in claim 6, wherein:
the one-to-one corresponding mode of the attributes comprises left connection, right connection, inner connection and outer connection;
and sequencing all attributes in the transition service table and the final service table based on the difference of the connection modes.
8. The method for constructing a data model of multivariate visualization as recited in claim 7, wherein:
calculating attribute values under a plurality of attributes in the final service table based on the self-defined comprehensive index to obtain a value of the comprehensive index;
and adding the comprehensive index and the value of the comprehensive index into the final service table to become a new attribute in the final service table.
9. The method for constructing a data model of multivariate visualization as recited in claim 8, wherein:
the database query statement is used for directly extracting corresponding attributes from each entity table to generate the transition service table or the final service table.
10. A data model building system for multivariate visualization is characterized in that:
the system is realized by adopting the data model construction method of one of the multi-element visualizations as claimed in any one of claims 1-9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210581434.XA CN114840530A (en) | 2022-05-26 | 2022-05-26 | Multi-element visual data model construction method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210581434.XA CN114840530A (en) | 2022-05-26 | 2022-05-26 | Multi-element visual data model construction method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114840530A true CN114840530A (en) | 2022-08-02 |
Family
ID=82572954
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210581434.XA Pending CN114840530A (en) | 2022-05-26 | 2022-05-26 | Multi-element visual data model construction method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114840530A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116483872A (en) * | 2023-06-20 | 2023-07-25 | 合肥青谷信息科技有限公司 | Complex data processing method and device and electronic equipment |
-
2022
- 2022-05-26 CN CN202210581434.XA patent/CN114840530A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116483872A (en) * | 2023-06-20 | 2023-07-25 | 合肥青谷信息科技有限公司 | Complex data processing method and device and electronic equipment |
| CN116483872B (en) * | 2023-06-20 | 2023-09-12 | 合肥青谷信息科技有限公司 | Complex data processing method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110292775B (en) | Method and device for acquiring difference data | |
| CN107368700A (en) | Based on the microbial diversity interaction analysis system and method for calculating cloud platform | |
| CN101315680B (en) | Group qualitative analysis tool based on automatic investigation questionnaire and implementing method thereof | |
| JP5570608B2 (en) | Excel-based analysis report creation system and method | |
| US20070156787A1 (en) | Apparatus and method for strategy map validation and visualization | |
| WO2019134569A1 (en) | Visual interpretation method and device for logistic regression model | |
| CN111027294A (en) | Table summarizing method, device and system | |
| DE102014112983A1 (en) | Active knowledge steering based on document depth analysis | |
| CN112035708A (en) | Knowledge graph display method and device, computer device and readable storage medium | |
| CN111966761A (en) | Multi-dimensional model data visualization customization platform and method based on DataV | |
| CN114443854A (en) | Processing method and device of multi-source heterogeneous data, computer equipment and storage medium | |
| CN110928903A (en) | Data extraction method and device, equipment and storage medium | |
| CN114840530A (en) | Multi-element visual data model construction method and system | |
| CN111291025B (en) | Method for supporting multi-physical model conversion by logic model and storage device | |
| CN104142952B (en) | Method and device for showing reports | |
| CN114637740A (en) | Novel map platform construction method based on knowledge representation and knowledge extraction | |
| US8781997B2 (en) | Reusing reporting components in customized cubes | |
| CN116894152B (en) | Multisource data investigation and real-time analysis method | |
| CN116186331B (en) | Graph interpretation method and system | |
| CN111784801B (en) | Automatic drawing method and system for parking space plan of completion monomer building | |
| CN105608151A (en) | Financial statement analysis device and method | |
| CN116955597A (en) | Method and system for generating intelligent analysis report based on large language model and flow mining data | |
| CN115936017B (en) | Main data management method supporting interface multilingual and data multilingual | |
| CN116595418A (en) | Multi-dimensional image construction method for scientific and technological achievements | |
| KR101189068B1 (en) | System and Method on Navigating Niche Technological Areas Using Multi Dimensional Frame |
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 |