Hierarchical relation storage automation system dynamic modeling optimization management method and system
By adopting a dynamic modeling optimization management method of automated systems with hierarchical relational storage in large-capacity power stations, the problem of the existing relational database being too slow when processing large-capacity data is solved, and more efficient data query performance and large-capacity Data configuration capability.
Patent Information
- Application Number
- CN202411417490.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-11
- Publication Date
- 2025-02-14
AI Technical Summary
When existing relational databases process millions of equipment in large-capacity power stations, the basic operations such as addition, deletion, search, and backup are too slow to cope with the needs of data configuration of large-capacity sites.
Using the dynamic modeling optimization management method of automated systems with hierarchical relationship storage, the data storage volume of a single data table in the same level is reduced by establishing basic hierarchical relationship tables, object type tables and hierarchical relationship tables, and directly locate the relevant content through identification. Information to improve the overall query performance of the model.
By splitting the original data table and establishing hierarchical relationship tables, the data query performance is significantly improved, the performance bottleneck of existing relational databases in large-capacity sites is alleviated, and large-capacity data configuration can be handled more efficiently.
Smart Images
Figure CN119441215A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of hierarchical relationship storage, and in particular to a method and system for dynamic modeling optimization management of an automated system for hierarchical relationship storage. Background Art
[0002] At present, in the power system automation system platform, object-oriented dynamic modeling technology is mostly used. The most basic attributes are used to describe data objects, and various application objects can be dynamically constructed in the actual application process. The basic object model of the system generally includes object type, attribute type, and object attribute. Object is the basic component unit of dynamic modeling technology, which is used to represent the organizational conceptual model of the database, including all basic elements used to construct entity product objects, such as data types, attributes, methods, behaviors, rules, etc. Attributes are the basic elements that make up objects and are used to represent object characteristics. Objects are composed of various object attributes.
[0003] In the existing dynamic modeling technology based on relational databases, the more common approach is to create a table for each basic object type and store the association and subordination between objects in a relational master table. As the capacity of devices that need to be connected to the site increases, when the number of devices that need to be instantiated in the model library exceeds one million, the model based on the existing relational database has the problem that the basic operations such as adding, deleting, searching, and backing up are too slow to cope with the large-capacity site data configuration. Summary of the invention
[0004] The purpose of the present invention is to provide a hierarchical relationship storage automation system dynamic modeling optimization management method and system in order to solve at least one of the above technical problems.
[0005] In the first aspect, an embodiment of the present invention provides a method for dynamic modeling optimization and management of an automation system with hierarchical relationship storage, which is applied to a large-capacity power station; comprising: based on a model database of the large-capacity power station, establishing a basic hierarchical relationship and a basic hierarchical table of object types, a basic hierarchical table of attribute types, and a basic hierarchical table of object attributes; based on the connection mapping relationship of the basic hierarchical relationship, establishing a basic hierarchical relationship table; based on the object types in the model database, establishing an object type table for each object type, and writing instantiated object attribute information into the object type table; establishing a corresponding hierarchical relationship table for each object type table, and writing the dynamic link relationship of the object type corresponding to the object type table into the object type table; the hierarchical relationship table is a relationship table connecting the basic hierarchical relationship table and the object type table.
[0006] Furthermore, the large-capacity power station includes a power station with access data points of more than one million.
[0007] Furthermore, the method further comprises: establishing a mapping relationship master table, and writing the common mapping attributes and basic information of the hierarchical relationship table.
[0008] Furthermore, the basic hierarchical relationship table and the hierarchical relationship table, and the hierarchical relationship table and the object type table are mapped via name foreign keys.
[0009] In the second aspect, an embodiment of the present invention also provides a hierarchical relationship storage automation system dynamic modeling optimization management system, which is applied to large-capacity power stations; it includes: a first establishment module, a second establishment module, a third establishment module and a fourth establishment module; wherein the first establishment module is used to establish a basic hierarchical relationship and a basic hierarchical table of object types, a basic hierarchical table of attribute types, and a basic hierarchical table of object attributes based on the model database of the large-capacity power station; the second establishment module is used to establish a basic hierarchical relationship table based on the connection mapping relationship of the basic hierarchical relationship; the third establishment module is used to establish an object type table for each object type based on the object type in the model database, and write instantiated object attribute information to the object type table; the fourth establishment module is used to establish a corresponding hierarchical relationship table for each object type table, and write the dynamic link relationship of the object type corresponding to the object type table; the hierarchical relationship table is a relationship table connecting the basic hierarchical relationship table and the object type table.
[0010] Furthermore, it also includes: a fifth establishing module, which is used to establish a mapping relationship summary table and write the common mapping attributes and basic information of the hierarchical relationship table.
[0011] In a third aspect, an embodiment of the present invention further provides an electronic device, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method provided by the present invention when executing the computer program.
[0012] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer instructions, and when the computer instructions are executed by a processor, the method provided by the present invention is implemented.
[0013] The present invention provides a method and system for dynamic modeling optimization management of an automated system with hierarchical relationship storage, which splits the original basic data table to reduce the data storage capacity of a single data table in the same level, establishes an identifier mapping relationship between the original data table and the corresponding hierarchical relationship table, directly locates relevant information through the identifier, improves the overall query performance of the model, and alleviates the technical problem that the basic operations such as adding, deleting, searching, and backing up in the model based on the existing relational database are too slow to cope with the configuration of large-capacity site data. BRIEF DESCRIPTION OF THE DRAWINGS
[0014] In order to more clearly illustrate the implementation methods of the present application or the technical solutions in the prior art, the drawings required for use in the specific implementation methods or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some implementation methods of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.
[0015] Figure 1 A flowchart of a hierarchical relationship storage automation system dynamic modeling optimization management method provided by an embodiment of the present invention;
[0016] Figure 2 A schematic diagram of hierarchical relationship modeling of a large-capacity power station provided by an embodiment of the present invention;
[0017] Figure 3 A schematic diagram of a hierarchical relationship storage automation system dynamic modeling optimization management system provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0018] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0019] Embodiment 1
[0020] Figure 1 The flowchart of a hierarchical relationship storage automation system dynamic modeling optimization management method provided in accordance with an embodiment of the present invention is applied to large-capacity power stations. In the embodiment of the present invention, large-capacity power stations include power stations with more than one million access data points. Figure 1 As shown, the method specifically comprises the following steps:
[0021] Step S102: Based on the model database of the large-capacity power station, a basic hierarchical relationship and an object type basic hierarchical table, an attribute type basic hierarchical table, and an object attribute basic hierarchical table are established.
[0022] Step S104: establishing a basic hierarchical relationship table based on the connection mapping relationship of the basic hierarchical relationship.
[0023] Step S106: Based on the object types in the model database, an object type table is established for each object type, and instantiated object attribute information is written into the object type table.
[0024] Step S108, a corresponding hierarchical relationship table is established for each object type table, and the dynamic link relationship of the object type corresponding to the object type table is written; the hierarchical relationship table is a relationship table connecting the basic hierarchical relationship table and the object type table.
[0025] Figure 2 FIG. 1 is a schematic diagram of hierarchical relationship modeling of a large-capacity power station according to an embodiment of the present invention. Figure 2 As shown, the method provided by the embodiment of the present invention, according to the object type ( Figure 2 OType1,…,OTypen) in the table to establish a hierarchical relationship ( Figure 2 This can reduce the amount of single-level data storage and improve query performance through hierarchical association.
[0026] Preferably, the basic hierarchical relationship table and the hierarchical relationship table, and the hierarchical relationship table and the object type table are mapped via name foreign keys.
[0027] Specifically, Figure 2 As shown, the present invention is directed to a common object type basic level table ( Figure 2 ObjectType in), attribute type basic hierarchy table ( Figure 2 AttributeType in), and the object attribute basic hierarchy table ( Figure 2 The ObjectAttribute in the table is split into two levels, the type identifier and the corresponding information are separated, and the name is used as the foreign key to map them to the original table. Only the unique object identity identifier is retained in the basic hierarchical relationship table.
[0028] The method provided by the embodiment of the present invention splits the original relationship master table of the large-capacity power station, establishes a hierarchical mapping relationship table for each existing instantiated object type, directly locates the corresponding mapping relationship table according to the object name, and stores and searches for related dynamic link relationships.
[0029] The method provided by the embodiment of the present invention splits the original basic data table by identifying the characteristic identifier of a single table, thereby reducing the data storage capacity of a single data table in the same level; by establishing an identifier mapping relationship between the original data table and the corresponding hierarchical relationship table, the relevant information is directly located through the identifier, thereby improving the overall query performance of the model. The overall modeling of the present invention adopts a hierarchical perspective, reduces the identifier mapping connection relationship between cross-levels, and only establishes a mapping relationship between the basic data table and the corresponding relationship table. When performing data query, it can effectively shorten the query scope and quickly locate the target query content through a unique identifier.
[0030] Preferably, the method provided by the embodiment of the present invention further comprises: establishing a mapping relationship master table, and writing the common mapping attributes and basic information of the hierarchical relationship table.
[0031] Specifically, the embodiment of the present invention reduces the data width in the hierarchical table and reduces data redundancy by establishing a mapping relationship summary table to store the common subordinate connection relationships that do not need to be recorded in the object hierarchical relationship table.
[0032] From the above description, it can be seen that the present invention provides a method for optimizing the dynamic modeling management of an automated system with hierarchical relationship storage. In order to solve the performance mismatch problem between the existing dynamic modeling technology and the growth rate of site data capacity, the original basic data table is split by identifying the characteristic identifier of a single table, thereby reducing the data storage capacity of a single data table in the same level; by establishing an identifier mapping relationship between the original data table and the corresponding hierarchical relationship table, the relevant information is directly located through the identifier to improve the overall query performance of the model; by establishing a mapping relationship summary table for storing the common subordinate connection relationships that do not need to be recorded in the object hierarchical relationship table, the data width in the hierarchical table is reduced, thereby reducing data redundancy. The present invention can not only improve the bottleneck of model performance, but also has reference significance for the rigor of subsequent large-capacity power station data modeling technology.
[0033] Embodiment 2
[0034] Figure 3 Schematic diagram of a hierarchical relationship storage automation system dynamic modeling optimization management system provided according to an embodiment of the present invention, the system is applied to a large-capacity power station. Figure 3 As shown, the system includes: a first establishing module 10 , a second establishing module 20 , a third establishing module 30 and a fourth establishing module 40 .
[0035] Specifically, the first establishing module 10 is used to establish a basic hierarchical relationship and an object type basic hierarchical table, an attribute type basic hierarchical table, and an object attribute basic hierarchical table based on a model database of a large-capacity power station;
[0036] A second establishing module 20, configured to establish a basic hierarchical relationship table based on a connection mapping relationship of the basic hierarchical relationship;
[0037] The third establishing module 30 is used to establish an object type table for each object type based on the object type in the model database, and write the instantiated object attribute information into the object type table;
[0038] The fourth establishing module 40 is used to establish a corresponding hierarchical relationship table for each object type table, and write the dynamic link relationship of the object type corresponding to the object type table; the hierarchical relationship table is a relationship table connecting the basic hierarchical relationship table and the object type table.
[0039] Specifically, Figure 3 As shown, it also includes: a fifth establishing module 50, which is used to establish a mapping relationship summary table and write the common mapping attributes and basic information of the hierarchical relationship table.
[0040] The present invention further provides an electronic device, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method provided in the embodiment of the present invention when executing the computer program.
[0041] The present invention also provides a computer-readable storage medium, which stores computer instructions. When the computer instructions are executed by a processor, the method provided in the embodiment of the present invention is implemented.
[0042] It will be apparent to those skilled in the art that the invention is not limited to the details of the exemplary embodiments described above and that the invention can be implemented in other specific forms without departing from the spirit or essential features of the invention. Therefore, the embodiments should be considered exemplary and non-limiting in all respects, and the scope of the invention is defined by the appended claims rather than the foregoing description, and it is intended that all variations falling within the meaning and scope of the equivalent elements of the claims be included in the invention. Any reference numeral in a claim should not be considered as limiting the claim to which it relates.
[0043] In addition, it should be understood that although the present specification is described according to implementation modes, not every implementation mode contains only one independent technical solution. This description of the specification is only for the sake of clarity. Those skilled in the art should regard the specification as a whole. The technical solutions in each embodiment may also be appropriately combined to form other implementation modes that can be understood by those skilled in the art.
Claims
1. A hierarchical relationship storage automation system dynamic modeling optimization management method, characterized in that: Applicable to large-capacity power stations; including: Based on the model database of the large-capacity power station, a basic hierarchical relationship and an object type basic hierarchical table, an attribute type basic hierarchical table, and an object attribute basic hierarchical table are established; Based on the connection mapping relationship of the basic hierarchical relationship, a basic hierarchical relationship table is established; Based on the object types in the model database, an object type table is established for each object type, and instantiated object attribute information is written into the object type table; A corresponding hierarchical relationship table is established for each object type table, and a dynamic link relationship of the object type corresponding to the object type table is written; the hierarchical relationship table is a relationship table connecting the basic hierarchical relationship table and the object type table.
2. The method according to claim 1, characterized in that: The large-capacity power stations include power stations with access data points of more than one million.
3. The method according to claim 1, characterized in that: The method further comprises: establishing a mapping relationship master table, and writing the common mapping attributes and basic information of the hierarchical relationship table.
4. The method according to claim 1, characterized in that: The basic hierarchical relationship table and the hierarchical relationship table, and the hierarchical relationship table and the object type table are mapped via name foreign keys.
5. A hierarchical relationship storage automation system dynamic modeling optimization management system, characterized in that: Applicable to large-capacity power stations; including: a first building module, a second building module, a third building module and a fourth building module; wherein, The first establishing module is used to establish a basic hierarchical relationship and an object type basic hierarchical table, an attribute type basic hierarchical table, and an object attribute basic hierarchical table based on the model database of the large-capacity power station; The second establishing module is used to establish a basic hierarchical relationship table based on the connection mapping relationship of the basic hierarchical relationship; The third establishing module is used to establish an object type table for each object type based on the object type in the model database, and write instantiated object attribute information into the object type table; The fourth establishment module is used to establish a corresponding hierarchical relationship table for each object type table, and write the dynamic link relationship of the object type corresponding to the object type table; the hierarchical relationship table is a relationship table connecting the basic hierarchical relationship table and the object type table.
6. The system according to claim 5, characterized in that: Also includes: The fifth establishing module is used to establish a mapping relationship summary table and write the common mapping attributes and basic information of the hierarchical relationship table.
7. An electronic device, characterized in that: include: A memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method according to any one of claims 1 to 4 when executing the computer program.
8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and when the computer instructions are executed by a processor, the method according to any one of claims 1 to 4 is implemented.