CN109684517B - Historical data storage method, reading and writing method, storage device and equipment - Google Patents
Historical data storage method, reading and writing method, storage device and equipment Download PDFInfo
- Publication number
- CN109684517B CN109684517B CN201811527945.3A CN201811527945A CN109684517B CN 109684517 B CN109684517 B CN 109684517B CN 201811527945 A CN201811527945 A CN 201811527945A CN 109684517 B CN109684517 B CN 109684517B
- Authority
- CN
- China
- Prior art keywords
- data
- measurement
- name
- dictionary table
- historical data
- 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
-
- 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a historical data storage method, a reading and writing method, a storage device and equipment, wherein a group of measurements which belong to the same power system resource type and have the same measurement value acquisition period are stored in a historical data table, and the measurement historical values of the same power system resource object acquired at the same time point are located in the same record, so that the time values do not need to be written repeatedly when a plurality of measurement value data of the same power system resource object are stored, the storage requirement is reduced, and the storage efficiency of the measurement historical data of a power grid CIM model is effectively improved; when the method is used for reading, a plurality of measurement values of the designated time can be obtained at one time, so that the access efficiency is improved; the technical problems that an existing historical data measuring storage mode is low in storage efficiency and data access efficiency are solved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a historical data storage method, a read-write method, a storage device, and an apparatus.
Background
With the continuous development of computer technology and the continuous improvement of informatization degree, the data volume is rapidly increased, mass data storage and application are developed rapidly, and large data reference is more and more extensive.
The power detection system generates a large amount of measurement data in the operation process, that is, data collected by a sensor to monitor the operation of power equipment, and the measurement data is modeled by a measurement Model of a Common Information Model (CIM) of a power system in an energy management system Interface standard formulated by the International Electrotechnical Commission (IEC), and a historical data access Interface for measurement value history is provided in a Component Interface Specification (CIS).
In a CIM Measurement model, a plurality of measurements (Measurement) and Measurement values (MeasurementValue) associated with Power System Resource (Power System Resource) types and descendant types are abstracted for Measurement, and in a CIS data access interface, access to Measurement history data is performed for each Measurement value object.
Disclosure of Invention
The embodiment of the application provides a historical data storage method, a reading and writing method, a storage device and equipment, and solves the technical problems of low storage efficiency and low data access efficiency of the existing historical data measurement storage mode.
In view of the above, a first aspect of the present application provides a historical data storage method, including:
the method comprises the steps of obtaining CIM measurement data, and grouping according to the specific subtype of the power system resource to which each CIM measurement data belongs to obtain first grouping data;
performing secondary grouping on the first grouped data according to the same acquisition period to obtain second grouped data;
writing the second packet data into a first dictionary table and a second dictionary table, wherein the first dictionary table is used for storing CIM measurement packet information and comprises the following steps: the first dictionary table takes the group ID as a main key, and the second dictionary table is used for storing CIM measurement configuration information, and the method comprises the following steps: the second dictionary table takes the measurement name and the belonging power system resource type name as joint main keys;
creating a measurement history data table for storing measurement history value data according to the first dictionary table and the second dictionary table, wherein each measurement history data table corresponds to each group ID one by one, and the measurement history data table comprises: the measurement history data table takes the power system resource ID and the time mark as a joint main key.
Preferably, the writing the second packet data into the first dictionary table and the second dictionary table further includes:
a first dictionary table with a table name of HIS _ CIMMeasGroup and a second dictionary table with a table name of HIS _ CIMMeasment are constructed.
Preferably, the table name format of the measurement history data table is: HIS _ plus packet ID.
Preferably, the column names of the data columns correspond to the column names of the corresponding historical data tables one to one.
A second aspect of the present application provides a historical data read-write method, based on the historical data storage method according to the first aspect, when a measurement history value is written:
querying a second dictionary table according to the measurement name and the resource type name of the power system as a filtering condition to obtain a corresponding historical data list name and a group ID;
querying the first dictionary table by taking the group ID as a filtering condition to determine the corresponding historical data table name;
organizing historical data writing, namely writing a plurality of measured historical values belonging to the same corresponding historical data table into the corresponding historical data table at the same time;
when reading the measurement history values:
querying a second dictionary table according to the measurement name and the resource type name of the power system as a filtering condition to obtain a corresponding historical data list name and a grouping ID;
querying a first dictionary table by taking the group ID as a filtering condition, and determining a corresponding historical data table name;
and (4) reading the organization historical data, and acquiring a plurality of measured historical values belonging to the same historical data table at one time.
A third aspect of the present application provides a history data storage apparatus comprising:
the first grouping unit is used for acquiring CIM measurement data and grouping the CIM measurement data according to the specific subtype of the power system resource to which the CIM measurement data belongs to obtain first grouping data;
the second grouping unit is used for carrying out secondary grouping on the first grouping data according to the same acquisition cycle to obtain second grouping data;
a writing unit, configured to write the second packet data into a first dictionary table and a second dictionary table, where the first dictionary table is used to store CIM measurement packet information, and the writing unit includes: the first dictionary table takes the group ID as a main key, and the second dictionary table is used for storing CIM measurement configuration information, and the method comprises the following steps: the second dictionary table takes the measurement name and the belonging power system resource type name as joint main keys;
a history unit, configured to create a measurement history data table for storing measurement history value data according to the first dictionary table and the second dictionary table, where each measurement history data table corresponds to each group ID one to one, and the measurement history data table includes: the measurement history data table takes the power system resource ID and the time mark as a joint main key.
Preferably, the apparatus further comprises:
and the dictionary unit is used for constructing a first dictionary table with the table name of HIS _ CIMMeasGroup and a second dictionary table with the table name of HIS _ CIMMeasment.
A fourth aspect of the present application provides a historical data storage device, the device comprising a processor and a memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to perform the historical data storage method of the first aspect according to instructions in the program code.
A fifth aspect of the present application provides a computer-readable storage medium for storing program code for executing the history data storage method of the first aspect.
A sixth aspect of the present application provides a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method of historical data storage of the first aspect.
According to the technical scheme, the embodiment of the application has the following advantages:
the application provides a historical data storage method, which comprises the following steps: the method comprises the steps that CIM measurement data are obtained and grouped according to the specific subtype of the power system resource to which each CIM measurement data belongs, and first grouped data are obtained; performing secondary grouping on the first grouped data according to the same acquisition period to obtain second grouped data; writing the second grouping data into a first dictionary table and a second dictionary table, wherein the first dictionary table is used for storing CIM measurement grouping information and comprises the following steps: the group ID, the group name, the power system resource type name and the name of the corresponding historical data table, the group ID is used as a main key in the first dictionary table, and the CIM measurement configuration information is stored in the second dictionary table, and the method comprises the following steps: the measurement name, the type name of the affiliated power system resource, the grouping ID and the list name of the corresponding historical data table, and the second dictionary table takes the measurement name and the type name of the affiliated power system resource as a joint main key; according to the first dictionary table and the second dictionary table, a measurement history data table used for storing measurement history value data is established, each measurement history data table corresponds to each group ID one by one, and the measurement history data table comprises: the measurement history data table takes the power system resource ID and the time mark as a joint main key. According to the historical data storage method, a group of measurements which belong to the same power system resource type and have the same measurement value acquisition period are stored in a historical data table, and the measurement historical values of the same power system resource object acquired at the same time point are located in the same record, so that when a plurality of measurement value data of the same power system resource object are stored, time values do not need to be written repeatedly, the storage requirement is reduced, and the storage efficiency of the measurement historical data of a power grid CIM model is effectively improved; when the method is used for reading, a plurality of measurement values of the designated time can be obtained at one time, so that the access efficiency is improved; the technical problems that an existing historical data measuring storage mode is low in storage efficiency and data access efficiency are solved.
Drawings
Fig. 1 is a schematic flowchart of a historical data storage method in an embodiment of the present application;
FIG. 2 is another schematic flow chart illustrating a historical data storage method according to an embodiment of the present disclosure;
fig. 3 is a schematic flowchart of a historical data read-write method in an embodiment of the present application;
fig. 4 is a schematic structural diagram of a historical data storage device in an embodiment of the present application.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
For easy understanding, please refer to fig. 1, in an embodiment of the present application, a method for storing historical data includes:
It should be noted that the CIM common information model is an information model describing logical structures and relationships of all objects of the power system, and describes power system resources as object classes, attributes and relationships between them. In the embodiment of the application, all the CIM measurement data may be acquired according to a plurality of different acquisition cycles, and the CIM measurement data may be grouped according to specific subtypes of power system resources to which the CIM measurement data belongs, where the specific subtypes of the power system resources may be Breaker, disconnect, BusbarSection, and the like.
And 102, performing secondary grouping on the first grouped data according to the same acquisition period to obtain second grouped data.
It should be noted that the acquisition period is determined by the service characteristics of the measurement to be acquired, and for the slowly varying measurement, the acquisition frequency is relatively low, and the acquisition period is relatively long, and for the rapidly varying measurement, the acquisition frequency is relatively high, and the acquisition period is relatively short. In the embodiment of the application, the first grouping data in the same acquisition period are divided into the same group, and the measurement groups in different acquisition periods are stored.
It should be noted that, the first dictionary table for storing CIM measurement packet information includes: group ID, group name, power system resource type name, and corresponding historical data table name, as shown in the following table:
the first dictionary table has the group ID as a primary key.
A second dictionary table for storing CIM metrology configuration information, comprising: the measurement name, the type name of the power system resource, the grouping ID and the column name of the corresponding historical data table are shown as the following table:
the metering name may be duplicated for different types, such as Breaker or BusbarSection (both P, Q, I), but must be unique for the same type, so the second dictionary table uses the metering name and the belonging power system resource type as the joint primary key.
It should be noted that, the time scale, i.e., the time of the measurement acquisition value, and the measurement of the same acquisition period, the time scale of the data acquired in each acquisition period is the same. In the embodiment of the present application, the measurement history data table is shown in the following table:
| power system resource ID | Timestamp | Col_1 | Col_2 | Col_3 | Col_4 | Col_5 |
| PSR_1 | T1 | Value of P | Value of Q | Value of Ia | Value of Ib | Ic value |
| PSR_1 | T2 | Value of P | Value of Q | Value of Ia | Value of Ib | Ic value |
| PSR_2 | T1 | Value of P | Value of Q | Value of Ia | Value of Ib | Ic value |
| PSR_2 | T2 | Value of P | Value of Q | Value of Ia | Value of Ib | Ic value |
| PSR_1 | T3 | Value of P | Value of Q | Value of Ia | Value of Ib | Ic value |
| PSR_2 | T3 | Value of P | Value of Q | Value of Ia | Value of Ib | Ic value |
| PSR_3 | T1 | Value of P | Value of Q | Value of Ia | Value of Ib | Ic value |
| PSR_3 | T4 | Value of P | Value of Q | Value of Ia | Value of Ib | Ic value |
In the embodiment of the application, the second dictionary table may be queried according to the measurement name (P) and the type (BusbarSection) of the power system resource to which the measurement belongs as a filtering condition to obtain the corresponding historical data table column name (Col _1) and the group ID (4), and the first dictionary table may be queried by using the group ID (4) as the filtering condition to determine the corresponding historical data table name (His _ 4). If Breaker (P, Q) and BusbarSection (Q, I) are written, access to His _1(Col _1, Col _2) and His _4(Col _2 and Col _3) is determined, so that data of the two tables can be processed in batches respectively, the aim of accelerating access to a database table is achieved, and simultaneously, access to multiple rows of multiple columns of one table is more efficient than access to each column of one table respectively. When the measurement history value is stored, for a plurality of measurements of the same power system resource object in the same acquisition period, as shown in a measurement history data table, it can be seen that for a plurality of measurements (Co _1, Col _2 and Col _3) of the same PSR, the time scale is recorded only once, and the time scale does not need to be written repeatedly, so that the storage requirement is reduced, and the storage efficiency is improved; correspondingly, when the measurement history value is read, a plurality of measurements of the same power system resource object in the same acquisition period can be acquired at one time, and the access efficiency is improved.
It should be noted that, with respect to the grouping of the measurement value acquisition periods, the historical data storage method provided in the embodiment of the present application avoids the storage waste caused by partial values and partial values of measurements in different acquisition periods associated with one power system resource object at the same time point, as shown in the following table, if no grouping is performed, when an SState has a value, P, Q, I has no value, and vice versa, storage space waste is caused.
In an embodiment of the present application, a method for storing historical data is provided, including: the method comprises the steps that CIM measurement data are obtained and grouped according to the specific subtype of the power system resource to which each CIM measurement data belongs, and first grouped data are obtained; performing secondary grouping on the first grouped data according to the same acquisition period to obtain second grouped data; writing the second grouping data into a first dictionary table and a second dictionary table, wherein the first dictionary table is used for storing CIM measurement grouping information and comprises the following steps: the group ID, the group name, the power system resource type name and the name of the corresponding historical data table, the group ID is used as a main key in the first dictionary table, and the CIM measurement configuration information is stored in the second dictionary table, and the method comprises the following steps: the measurement name, the type name of the affiliated power system resource, the grouping ID and the list name of the corresponding historical data table, and the second dictionary table takes the measurement name and the type name of the affiliated power system resource as a joint main key; according to the first dictionary table and the second dictionary table, a measurement history data table used for storing measurement history value data is established, each measurement history data table corresponds to each group ID one by one, and the measurement history data table comprises: the measurement history data table takes the power system resource ID and the time mark as a joint main key. According to the historical data storage method, a group of measurements which belong to the same power system resource type and have the same measurement value acquisition period are stored in a historical data table, and the measurement historical values of the same power system resource object acquired at the same time point are located in the same record, so that when a plurality of measurement value data of the same power system resource object are stored, time values do not need to be written repeatedly, the storage requirement is reduced, and the storage efficiency of the measurement historical data of a power grid CIM model is effectively improved; when the method is used for reading, a plurality of measurement values of the designated time can be obtained at one time, so that the access efficiency is improved; the technical problems that an existing historical data measuring storage mode is low in storage efficiency and data access efficiency are solved.
For easy understanding, please refer to fig. 2, another historical data storage method in an embodiment of the present application includes:
It should be noted that, first, a first dictionary table HIS _ CIMMeasGroup is constructed, and is used for storing CIM measurement grouping information, and the method includes: the group ID, the group name, the name of the resource type of the power system to which the group belongs, the name of the corresponding historical data table, and the 'group ID' of the HIS _ CIMMeasGroup table is a main key. Constructing a second dictionary table HIS _ CIMMeasment for storing CIM measurement configuration information, wherein the second dictionary table HIS _ CIMMeasment comprises the following steps: measuring the name, the type name of the power system resource, the grouping ID, and corresponding to the list name of the historical data list; the HIS _ CIMMeasment table takes the column of ' measurement name ' and the name of the affiliated power system resource type ' as joint main keys.
It should be noted that step 202 is the same as step 101 in the previous embodiment, and detailed description thereof is omitted here.
And 203, performing secondary grouping on the first grouped data according to the same acquisition period to obtain second grouped data.
It should be noted that step 204 is the same as step 102 in the previous embodiment, and is not described in detail here.
And step 204, writing the second grouping data into the first dictionary table and the second dictionary table.
It should be noted that step 204 is the same as step 103 in the previous embodiment, and is not described in detail here.
It should be noted that step 205 is the same as step 104 in the previous embodiment, and detailed description thereof is omitted here.
Further, the column names of the data columns correspond to the column names of the corresponding historical data tables one to one.
Further, the table name format of the measurement history data table is: HIS _ plus packet ID.
For convenience of understanding, please refer to fig. 3, in an embodiment of the present application, a historical data read-write method based on the foregoing historical data storage method is further provided, and the historical data read-write method provided in the embodiment of the present application includes:
when the measurement history values are written:
When reading the measurement history values:
For easy understanding, referring to fig. 4, in an embodiment of the present application, there is further provided a history data storage apparatus, including:
the dictionary unit 501 is used for constructing a first dictionary table with a table name of HIS _ CIMMeasGroup and a second dictionary table with a table name of HIS _ CIMMeasment.
The first grouping unit 502 is configured to obtain CIM measurement data, and group the CIM measurement data according to a specific subtype of a power system resource to which each CIM measurement data belongs, to obtain first grouping data.
The second grouping unit 503 is configured to perform secondary grouping on the first group data according to the same acquisition cycle to obtain second group data.
A writing unit 504, configured to write the second packet data into a first dictionary table and a second dictionary table, where the first dictionary table is used to store CIM measurement packet information, and includes: the group ID, the group name, the power system resource type name and the name of the corresponding historical data table, the group ID is used as a main key in the first dictionary table, and the CIM measurement configuration information is stored in the second dictionary table, and the method comprises the following steps: the measurement name, the belonging power system resource type name, the grouping ID and the corresponding historical data list column name, and the second dictionary list takes the measurement name and the belonging power system resource type name as a joint main key.
A history unit 505, configured to create a measurement history data table for storing measurement history value data according to the first dictionary table and the second dictionary table, where each measurement history data table corresponds to each group ID one by one, and the measurement history data table includes: the measurement history data table takes the power system resource ID and the time mark as a joint main key.
In an embodiment of the present application, there is further provided a historical data storage device, where the device includes a processor and a memory:
the memory is used for storing the program codes and transmitting the program codes to the processor;
the processor is configured to execute the history data storage method in the foregoing method embodiment according to instructions in the program code.
In an embodiment of the present application, a computer-readable storage medium is further provided, and is configured to store a program code, where the program code is configured to execute the historical data storage method in the foregoing method embodiment.
In an embodiment of the present application, there is also provided a computer program product including instructions, which when run on a computer, cause the computer to execute the history data storage method in the foregoing method embodiment.
The terms "first," "second," "third," "fourth," and the like in the description of the application and the above-described figures, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are, for example, capable of operation in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
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. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
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, may be located in one place, or may be 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, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes 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 steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U disk, a removable hard disk, 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.
The above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
Claims (10)
1. A method of historical data storage, comprising:
the method comprises the steps of obtaining CIM measurement data, and grouping according to the specific subtype of the power system resource to which each CIM measurement data belongs to obtain first grouping data;
performing secondary grouping on the first grouped data according to the same acquisition period to obtain second grouped data, which specifically comprises the following steps: acquiring an acquisition period of first grouped data, grouping the first grouped data with the same acquisition period into a group, and storing the measured data of different acquisition periods in a grouped manner to obtain second grouped data, wherein the acquisition period is determined by the measured data to be acquired, and the measured data of the same acquisition period are configured with the same time scale;
writing the second packet data into a first dictionary table and a second dictionary table, wherein the first dictionary table is used for storing CIM measurement packet information and comprises the following steps: the first dictionary table takes the group ID as a main key, and the second dictionary table is used for storing CIM measurement configuration information, and the method comprises the following steps: the second dictionary table takes the measurement name and the belonging power system resource type name as joint main keys;
creating a measurement history data table for storing measurement history value data according to the first dictionary table and the second dictionary table, wherein each measurement history data table corresponds to each group ID one by one, and the measurement history data table comprises: the measurement history data table takes the power system resource ID and the time mark as a joint main key.
2. The method of claim 1, wherein writing the second packet of data into the first dictionary table and the second dictionary table further comprises:
a first dictionary table with a table name of HIS _ CIMMeasGroup and a second dictionary table with a table name of HIS _ CIMMeasment are constructed.
3. The method of claim 1, wherein the measurement history data table has a table name format of: HIS _ plus packet ID.
4. The method of claim 3, wherein column names of the data columns are in one-to-one correspondence with column names of the corresponding historical data tables.
5. A history data read-write method based on the history data storage method according to any one of claims 1 to 4, wherein when a measurement history value is written:
querying a second dictionary table according to the measurement name and the resource type name of the power system as a filtering condition to obtain a corresponding historical data list name and a group ID;
querying the first dictionary table by taking the group ID as a filtering condition to determine the corresponding historical data table name;
organizing historical data writing, namely writing a plurality of measured historical values belonging to the same corresponding historical data table into the corresponding historical data table at the same time;
when reading the measurement history values:
querying a second dictionary table according to the measurement name and the resource type name of the power system as a filtering condition to obtain a corresponding historical data list name and a grouping ID;
querying a first dictionary table by taking the group ID as a filtering condition, and determining a corresponding historical data table name;
and (4) reading the organization historical data, and acquiring a plurality of measured historical values belonging to the same historical data table at one time.
6. A historical data storage device, comprising:
the first grouping unit is used for acquiring CIM measurement data and grouping the CIM measurement data according to the specific subtype of the power system resource to which the CIM measurement data belongs to obtain first grouping data;
the second grouping unit is used for performing secondary grouping on the first grouping data according to the same acquisition cycle to obtain second grouping data, and specifically comprises the following steps: acquiring an acquisition period of first grouped data, grouping the first grouped data with the same acquisition period into a group, and storing the measured data of different acquisition periods in a grouped manner to obtain second grouped data, wherein the acquisition period is determined by the measured data to be acquired, and the measured data of the same acquisition period are configured with the same time scale;
a writing unit, configured to write the second packet data into a first dictionary table and a second dictionary table, where the first dictionary table is used to store CIM measurement packet information, and the writing unit includes: the first dictionary table takes the group ID as a main key, and the second dictionary table is used for storing CIM measurement configuration information, and the method comprises the following steps: the second dictionary table takes the measurement name and the belonging power system resource type name as joint main keys;
a history unit, configured to create a measurement history data table for storing measurement history value data according to the first dictionary table and the second dictionary table, where each measurement history data table corresponds to each group ID one to one, and the measurement history data table includes: the measurement history data table takes the power system resource ID and the time mark as a joint main key.
7. The historical data storage device of claim 6, wherein the device further comprises:
and the dictionary unit is used for constructing a first dictionary table with the table name of HIS _ CIMMeasGroup and a second dictionary table with the table name of HIS _ CIMMeasment.
8. A historical data storage device, the device comprising a processor and a memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to execute the historical data storage method of any one of claims 1-4 according to instructions in the program code.
9. A computer-readable storage medium characterized in that the computer-readable storage medium stores a program code for executing the history data storage method according to any one of claims 1 to 4.
10. A computer program product comprising instructions which, when run on a computer, cause the computer to perform the historical data storage method of any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811527945.3A CN109684517B (en) | 2018-12-13 | 2018-12-13 | Historical data storage method, reading and writing method, storage device and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811527945.3A CN109684517B (en) | 2018-12-13 | 2018-12-13 | Historical data storage method, reading and writing method, storage device and equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109684517A CN109684517A (en) | 2019-04-26 |
| CN109684517B true CN109684517B (en) | 2022-01-25 |
Family
ID=66186638
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811527945.3A Active CN109684517B (en) | 2018-12-13 | 2018-12-13 | Historical data storage method, reading and writing method, storage device and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109684517B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110515952A (en) * | 2019-08-28 | 2019-11-29 | 广州高谱技术有限公司 | A kind of storage method of electric power data |
| CN112256697A (en) * | 2020-10-14 | 2021-01-22 | 宁波三星医疗电气股份有限公司 | Method for managing data of power acquisition terminal |
| CN112651136B (en) * | 2020-12-31 | 2022-01-21 | 广东电网有限责任公司电力科学研究院 | CIM equipment measurement model generation method, device, equipment and medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105357311A (en) * | 2015-11-23 | 2016-02-24 | 中国南方电网有限责任公司 | Secondary equipment big data storage and processing method by utilizing cloud computing technology |
| CN105959131A (en) * | 2016-04-15 | 2016-09-21 | 贵州电网有限责任公司信息中心 | Electric power information network security measuring method based on security log data mining |
| CN107943831A (en) * | 2017-10-23 | 2018-04-20 | 国家电网公司西北分部 | HBase-based power grid historical data centralized storage method |
| CN108256088A (en) * | 2018-01-23 | 2018-07-06 | 清华大学 | A kind of storage method and system of the time series data based on key value database |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102033882B (en) * | 2009-09-25 | 2013-07-03 | 中兴通讯股份有限公司 | Method and system for storing performance data |
-
2018
- 2018-12-13 CN CN201811527945.3A patent/CN109684517B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105357311A (en) * | 2015-11-23 | 2016-02-24 | 中国南方电网有限责任公司 | Secondary equipment big data storage and processing method by utilizing cloud computing technology |
| CN105959131A (en) * | 2016-04-15 | 2016-09-21 | 贵州电网有限责任公司信息中心 | Electric power information network security measuring method based on security log data mining |
| CN107943831A (en) * | 2017-10-23 | 2018-04-20 | 国家电网公司西北分部 | HBase-based power grid historical data centralized storage method |
| CN108256088A (en) * | 2018-01-23 | 2018-07-06 | 清华大学 | A kind of storage method and system of the time series data based on key value database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109684517A (en) | 2019-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109684517B (en) | Historical data storage method, reading and writing method, storage device and equipment | |
| Ribeiro et al. | G-tries: an efficient data structure for discovering network motifs | |
| CN107766575B (en) | Read-write separation database access method and device | |
| CN106933836B (en) | Data storage method and system based on sub-tables | |
| CN109309596B (en) | Pressure testing method and device and server | |
| CN104965886A (en) | Data dimension processing method | |
| CN103559323A (en) | Database implementation method | |
| CN112632015A (en) | Data format conversion method and device, storage medium and electronic equipment | |
| CN108038018A (en) | Expansible daily record data storage method and device | |
| CN113553341A (en) | Multidimensional data analysis method, multidimensional data analysis device, multidimensional data analysis equipment and computer readable storage medium | |
| CN107515807B (en) | Method and device for storing monitoring data | |
| CN105242873B (en) | The acquisition of the performance data of cloud computing system and storage method and device | |
| JP5972472B2 (en) | Data processing apparatus, data processing method, and program | |
| CN114881508A (en) | Data processing method, device and equipment for power grid index report | |
| CN106776704A (en) | Statistical information collection method and device | |
| CN108564261A (en) | Method, apparatus and computer equipment are determined based on the power information of work ticket | |
| CN112486841A (en) | Method and device for checking data collected by buried point | |
| JP2016024486A (en) | Data utilization system and control method therefor | |
| CN111026762A (en) | Red and black tree index generation method and device, electronic equipment and storage medium | |
| CN111125074A (en) | Power distribution Internet of things data processing method and device | |
| CN106469086B (en) | Event processing method and device | |
| CN113376564B (en) | Smart electric meter metering correction method and device based on data analysis and terminal | |
| CN109271303B (en) | Software configuration recommendation method | |
| CN105681097A (en) | Method and device for obtaining replacing cycle of terminal device | |
| CN117271480B (en) | Data processing method, device, electronic equipment and medium |
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 |