CN113032373B - Data management method and related device based on load channel dynamic column - Google Patents
Data management method and related device based on load channel dynamic column Download PDFInfo
- Publication number
- CN113032373B CN113032373B CN202110579758.5A CN202110579758A CN113032373B CN 113032373 B CN113032373 B CN 113032373B CN 202110579758 A CN202110579758 A CN 202110579758A CN 113032373 B CN113032373 B CN 113032373B
- Authority
- CN
- China
- Prior art keywords
- mapping
- field
- load
- creating
- name
- 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.)
- Active
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/21—Design, administration or maintenance of databases
-
- 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
Abstract
The invention discloses a data management method and a related device based on a load channel dynamic column, wherein the method comprises the following steps: creating a mapping table of a load channel; configuring an OBIS mapping field; creating an acquisition task, and acquiring the table name, the field type and the precision information; dynamically generating an SQL script; and executing the SQL script to obtain a database table structure. The method disclosed by the invention provides basic data for dynamically creating the base table structure by adopting OBIS design, and also provides an implementation method for dynamically creating the base table structure by collecting task design. Compared with the prior art, the method dynamically creates the database table structure as required, solves the problem that the storage redundancy of the database table is too large or too small, and has the advantages that the acquisition system is platformized, when the OBIS is newly added to the load channel, the database table and the acquisition system do not need to be changed, when the existing channel is insufficient, and a new load channel is started, the system is expanded in parallel, and the maintenance cost of the platform is reduced.
Description
Technical Field
The invention relates to the field of database table storage, in particular to a data management method and a related device based on a load channel dynamic column.
Background
The load curve function is a necessary function of the intelligent electric meter and is also a basis for electric power dispatching and planning of the electric power bureau. Due to the difference of regions and the difference of power grid structures, and the flexible configuration of the frozen data items of the load curves supported by the IEC62056 standard vertebral system, the demands of customers in all regions on the frozen data items of the load curves are different, and certain troubles are brought to the storage of the load data by the acquisition system.
The traditional acquisition system adopts the following schemes to design a database table storage structure: 1. integrating market client requirements, screening out common OBIS, and creating a corresponding database table structure; 2. creating a corresponding database table structure according to the OBIS requirements of the customers leaving the factory; 3. and (4) customizing the channel OBIS and creating a corresponding database table structure. However, the above 3 schemes also have 3 defects: 1. the database table has large storage redundancy and wastes storage space resources; 2. the OBIS is newly added to the load channel, and the database table and the acquisition system are required to be changed; 3. the database table has small storage redundancy, and the OBIS is newly added, and the database table and the acquisition system need to be changed.
Therefore, how to design a data management method based on a dynamic column of a load channel to eliminate the above-mentioned drawbacks is a technical problem to be solved urgently by those skilled in the art.
Disclosure of Invention
In view of the above problems, an object of the present invention is to provide a data management method and related apparatus based on a dynamic column of a load channel, which solve the problems that the amount of a database table is difficult to measure, and an OBIS is newly added, and both the database table and an acquisition system need to be changed.
The invention provides a data management method based on a load channel dynamic column in a first aspect, which comprises the following steps:
creating a mapping table of a load channel, wherein the mapping table comprises a table name input into the mapping table;
configuring an OBIS mapping field, wherein the mapping field comprises a field name, a field type and precision information;
creating an acquisition task, and acquiring the table name, the field type and the precision information;
according to the table name, the field type and the precision information, an SQL script is dynamically generated;
and executing the SQL script to obtain a database table structure.
In this scheme, the dynamically generating the SQL script specifically includes:
and verifying whether the mapping field exists in the current database table structure, and if not, dynamically generating the SQL script.
In this scheme, the creating a mapping table of a load channel further includes: a first code is generated based on the payload channel type.
In this embodiment, the configuring the OBIS mapping field further includes: and generating a second code according to the configuration type.
In this scheme, the creating an acquisition task and the obtaining the table name, the field type, and the precision information specifically include:
and creating an acquisition task, acquiring the table name through a first code, and acquiring the field name, the field type and the precision information through a second code.
The second aspect of the present invention further provides a data management apparatus based on a load channel dynamic column, including a creating unit, configured to create a mapping table of a load channel, including a table name input into the mapping table;
the OBIS mapping system comprises a configuration unit, a mapping unit and a processing unit, wherein the configuration unit is used for configuring an OBIS mapping field, and the mapping field comprises a field name, a field type and precision information;
the acquisition unit is used for creating an acquisition task and acquiring the table name, the field type and the precision information;
and the generating unit is used for dynamically generating the SQL script according to the table name, the field type and the precision information.
And the execution unit is used for executing the SQL script and acquiring a database table structure.
In this scheme, the creating a mapping table of a load channel further includes: generating a first code according to the type of the load channel;
the configuring the OBIS mapping field further comprises: and generating a second code according to the configuration type.
In this scheme, the creating an acquisition task and the obtaining the table name, the field type, and the precision information specifically include:
and creating an acquisition task, acquiring the table name through a first code, and acquiring the field name, the field type and the precision information through a second code.
The third aspect of the present invention provides an acquisition system, including the data management device based on the load channel dynamic column in the second aspect, and further including a data presentation device;
the data presentation device includes:
the retrieval unit is used for retrieving mapping fields from the data management device based on the load channel dynamic column according to the table name;
and the display unit is used for retrieving and displaying the load data from the database corresponding to the database table structure according to the mapping field.
A fourth aspect of the present invention provides a computer-readable storage medium, where the computer-readable storage medium includes a program of a load channel dynamic column-based data management method of a machine, and when the program of the load channel dynamic column-based data management method is executed by a processor, the steps of the load channel dynamic column-based data management method are implemented as described in any one of the above.
The invention discloses a data management method and a related device based on a load channel dynamic column, wherein the method comprises the following steps: creating a mapping table of a load channel; configuring an OBIS mapping field; creating an acquisition task, and acquiring the table name, the field type and the precision information; dynamically generating an SQL script; and executing the SQL script to obtain a database table structure. The method disclosed by the invention provides basic data for dynamically creating the base table structure by adopting OBIS design, and also provides an implementation method for dynamically creating the base table structure by collecting task design. Compared with the prior art, the method dynamically creates the database table structure as required, solves the problem that the storage redundancy of the database table is too large or too small, and has the advantages that the acquisition system is platformized, when the OBIS is newly added to the load channel, the database table and the acquisition system do not need to be changed, when the existing channel is insufficient, and a new load channel is started, the system is expanded in parallel, and the maintenance cost of the platform is reduced.
Drawings
FIG. 1 is a flow chart illustrating a data management method based on a load channel dynamic column according to the present application;
FIG. 2 is a schematic structural diagram of a data management apparatus based on a dynamic column of a load path according to the present application;
FIG. 3 illustrates a system block diagram of an acquisition system of the present application;
FIG. 4 is a diagram illustrating a mapping table for creating a load channel in an embodiment of the present application;
fig. 5 is a schematic diagram illustrating an OBIS mapping field configured in an embodiment of the present application;
FIG. 6 is a diagram showing a dynamic creation process of a database table structure in the embodiment of the present application;
FIG. 7 is a diagram illustrating a dynamic output interface of a data table in an embodiment of the present application;
FIG. 8 is a diagram illustrating the display and hiding of table columns in a data table according to an embodiment of the present application;
FIG. 9 is a diagram illustrating a data table export option in an embodiment of the present application.
Detailed Description
In order that the above objects, features and advantages of the present invention can be more clearly understood, a more particular description of the invention will be rendered by reference to the appended drawings. It should be noted that the embodiments and features of the embodiments of the present application may be combined with each other without conflict.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention, however, the present invention may be practiced in other ways than those specifically described herein, and therefore the scope of the present invention is not limited by the specific embodiments disclosed below.
The application discloses a data management method based on a load channel dynamic column in a first aspect.
Fig. 1 shows a flowchart of a data management method based on a load channel dynamic column according to the present application.
As shown in fig. 1, the present application discloses a data management method based on a load channel dynamic column, which includes the following steps:
s102, creating a mapping table of a load channel, wherein the mapping table comprises a table name input into the mapping table;
s104, configuring an OBIS mapping field, wherein the mapping field comprises a field name, a field type and precision information;
s106, creating an acquisition task, and acquiring the table name, the field type and the precision information;
s108, according to the table name, the field type and the precision information, dynamically generating an SQL script;
s110, executing the SQL script and obtaining a database table structure.
It should be noted that the load channel is used for transporting electric energy with a specific capacity, and the OBIS (OBject Identification System) code is specified by DLMS/COSEM (new electric energy meter communication standard proposed by the international electrotechnical commission for solving the problems of data acquisition, meter installation, maintenance, System integration, and the like in an automatic meter reading System and a metering System) and is used for providing a uniform Identification code for all data in the electric energy meter, including measured values and abstract parameters. The load path mapping table is used to map a specific database, i.e. mapping table, for a specific load path type by entering the table name of the mapping table. When the OBIS is newly added, the OBIS mapping field needs to be configured. The field name, field type and precision information are used for acquiring corresponding data subsequently. In the dynamic creation process of the database table structure, firstly, an acquisition task is created, table names, field names, types and precision information are obtained, an SQL script is dynamically generated according to the information, and finally the SQL script is executed, so that the database table structure can be obtained. Repeating the steps, and when the generated base table structure is stored, all field names of the base table structure of the database can be obtained and stored in the acquisition system in the form of key values [ "table names", "field lists" ].
It should be noted that a database table structure is created, so as to obtain the power data of a specific structure specified by the customer through the database table structure. The source of the electric energy data is obtained through the load channels, and different electric energy data are transmitted through a plurality of load channels, so that a load channel mapping table needs to be created, and the load channel mapping table is used for mapping a specific database aiming at a specific load channel type. It can be understood that the mapping table is only an empty table after being created, and therefore, the data in the mapping table that needs to be mapped, i.e. the customer-specified power data with a specific structure, needs to be configured so as to extract specific data to be filled in the table. Because the OBIS code has a uniform standard identification code, the accurate meaning of each data item can be obtained by comparing the use of the OBIS code, and therefore, the corresponding OBIS code can be generated for specific electric energy data, and the specific OBIS code can also correspond to the specific electric energy data. According to the characteristics of the OBIS code, the OBIS code can be generated after the mapping table is created and the mapping field is configured, the acquisition task is created through the OBIS code, and the SQL script is generated and executed to obtain the database table structure.
Please refer to fig. 4, taking Load Profile1 as an example, the mapping table created is DATA _ C _ Load; referring to fig. 5, an OBIS mapping field is created, taking the data type as forward active power (+ a), for example, the mapped field Name (ColumnName) is KW _ imput, the field type is numeric, and the precision is 9 bits and integer is 3 bits; referring to fig. 6, the OBIS capture item and the configuration item respectively represent a mapping table and a data type, and after the OBIS mapping field is configured, an acquisition task may be created, that is, a table name, a field name, a type, and accuracy are obtained from the OBIS code definition; according to the table name, the field type and the precision information, the SQL script can be dynamically generated; and executing the SQL script to obtain a database table structure.
It should be noted that, in the prior art, since the database table structure is not obtained through a dynamically generated SQL script, once produced, the entire structure and the acquisition system need to be changed when an OBIS is newly added to the load channel. According to the method provided by the invention, the SQL script is dynamically generated according to the OBIS definition, so that the database table structure is dynamically acquired, when the OBIS is newly added in a subsequent newly added load channel, the database table structure and the structure of the acquisition system are not required to be changed, and the problems that the storage capacity of the database table is difficult to measure, and the OBIS, the database table and the acquisition system are required to be changed are solved.
According to the embodiment of the present invention, the dynamically generating SQL script specifically includes:
and verifying whether the mapping field exists in the current database table structure, and if not, dynamically generating the SQL script.
It can be understood that the SQL script is dynamically generated only on the premise that the mapping field does not exist in the current database table structure, so as to avoid repeatedly generating and covering the original database table structure.
According to the embodiment of the present invention, the mapping table for creating a load path further includes: a first code is generated based on the payload channel type.
It should be noted that, in order to facilitate the acquisition of the table name in the subsequent bed acquisition task, a first code may be generated first according to the type of the load channel, and the first code may specifically be an OBIS code, and may also be used to configure the OBIS code, so as to obtain the table name from the definition of the OBIS code.
According to an embodiment of the present invention, the configuring the OBIS mapping field further includes: and generating a second code according to the configuration type.
It should be noted that, in order to facilitate the acquisition of the field name, the field type, and the accuracy information in the subsequent bed acquisition task, a second code may be generated first according to the load channel type, and the second code may specifically be an OBIS code, and may also be used to configure the OBIS code, so as to obtain mapping field information from the definition of the OBIS code, where the mapping field information includes the field name, the field type, and the accuracy information.
According to the embodiment of the present invention, the creating of the collection task and the obtaining of the table name, the field type, and the precision information specifically include:
and creating an acquisition task, acquiring the table name through a first code, and acquiring the field name, the field type and the precision information through a second code.
It should be noted that, please refer to fig. 4 for creating the mapping table of the load channel: taking load channel 1 as an example, other load channels are configured similarly. As shown in fig. 2, wherein: code: 0.0.99.1.0.255.2 as load path type; name: load Profile1 indicates the name Load lane 1; TableName represents the mapped database table name DATA _ C _ LOAD.
Please note that, please refer to fig. 5 for configuring the OBIS mapping field: other OBIS configurations are similar to this, taking forward active power as an example. Code: 1.0.1.7.0.255.2 as a power capture term; name is expressed as forward active power; ColumName indicates the field name of the mapping KW _ IMPORT, the field type is numeric, and the precision is 9-bit integer and 3-bit decimal.
It should be noted that, the collection task is created to generate a dynamic column, please refer to fig. 6: the dynamic creation process of the database table structure takes a load curve 1 as an example:
1) click the "Save" button
2) Acquiring a table name from the OBIS code definition by acquiring a task type (shown in figure 4); acquiring field name, type and precision from OBIS code definition through a channel OBIS configuration item (as shown in figure 5);
3) and dynamically generating the SQL script through the table name, the field name, the type and the precision information. In the process of generating SQL, verifying whether a field exists in a current base table structure;
4) executing the SQL script;
5) and all field names of the database table structure are obtained again and stored in the system in the form of key values [ "table name", "field list" ].
The invention provides a data management device based on a load channel dynamic column in a second aspect.
Fig. 2 shows a schematic structural diagram of a data management device based on a load channel dynamic column according to the present application.
As shown in fig. 2, the present application discloses a data management apparatus based on a load channel dynamic column, including:
a creating unit 202, configured to create a mapping table of a load channel, including a table name into which the mapping table is input;
a configuration unit 204, configured to configure an OBIS mapping field, where the mapping field includes a field name, a field type, and precision information;
an acquisition unit 206, configured to create an acquisition task, and acquire the table name, the field type, and the precision information;
and the generating unit 208 is configured to dynamically generate an SQL script according to the table name, the field type, and the precision information.
The execution unit 210 is configured to execute the SQL script and obtain a database table structure.
It should be noted that the load channel mapping table is used to map a specific database, i.e. mapping table, for a specific load channel type, and the mapping is performed by inputting the table name of the mapping table. When the OBIS is newly added, the OBIS mapping field is configured. In the dynamic creation process of the database table structure, firstly, an acquisition task is created, table names, field names, types and precision information are obtained, an SQL script is dynamically generated according to the information, and finally the SQL script is executed, so that the database table structure can be obtained. Repeating the steps, and when the generated base table structure is stored, all field names of the base table structure of the database can be obtained and stored in the acquisition system in the form of key values [ "table names", "field lists" ].
According to the embodiment of the present invention, the dynamically generating SQL script specifically includes:
and verifying whether the mapping field exists in the current database table structure, and if not, dynamically generating the SQL script.
It can be understood that the SQL script is dynamically generated only on the premise that the mapping field does not exist in the current database table structure, so as to avoid repeatedly generating and covering the original database table structure.
According to the embodiment of the present invention, the mapping table for creating a load path further includes: a first code is generated based on the payload channel type.
It should be noted that, in order to facilitate the acquisition of the table name in the subsequent bed acquisition task, a first code may be generated first according to the type of the load channel, and the first code may specifically be an OBIS code, and the table name is obtained from the definition of the OBIS code.
According to an embodiment of the present invention, the configuring the OBIS mapping field further includes: and generating a second code according to the configuration type.
It should be noted that, in order to facilitate the acquisition of the field name, the field type, and the accuracy information in the subsequent bed acquisition task, a second code may be generated first according to the load channel type, the second code may specifically be an OBIS code, and the mapping field information is obtained from the definition of the OBIS code, where the mapping field information includes the field name, the field type, and the accuracy information.
According to the embodiment of the present invention, the creating of the collection task and the obtaining of the table name, the field type, and the precision information specifically include:
and creating an acquisition task, acquiring the table name through a first code, and acquiring the field name, the field type and the precision information through a second code.
It should be noted that, please refer to fig. 4 for creating the mapping table of the load channel: taking load channel 1 as an example, other load channels are configured similarly. As shown in fig. 2, wherein: code: 0.0.99.1.0.255.2 as load path type; name: load Profile1 indicates the name Load lane 1; TableName represents the mapped database table name DATA _ C _ LOAD.
Please note that, please refer to fig. 5 for configuring the OBIS mapping field: other OBIS configurations are similar to this, taking forward active power as an example. Code: 1.0.1.7.0.255.2 as a power capture term; name is expressed as forward active power; ColumName indicates the field name of the mapping KW _ IMPORT, the field type is numeric, and the precision is 9-bit integer and 3-bit decimal.
It should be noted that, the collection task is created to generate a dynamic column, please refer to fig. 6: the dynamic creation process of the database table structure takes a load curve 1 as an example:
1) click the "Save" button
2) Acquiring a table name from the OBIS code definition by acquiring a task type (shown in figure 4); acquiring field name, type and precision from OBIS code definition through a channel OBIS configuration item (as shown in figure 5);
3) and dynamically generating the SQL script through the table name, the field name, the type and the precision information. In the process of generating SQL, verifying whether a field exists in a current base table structure;
4) executing the SQL script;
5) and all field names of the database table structure are obtained again and stored in the system in the form of key values [ "table name", "field list" ].
A third aspect of the invention provides an acquisition system.
Fig. 3 shows a system block diagram of an acquisition system of the present application.
As shown in fig. 3, the present application discloses an acquisition system, which includes the data management device 31 based on the load channel dynamic column of the second aspect, and further includes a data presentation device 32, where the data presentation device 300 includes:
a retrieving unit 302, configured to retrieve a mapping field from the data management apparatus based on the load channel dynamic column according to a table name;
and the display unit 304 is configured to retrieve and display the load data from the database corresponding to the database table structure according to the mapping field.
It should be noted that, the database table structure is dynamically generated, and therefore, the data also needs to be dynamically displayed, so the acquisition system includes, in addition to the data management apparatus 31 of the second aspect, a data display apparatus 32 for visually displaying the dynamically generated database table structure. The data presentation apparatus includes a retrieval unit 302 and a display unit 304, and since the database table structure is generated by the table name and the mapping field, the mapping field can be retrieved according to the table name. When the mapping field is retrieved, the load data is retrieved from the database corresponding to the database table structure and displayed on the display unit 304.
According to an embodiment of the present invention, the display unit 304 includes a power capture item display box for controlling the display and hiding of the table columns.
According to an embodiment of the present invention, the apparatus further comprises an output unit for deriving the selected data column.
It should be noted that, the database table structure is dynamically generated, so the data also needs to be dynamically represented, taking the load curve 1 as an example:
1) retrieving a list of fields from the system by a table name such as "DATA _ C _ LOAD";
2) retrieving load data from a system database through the field list; the page dynamically outputs the table header column and circularly outputs the load data record (as shown in FIG. 7);
3) clicking the position of the upper right corner to control the display and the hiding of the table column (as shown in figure 8);
4) clicking on the top right position, the selected column data can be derived (see fig. 9).
A fourth aspect of the present invention provides a computer-readable storage medium, where the computer-readable storage medium includes a program of a load channel dynamic column-based data management method of a machine, and when the program of the load channel dynamic column-based data management method is executed by a processor, the steps of the load channel dynamic column-based data management method according to the first aspect are implemented.
The invention discloses a data management method and a related device based on a load channel dynamic column, which comprises the following steps: creating a mapping table of a load channel; configuring an OBIS mapping field; creating an acquisition task, and acquiring the table name, the field type and the precision information; according to the table name, the field type and the precision information, an SQL script is dynamically generated; and executing the SQL script to obtain a database table structure. The method disclosed by the invention provides basic data for dynamically creating the base table structure by adopting OBIS design, provides an implementation method for dynamically creating the base table structure by adopting acquisition task design, and is provided with a data display device in an acquisition system to realize dynamic display and dynamic export of data. Compared with the prior art, the method dynamically creates the database table structure as required, solves the problem that the storage redundancy of the database table is too large or too small, and has the advantages that the acquisition system is platformized, when the OBIS is newly added to the load channel, the database table and the acquisition system do not need to be changed, when the existing channel is insufficient, and a new load channel is started, the system is expanded in parallel, and the maintenance cost of the platform is reduced.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. The above-described device embodiments are merely illustrative, for example, the division of the unit is only a logical functional division, and there may be other division ways in actual implementation, such as: multiple units or components may be combined, or may be integrated into another system, or some features may be omitted, or not implemented. In addition, the coupling, direct coupling or communication connection between the components shown or discussed may be through some interfaces, and the indirect coupling or communication connection between the devices or units may be electrical, mechanical or other forms.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units; can be located in one place or distributed on a plurality of network units; some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, all the functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may be separately regarded as one unit, or two or more units may be integrated into one unit; the integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
Those of ordinary skill in the art will understand that: all or part of the steps for realizing the method embodiments can be completed by hardware related to program instructions, the program can be stored in a computer readable storage medium, and the program executes the steps comprising the method embodiments when executed; and the aforementioned storage medium includes: a mobile storage device, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
Alternatively, the integrated unit of the present invention may be stored in a computer-readable storage medium if it is implemented in the form of a software functional module and sold or used as a separate product. Based on such understanding, the technical solutions of the embodiments of the present invention may be essentially implemented or a part contributing to the prior art may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the methods described in the embodiments of the present invention. And the aforementioned storage medium includes: a removable storage device, a ROM, a RAM, a magnetic or optical disk, or various other media that can store program code.
Claims (10)
1. A data management method based on a load channel dynamic column is characterized by comprising the following steps: creating a mapping table of a load channel, wherein the mapping table comprises a table name input into the mapping table;
configuring an OBIS mapping field, wherein the mapping field comprises a field name, a field type and precision information;
creating an acquisition task, and acquiring the table name, the field type and the precision information;
according to the table name, the field type and the precision information, an SQL script is dynamically generated;
executing the SQL script to obtain a database table structure;
the load path mapping table is used to map a specific database for a specific load path type by inputting the table name of the mapping table.
2. The data management method based on the load channel dynamic column according to claim 1, wherein the dynamically generated SQL script specifically comprises: and verifying whether the mapping field exists in the current database table structure, and if not, dynamically generating the SQL script.
3. The method for data management based on dynamic columns of load channels as claimed in claim 1, wherein said creating a mapping table of load channels further comprises: a first code is generated based on the payload channel type.
4. The method for data management based on a dynamic column of a load path as claimed in claim 3, wherein said configuring the OBIS mapping field further comprises: and generating a second code according to the configuration type.
5. The data management method based on the dynamic column of the load channel according to claim 4, wherein the creating of the collection task and the obtaining of the table name, the field type, and the precision information specifically include: and creating an acquisition task, acquiring the table name through a first code, and acquiring the field name, the field type and the precision information through a second code.
6. A data management apparatus based on a dynamic column of a load path, comprising: the system comprises a creating unit, a load channel mapping unit and a load channel mapping unit, wherein the creating unit is used for creating a mapping table of a load channel and comprises a table name input into the mapping table;
the OBIS mapping system comprises a configuration unit, a mapping unit and a processing unit, wherein the configuration unit is used for configuring an OBIS mapping field, and the mapping field comprises a field name, a field type and precision information;
the acquisition unit is used for creating an acquisition task and acquiring the table name, the field type and the precision information;
the generating unit is used for dynamically generating an SQL script according to the table name, the field type and the precision information;
the execution unit is used for executing the SQL script and acquiring a database table structure;
the load path mapping table is used to map a specific database for a specific load path type by inputting the table name of the mapping table.
7. The apparatus as claimed in claim 6, wherein the mapping table for creating load channel further comprises: generating a first code according to the type of the load channel;
the configuring the OBIS mapping field further comprises: and generating a second code according to the configuration type.
8. The data management device according to claim 7, wherein the creating of the collection task and the obtaining of the table name, the field type, and the precision information specifically include: and creating an acquisition task, acquiring the table name through a first code, and acquiring the field name, the field type and the precision information through a second code.
9. An acquisition system, comprising the data management device based on the load channel dynamic column of any one of claims 6 to 8, and further comprising a data presentation device;
the data presentation device includes:
the retrieval unit is used for retrieving mapping fields from the data management device based on the load channel dynamic column according to the table name;
and the display unit is used for retrieving and displaying the load data from the database corresponding to the database table structure according to the mapping field.
10. A computer-readable storage medium, wherein the computer-readable storage medium includes a program of data management method based on dynamic column of load channel, and when the program of data management method based on dynamic column of load channel is executed by a processor, the steps of the data management method based on dynamic column of load channel according to any one of claims 1 to 5 are implemented.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110579758.5A CN113032373B (en) | 2021-05-26 | 2021-05-26 | Data management method and related device based on load channel dynamic column |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110579758.5A CN113032373B (en) | 2021-05-26 | 2021-05-26 | Data management method and related device based on load channel dynamic column |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113032373A CN113032373A (en) | 2021-06-25 |
| CN113032373B true CN113032373B (en) | 2021-08-17 |
Family
ID=76455765
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110579758.5A Active CN113032373B (en) | 2021-05-26 | 2021-05-26 | Data management method and related device based on load channel dynamic column |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113032373B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104735172A (en) * | 2013-12-18 | 2015-06-24 | 易讯科技股份有限公司 | Protocol conversion method of intelligent electricity using information collecting terminal |
| CN105303464A (en) * | 2015-11-13 | 2016-02-03 | 威胜集团有限公司 | Data management system of intelligent electric energy meter |
| CN107861724A (en) * | 2017-11-06 | 2018-03-30 | 烟台东方威思顿电气有限公司 | The scripting coding method of fast adaptation DLMS/COSEM objects |
| CN108647238A (en) * | 2018-03-30 | 2018-10-12 | 宁波三星医疗电气股份有限公司 | A kind of data interactive method |
-
2021
- 2021-05-26 CN CN202110579758.5A patent/CN113032373B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104735172A (en) * | 2013-12-18 | 2015-06-24 | 易讯科技股份有限公司 | Protocol conversion method of intelligent electricity using information collecting terminal |
| CN105303464A (en) * | 2015-11-13 | 2016-02-03 | 威胜集团有限公司 | Data management system of intelligent electric energy meter |
| CN107861724A (en) * | 2017-11-06 | 2018-03-30 | 烟台东方威思顿电气有限公司 | The scripting coding method of fast adaptation DLMS/COSEM objects |
| CN108647238A (en) * | 2018-03-30 | 2018-10-12 | 宁波三星医疗电气股份有限公司 | A kind of data interactive method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113032373A (en) | 2021-06-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103177061B (en) | Unique value estimation in partition table | |
| CN106294888B (en) | A kind of method for subscribing of the object data based on space-time database | |
| CN101405728B (en) | Relational database architecture with dynamic load capability | |
| CN104361018B (en) | Electronic archives information reorganization method and device | |
| CN106294887B (en) | The description method to object existing for objective world and event based on space-time | |
| CN103186541B (en) | A kind of mapping relations generate method and device | |
| CN110866383B (en) | Interactive electronic data list generation method and system | |
| CN101446971A (en) | Method for building content management system and device thereof | |
| CN110108955A (en) | A kind of new-energy grid-connected performance automatic test analysis platform and detection method | |
| CN106909996A (en) | Article control method and system | |
| CN112527373A (en) | Visual platform expanding method based on operation integrated management center service | |
| CN106055678A (en) | Hadoop-based panoramic big data distributed storage method | |
| CN102156739A (en) | GIS (Geographic Information System) platform processing method for mass lightning data | |
| CN101916269B (en) | The generation method of power grid SVG graphic file, described graphic file and generation system | |
| CN113032373B (en) | Data management method and related device based on load channel dynamic column | |
| CN101202661A (en) | Method for matching business data and map data based on requirement | |
| CN103119618A (en) | Database, work content data management server and work content data management program | |
| CN108830540B (en) | Method, device and system for processing engineering project archive | |
| CN112001539B (en) | High-precision passenger transport prediction method and passenger transport prediction system | |
| CN109426944B (en) | Three-dimensional model file filing management system | |
| CN112527918A (en) | Data processing method and device | |
| CN117150138A (en) | Scientific and technological resource organization method and system based on high-dimensional space mapping | |
| US20080027966A1 (en) | Dynamic creation of star-schema database structures and cubes | |
| CN110968679A (en) | Data query method and device | |
| CN108132997A (en) | A kind of electric network data management sums up structure and its resolution principle |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |