CN109684517A - A kind of historical data storage method, reading/writing method, storage device and equipment - Google Patents
A kind of historical data storage method, reading/writing method, storage device and equipment Download PDFInfo
- Publication number
- CN109684517A CN109684517A CN201811527945.3A CN201811527945A CN109684517A CN 109684517 A CN109684517 A CN 109684517A CN 201811527945 A CN201811527945 A CN 201811527945A CN 109684517 A CN109684517 A CN 109684517A
- Authority
- CN
- China
- Prior art keywords
- historical data
- name
- packet
- data
- power system
- 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.)
- Granted
Links
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
Abstract
This application discloses a kind of historical data storage method, reading/writing method, storage device and equipment, by belong to same power system resource type, measure the identical one group of measurement of value collection period and be stored in a historical data table, the measurement history value of the same power system resource object of same time point acquisition is located in same record, so that when multiple measurement value data storage of same power system resource object, it does not need to be repeatedly written time value, reduce storage demand, effectively improves the storage efficiency that power grid CIM model measures historical data；Multiple measurement values that specified time then can be once obtained when reading, improve access efficiency；Solving the existing storage mode for measuring historical data, there are the low technical problems low with data access efficiency of storage efficiency.
Description
Technical field
This application involves technical field of data processing more particularly to a kind of historical data storage method, reading/writing method, storages
Device and equipment.
Background technique
With the continuous development of computer technology with the continuous improvement of the level of informatization, data volume is increased rapidly, towards sea
Data storage and application are measured also with flourishing, big data reference is more and more extensive.
Electric detection system can generate a large amount of metric data, i.e., the various prisons acquired by sensor in the process of running
Depending on the data of power equipment operation, by the electric power in the Energy Management System interface standard of International Electrotechnical Commission (IEC) formulation
The measurement model of system common information model (CIM, Common Information Model) models this, and at it
Component interface specification (CIS, Component Interface Specification) provides going through for measurement value history
History data access interface.
In CIM measurement model, measurement be abstracted with power system resource (Power System Resource) type and
Multiple measurements (Measurement) of its descendants's type association and measuring value (MeasurementValue), in CIS data access
In interface, the access for measuring historical data is also to carry out for measurement value object one by one, this to be directly facing single measurement
Model description and history value mode for Power System description and historical data access acquisition be appropriate, but using pass
When to be database be backstage storage facility, being directly facing single measuring value list table mode of single measuring value, but to there is storage efficiency low
The problem low with data access efficiency.
Summary of the invention
The embodiment of the present application provides a kind of historical data storage method, reading/writing method, storage device and equipment, solves
There are the low technical problems low with data access efficiency of storage efficiency for the existing storage mode for measuring historical data.
In view of this, the application first aspect provides a kind of historical data storage method, comprising:
Obtain CIM metric data, according to each CIM metric data affiliated power system resource specific subtype into
Row grouping, obtains the first packet data；
Secondary grouping is carried out according to identical collection period to first packet data, obtains second packet data；
The second packet data are written in the first dictionary table and the second dictionary table, first dictionary table is for storing
CIM measures grouping information, comprising: packet ID, packet name, the power system resource type name and corresponding historical data table name,
Using the packet ID as major key, second dictionary table wraps first dictionary table for storing CIM measure configuration information
It includes: measuring name, the affiliated power system resource type name, the packet ID and corresponding historical data table column name, it is described
Second dictionary table is using the measurement name and the affiliated power system resource type name as joint major key；
According to first dictionary table and second dictionary table, creation measures the measurement of history value data for storing
Historical data table, each measurement historical data table and each packet ID correspond, the measurement historical data table
Include: power system resource ID, markers and arranged to measure the data of the value of each measurement in grouping creation, the measurement is gone through
History tables of data with the power system resource ID and it is described when be designated as joint major key.
Preferably, described that the second packet data are written in the first dictionary table and the second dictionary table, before further include:
The first dictionary table and table name that building table name is HIS_CIMMeasGroup are the second of HIS_CIMMeasment
Dictionary table.
Preferably, the table name format for measuring historical data table are as follows: HIS_ adds packet ID.
Preferably, the column name of the data column is corresponded with the corresponding historical data table column name.
The application second aspect provides a kind of historical data reading/writing method, based on historical data as described in relation to the first aspect
Storage method, when write-in measures history value:
The second dictionary table, acquisition pair are inquired according to name and affiliated power system resource type name is measured as filter condition
The historical data table column name and packet ID answered；
The first dictionary table, which is inquired, as filter condition using packet ID determines corresponding corresponding historical data table name；
Historical data write-in is organized, by the history value for belonging to multiple measurements of same corresponding historical data table while being written
Corresponding historical data table；
When reading measurement history value:
The second dictionary table, acquisition pair are inquired according to name and affiliated power system resource type name is measured as filter condition
In corresponding historical data table column name and packet ID；
The first dictionary table is inquired by filter condition of packet ID, determines corresponding corresponding historical data table name；
It organizes historical data to read, the history value for belonging to multiple measurements of same historical data table is disposably obtained.
The application third aspect provides a kind of history data store device, comprising:
First grouped element, for obtaining CIM metric data, according to the affiliated electric system of each CIM metric data
The specific subtype of resource is grouped, and obtains the first packet data；
Second packet unit is obtained for carrying out secondary grouping according to identical collection period to first packet data
To second packet data；
Writing unit, for the second packet data to be written in the first dictionary table and the second dictionary table, described first
Dictionary table measures grouping information for storing CIM, comprising: packet ID, packet name, the power system resource type name and correspondence
Historical data table name, first dictionary table is using the packet ID as major key, and second dictionary table is for storing CIM measurement
Configuration information, comprising: measure name, the affiliated power system resource type name, the packet ID and corresponding historical data table
Column name, second dictionary table is using the measurement name and the affiliated power system resource type name as joint major key；
History unit, for according to first dictionary table and second dictionary table, creation to measure history for storing
The measurement historical data table of value data, each measurement historical data table and each packet ID correspond, described
Measure the number that historical data table includes: power system resource ID, markers and the value creation for each measurement in measurement grouping
According to column, the measurement historical data table with the power system resource ID and it is described when be designated as joint major key.
Preferably, described device further include:
Dictionary unit is HIS_ for constructing the first dictionary table that table name is HIS_CIMMeasGroup and table name
The second dictionary table of CIMMeasment.
The application fourth aspect provides a kind of history data store equipment, and the equipment includes processor and storage
Device:
Said program code is transferred to the processor for storing program code by the memory；
The processor is used for the history data store according to the instruction execution first aspect in said program code
Method.
The 5th aspect of the application provides a kind of computer readable storage medium, and the computer readable storage medium is used for
Program code is stored, said program code is for executing historical data storage method described in first aspect.
The 6th aspect of the application provides a kind of computer program product including instruction, when it runs on computers
When, so that the computer executes historical data storage method described in first aspect.
As can be seen from the above technical solutions, the embodiment of the present application has the advantage that
In the application, a kind of historical data storage method is provided, comprising: CIM metric data is obtained, according to each CIM amount
The specific subtype of the affiliated power system resource of measured data is grouped, and obtains the first packet data；To the first packet data
Secondary grouping is carried out according to identical collection period, obtains second packet data；The first dictionary table is written into second packet data
In the second dictionary table, the first dictionary table measures grouping information for storing CIM, comprising: packet ID, packet name, electric system
Resource type name and corresponding historical data table name, the first dictionary table is using packet ID as major key, and the second dictionary table is for storing CIM
Measure configuration information, comprising: measure name, affiliated power system resource type name, packet ID and corresponding historical data table column name
Word, the second dictionary table is to measure name and affiliated power system resource type name as joint major key；According to the first dictionary table and
Second dictionary table, creation for store measure history value data measurement historical data table, each measurement historical data table and
Each packet ID corresponds, and measuring historical data table includes: power system resource ID, markers and each of to measure in grouping
Measurement value creation data column, measure historical data table with power system resource ID and when be designated as joint major key.The application
The historical data storage method of offer, by belong to same power system resource type, measure value collection period it is identical
One group of measurement is stored in a historical data table, the measurement history of the same power system resource object of same time point acquisition
Value is located in same record, so that not needing when multiple measurement value data storage of same power system resource object
It is repeatedly written time value, reduces storage demand, effectively improves the storage efficiency that power grid CIM model measures historical data；It reads
Multiple measurement values that specified time then can be once obtained when taking, improve access efficiency；Solves existing measurement history
There are the low technical problems low with data access efficiency of storage efficiency for the storage mode of data.
Detailed description of the invention
Fig. 1 is the flow diagram of one of the embodiment of the present application historical data storage method；
Fig. 2 is another flow diagram of one of the embodiment of the present application historical data storage method；
Fig. 3 is the flow diagram of one of the embodiment of the present application historical data reading/writing method；
Fig. 4 is the structural schematic diagram of one of the embodiment of the present application history data store device.
Specific embodiment
In order to make those skilled in the art more fully understand application scheme, below in conjunction in the embodiment of the present application
Attached drawing, the technical scheme in the embodiment of the application is clearly and completely described, it is clear that described embodiment is only this
Apply for a part of the embodiment, instead of all the embodiments.Based on the embodiment in the application, those of ordinary skill in the art exist
Every other embodiment obtained under the premise of creative work is not made, shall fall in the protection scope of this application.
In order to make it easy to understand, referring to Fig. 1, a kind of historical data storage method in the embodiment of the present application, comprising:
Step 101 obtains CIM metric data, according to the specific subclass of the affiliated power system resource of each CIM metric data
Type is grouped, and obtains the first packet data.
It should be noted that CIM common information model is a kind of all object logics structures of description electric system and relationship
Information model, power system resource is described as object class, attribute and the relationship between them.It is obtained in the embodiment of the present application
All CIM metric data are taken, can be and be acquired by multiple and different collection period, according to each CIM metric data
The specific subtype of affiliated power system resource is grouped, the specific subtype of power system resource can be Breaker,
Disconnector and BusbarSection etc..
Step 102 carries out secondary grouping according to identical collection period to the first packet data, obtains second packet number
According to.
It should be noted that collection period is determined by the business feature of the measurement of required acquisition, for gradual measurement,
Frequency acquisition is relatively low, and collection period is longer, and for the measurement become fastly, frequency acquisition is higher, and collection period is shorter.The application is real
It applies in example, the first packet data of identical collection period is grouped into the same group, the measurement in different acquisition period is grouped storage.
Second packet data are written in the first dictionary table and the second dictionary table step 103, and the first dictionary table is for storing
CIM measures grouping information, comprising: packet ID, packet name, power system resource type name and corresponding historical data table name, first
Dictionary table is using packet ID as major key, and the second dictionary table is for storing CIM measure configuration information, comprising: measures name, affiliated electricity
Force system resource type name, packet ID and corresponding historical data table column name, the second dictionary table is to measure name and affiliated electric power
Type of system resource name is used as joint major key.
It should be noted that for store CIM measure grouping information the first dictionary table, comprising: packet ID, packet name,
Power system resource type name and corresponding historical data table name, as shown in the table:
First dictionary table is using packet ID as major key.
For storing the second dictionary table of CIM measure configuration information, comprising: measure name, affiliated power system resource class
Type name, packet ID and corresponding historical data table column name, as shown in the table:
Measuring name is possible duplicate (having P, Q, I) for different type, such as Breaker or BusbarSection,
But then must be unique to same type, so the second dictionary table is to measure name and affiliated power system resource type name as connection
Close major key.
Step 104, according to the first dictionary table and the second dictionary table, creation is for store the measurement of measurement history value data
Historical data table, each measurement historical data table and each packet ID correspond, and measuring historical data table includes: electric system
The data column of resource ID, markers and the value creation for each measurement in measurement grouping, measure historical data table with power train
System resource ID and when be designated as joint major key.
It should be noted that markers, that is, measure the time of acquisition value, the measurement of identical collection period, each acquisition week
The markers of phase collected data is identical.In the embodiment of the present application, it is as shown in the table to measure historical data table:
| Power system resource ID | Markers | Col_1 | Col_2 | Col_3 | Col_4 | Col_5 |
| PSR_1 | T1 | P value | Q value | Ia value | Ib value | Ic value |
| PSR_1 | T2 | P value | Q value | Ia value | Ib value | Ic value |
| PSR_2 | T1 | P value | Q value | Ia value | Ib value | Ic value |
| PSR_2 | T2 | P value | Q value | Ia value | Ib value | Ic value |
| PSR_1 | T3 | P value | Q value | Ia value | Ib value | Ic value |
| PSR_2 | T3 | P value | Q value | Ia value | Ib value | Ic value |
| PSR_3 | T1 | P value | Q value | Ia value | Ib value | Ic value |
| PSR_3 | T4 | P value | Q value | Ia value | Ib value | Ic value |
It, can be according to the type for measuring name (P), measuring affiliated power system resource in the embodiment of the present application
(BusbarSection) the corresponding historical data table column name (Col_1) of the second dictionary table acquisition is inquired as filter condition, divide
Group ID (4) is that filter condition the first dictionary table of inquiry determines corresponding historical data data table name (His_4) with packet ID (4).
If being written Breaker (P, Q), BusbarSection (Q, I), it is determined that access His_1 (Col_1, Col_2), His_4 (Col_
2, Col_3), thus the data of the two tables can be distinguished into batch processing, reaches the mesh for accelerating the access to database table
, while the multirow of multiple column of a table is accessed, each column than accessing a table respectively are high-efficient.It is taken measuring history
When value storage, multiple measurements for the same collection period of same power system resource object, as measured institute in historical data table
Show, it can be seen that for multiple measurements (Co_1, Col_2, Col_3) of the same PSR, markers is only had recorded once, no
It needs to be repeatedly written markers, reduces storage demand, improve storage efficiency；Correspondingly, when measuring the reading of history value, it is right
It can once be obtained in multiple measurements of the same collection period of same power system resource object, improve access efficiency.
It should be noted that historical data storage method provided by the embodiments of the present application, for measuring value collection period
Grouping, avoids under same time point, the measurement in a power system resource object associated different acquisition period, due to part
There is value, partially without wasted storage caused by value, as shown in the table, if be not grouped, has value in SState
When, P, Q, I void value, vice versa, has resulted in waste of storage space.
In the embodiment of the present application, a kind of historical data storage method is provided, comprising: CIM metric data is obtained, according to each
The specific subtype of the affiliated power system resource of CIM metric data is grouped, and obtains the first packet data；It is grouped to first
Data carry out secondary grouping according to identical collection period, obtain second packet data；The first word is written into second packet data
In allusion quotation table and the second dictionary table, the first dictionary table measures grouping information for storing CIM, comprising: packet ID, packet name, electric power
Type of system resource name and corresponding historical data table name, the first dictionary table is using packet ID as major key, and the second dictionary table is for depositing
Store up CIM measure configuration information, comprising: measure name, affiliated power system resource type name, packet ID and corresponding historical data table
Column name, the second dictionary table is to measure name and affiliated power system resource type name as joint major key；According to the first dictionary
Table and the second dictionary table, creation measure the measurement historical data table of history value data, each measurement historical data for storing
Table and each packet ID correspond, and measuring historical data table includes: power system resource ID, markers and to measure in grouping
Each measurement value creation data column, measure historical data table with power system resource ID and when be designated as joint major key.This
The historical data storage method provided is provided, same power system resource type, measurement value collection period phase will be belonged to
One group of same measurement is stored in a historical data table, the measurement of the same power system resource object of same time point acquisition
History value is located in same record, so that when multiple measurement value data storage of same power system resource object, no
It needs to be repeatedly written time value, reduces storage demand, effectively improve the storage effect that power grid CIM model measures historical data
Rate；Multiple measurement values that specified time then can be once obtained when reading, improve access efficiency；Solves existing measurement
There are the low technical problems low with data access efficiency of storage efficiency for the storage mode of historical data.
In order to make it easy to understand, referring to Fig. 2, another historical data storage method in the embodiment of the present application, comprising:
The first dictionary table and table name that step 201, building table name are HIS_CIMMeasGroup are HIS_
The second dictionary table of CIMMeasment.
It should be noted that constructing the first dictionary table HIS_CIMMeasGroup first, grouping letter is measured for storing CIM
Breath, comprising: packet ID, packet name, affiliated power system resource type name, corresponding historical data table name, HIS_
CIMMeasGroup table " packet ID " is classified as major key.The second dictionary table HIS_CIMMeasment is constructed, is measured for storing CIM
Configuration information, comprising: measure name, affiliated power system resource type name, packet ID, corresponding historical data table column name；
HIS_CIMMeasment table is to arrange " measuring name ", affiliated power system resource type name " for joint major key.
Step 202 obtains CIM metric data, according to the specific subclass of the affiliated power system resource of each CIM metric data
Type is grouped, and obtains the first packet data.
It should be noted that all step 101 is consistent in step 202 and preceding embodiment, no longer it is described in detail herein.
Step 203 carries out secondary grouping according to identical collection period to the first packet data, obtains second packet number
According to.
It should be noted that the step 102 in step 204 and preceding embodiment is consistent, no longer it is described in detail herein.
Second packet data are written in the first dictionary table and the second dictionary table step 204.
It should be noted that the step 103 in step 204 and preceding embodiment is consistent, no longer it is described in detail herein.
Step 205, according to the first dictionary table and the second dictionary table, creation is for store the measurement of measurement history value data
Historical data table, each measurement historical data table and each packet ID correspond, and measuring historical data table includes: electric system
The data column of resource ID, markers and the value creation for each measurement in measurement grouping, measure historical data table with power train
System resource ID and when be designated as joint major key.
It should be noted that the step 104 in step 205 and preceding embodiment is consistent, no longer it is described in detail herein.
Further, the column name of data column is corresponded with corresponding historical data table column name.
Further, the table name format of historical data table is measured are as follows: HIS_ adds packet ID.
In order to make it easy to understand, referring to Fig. 3, being additionally provided a kind of based on historical data above-mentioned in the embodiment of the present application
The historical data reading/writing method of storage method, historical data reading/writing method provided by the embodiments of the present application, comprising:
When write-in measures history value:
Step 301, according to measuring name and affiliated power system resource type name as filter condition the second dictionary of inquiry
Table obtains corresponding historical data table column name and packet ID.
Step 302 determines corresponding corresponding historical data table name by filter condition the first dictionary table of inquiry of packet ID.
Step 303, tissue historical data write-in, will belong to the history value of multiple measurements of same corresponding historical data table
Corresponding historical data table is written simultaneously.
When reading measurement history value:
Step 401, according to measuring name and affiliated power system resource type name as filter condition the second dictionary of inquiry
Table is obtained for corresponding historical data table column name and packet ID.
Step 402 inquires the first dictionary table by filter condition of packet ID, determines corresponding corresponding historical data table name.
Step 403, tissue historical data are read, and the history value that will belong to multiple measurements of same historical data table is primary
Property obtain.
In order to make it easy to understand, wrapping referring to Fig. 4, additionally provide a kind of history data store device in the embodiment of the present application
It includes:
Dictionary unit 501 is HIS_ for constructing the first dictionary table that table name is HIS_CIMMeasGroup and table name
The second dictionary table of CIMMeasment.
First grouped element 502 is provided for obtaining CIM metric data according to the affiliated electric system of each CIM metric data
The specific subtype in source is grouped, and obtains the first packet data.
Second packet unit 503 is obtained for carrying out secondary grouping according to identical collection period to the first packet data
Second packet data.
Writing unit 504, for second packet data to be written in the first dictionary table and the second dictionary table, the first dictionary table
Grouping information is measured for storing CIM, comprising: packet ID, packet name, power system resource type name and corresponding historical data table
Name, the first dictionary table is using packet ID as major key, and the second dictionary table is for storing CIM measure configuration information, comprising: measures name
Word, affiliated power system resource type name, packet ID and corresponding historical data table column name, the second dictionary table with measure name and
Affiliated power system resource type name is used as joint major key.
History unit 505, for according to the first dictionary table and the second dictionary table, creation to measure history value number for storing
According to measurement historical data table, each measurement historical data table and each packet ID correspond, and measuring historical data table includes:
The data column of power system resource ID, markers and the value creation for each measurement in measurement grouping, measure historical data table
With power system resource ID and when be designated as joint major key.
In the embodiment of the present application, a kind of history data store equipment is additionally provided, equipment includes processor and memory:
Program code is transferred to processor for storing program code by memory；
Processor is used for according to the historical data storage method in the instruction execution preceding method embodiment in program code.
In the embodiment of the present application, a kind of computer readable storage medium is additionally provided, computer readable storage medium is used for
Program code is stored, program code is used to execute the historical data storage method in preceding method embodiment.
In the embodiment of the present application, a kind of computer program product including instruction is additionally provided, when it is transported on computers
When row, so that computer executes the historical data storage method in preceding method embodiment.
The description of the present application and term " first " in above-mentioned attached drawing, " second ", " third ", " the 4th " etc. are (if deposited
) it is to be used to distinguish similar objects, without being used to describe a particular order or precedence order.It should be understood that use in this way
Data are interchangeable under appropriate circumstances, so that embodiments herein described herein for example can be in addition to illustrating herein
Or the sequence other than those of description is implemented.In addition, term " includes " and " having " and their any deformation, it is intended that
Cover it is non-exclusive include, for example, containing the process, method, system, product or equipment of a series of steps or units need not limit
In step or unit those of is clearly listed, but may include be not clearly listed or for these process, methods, produce
The other step or units of product or equipment inherently.
In several embodiments provided herein, it should be understood that disclosed device and method can pass through it
Its mode is realized.For example, the apparatus embodiments described above are merely exemplary, for example, the division of the unit, only
Only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can be tied
Another system is closed or is desirably integrated into, or some features can be ignored or not executed.Another point, it is shown or discussed
Mutual coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or logical of device or unit
Letter connection can be electrical property, mechanical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
It, can also be in addition, each functional unit in each embodiment of the application can integrate in one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can store in a computer readable storage medium.Based on this understanding, the technical solution of the application is substantially
The all or part of the part that contributes to existing technology or the technical solution can be in the form of software products in other words
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (can be personal computer, server or the network equipment etc.) executes the complete of each embodiment the method for the application
Portion or part steps.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory (full name in English: Read-Only
Memory, english abbreviation: ROM), random access memory (full name in English: Random Access Memory, english abbreviation:
RAM), the various media that can store program code such as magnetic or disk.
The above, above embodiments are only to illustrate the technical solution of the application, rather than its limitations；Although referring to before
Embodiment is stated the application is described in detail, those skilled in the art should understand that: it still can be to preceding
Technical solution documented by each embodiment is stated to modify or equivalent replacement of some of the technical features；And these
It modifies or replaces, the spirit and scope of each embodiment technical solution of the application that it does not separate the essence of the corresponding technical solution.
Claims (10)
1. a kind of historical data storage method characterized by comprising
CIM metric data is obtained, is divided according to the specific subtype of the affiliated power system resource of each CIM metric data
Group obtains the first packet data；
Secondary grouping is carried out according to identical collection period to first packet data, obtains second packet data；
The second packet data are written in the first dictionary table and the second dictionary table, first dictionary table is for storing CIM
Measure grouping information, comprising: packet ID, packet name, the power system resource type name and corresponding historical data table name, it is described
First dictionary table is using the packet ID as major key, and second dictionary table is for storing CIM measure configuration information, comprising: amount
Survey name, the affiliated power system resource type name, the packet ID and corresponding historical data table column name, second word
Allusion quotation table is using the measurement name and the affiliated power system resource type name as joint major key；
According to first dictionary table and second dictionary table, creation measures the measurement history of history value data for storing
Tables of data, each measurement historical data table and each packet ID correspond, and the measurement historical data table includes:
The data column of power system resource ID, markers and the value creation for each measurement in measurement grouping, the measurement history number
According to table with the power system resource ID and it is described when be designated as joint major key.
2. historical data storage method according to claim 1, which is characterized in that described to write the second packet data
Enter in the first dictionary table and the second dictionary table, before further include:
Construct the first dictionary table that table name is HIS_CIMMeasGroup and the second dictionary that table name is HIS_CIMMeasment
Table.
3. historical data storage method according to claim 1, which is characterized in that the table name for measuring historical data table
Format are as follows: HIS_ adds packet ID.
4. historical data storage method according to claim 3, which is characterized in that the column name of data column with it is described right
Historical data table column name is answered to correspond.
5. a kind of historical data reading/writing method, based on the history data store side as described in any one of Claims 1-4
Method, which is characterized in that when write-in measures history value:
The second dictionary table is inquired according to name and affiliated power system resource type name is measured as filter condition, is obtained corresponding
Historical data table column name and packet ID；
The first dictionary table, which is inquired, as filter condition using packet ID determines corresponding corresponding historical data table name；
Historical data write-in is organized, by the history value for belonging to multiple measurements of same corresponding historical data table while correspondence is written
Historical data table；
When reading measurement history value:
The second dictionary table is inquired according to name and affiliated power system resource type name is measured as filter condition, is obtained for right
The historical data table column name and packet ID answered；
The first dictionary table is inquired by filter condition of packet ID, determines corresponding corresponding historical data table name；
It organizes historical data to read, the history value for belonging to multiple measurements of same historical data table is disposably obtained.
6. a kind of history data store device characterized by comprising
First grouped element, for obtaining CIM metric data, according to the affiliated power system resource of each CIM metric data
Specific subtype be grouped, obtain the first packet data；
Second packet unit obtains for carrying out secondary grouping according to identical collection period to first packet data
Two packet datas；
Writing unit, for the second packet data to be written in the first dictionary table and the second dictionary table, first dictionary
Table measures grouping information for storing CIM, comprising: packet ID, packet name, the power system resource type name and corresponding history
Data table name, first dictionary table is using the packet ID as major key, and second dictionary table is for storing CIM measure configuration
Information, comprising: measure name, the affiliated power system resource type name, the packet ID and corresponding historical data table column name
Word, second dictionary table is using the measurement name and the affiliated power system resource type name as joint major key；
History unit, for according to first dictionary table and second dictionary table, creation to measure history value for storing
The measurement historical data table of data, each measurement historical data table and each packet ID correspond, the measurement
Historical data table includes: power system resource ID, markers and arranges to measure the data of the value of each measurement in grouping creation,
The measurement historical data table with the power system resource ID and it is described when be designated as joint major key.
7. a kind of history data store device according to claim 6, which is characterized in that described device further include:
Dictionary unit is HIS_ for constructing the first dictionary table that table name is HIS_CIMMeasGroup and table name
The second dictionary table of CIMMeasment.
8. a kind of history data store equipment, which is characterized in that the equipment includes processor and memory:
Said program code is transferred to the processor for storing program code by the memory；
The processor is used for according to the described in any item historical datas of instruction execution claim 1-4 in said program code
Storage method.
9. a kind of computer readable storage medium, which is characterized in that the computer readable storage medium is for storing program generation
Code, said program code require the described in any item historical data storage methods of 1-4 for perform claim.
10. a kind of computer program product including instruction, which is characterized in that when run on a computer, so that described
Computer perform claim requires the described in any item historical data storage methods of 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 true CN109684517A (en) | 2019-04-26 |
| CN109684517B 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) |
Cited By (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 |
| CN112651136A (en) * | 2020-12-31 | 2021-04-13 | 广东电网有限责任公司电力科学研究院 | CIM equipment measurement model generation method, device, equipment and medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130006982A1 (en) * | 2009-09-25 | 2013-01-03 | Ming Sun | Storing Method of Performance Data and System Thereof |
| 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 |
-
2018
- 2018-12-13 CN CN201811527945.3A patent/CN109684517B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130006982A1 (en) * | 2009-09-25 | 2013-01-03 | Ming Sun | Storing Method of Performance Data and System Thereof |
| 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 |
Cited By (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 |
| CN112651136A (en) * | 2020-12-31 | 2021-04-13 | 广东电网有限责任公司电力科学研究院 | CIM equipment measurement model generation method, device, equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109684517B (en) | 2022-01-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103593336B (en) | Knowledge pushing system and method based on semantic analysis | |
| CN105426375B (en) | A kind of calculation method and device of relational network | |
| CN109684517A (en) | A kind of historical data storage method, reading/writing method, storage device and equipment | |
| CN110413690A (en) | Method of data synchronization, server, electronic equipment, the storage medium of database | |
| CN110472068A (en) | Big data processing method, equipment and medium based on heterogeneous distributed knowledge mapping | |
| CN107291620A (en) | A kind of method for generating test case and device | |
| RU2005136998A (en) | EFFICIENT AND FLEXIBLE BUSINESS MODELING BASED ON STRUCTURED BUSINESS CHARACTERISTICS | |
| CN104598557A (en) | Method and device for data rasterization and method and device for user behavior analysis | |
| CN110489407A (en) | Data filling mining method, apparatus, computer equipment and storage medium | |
| CN102184299A (en) | Model conversion method and system from CAD (Computer Aided Design) system to three-dimensional checking system | |
| CN106021718A (en) | Drawing method and device used for engineering drawing in CATIA (Computer-graphics Aided Three-dimensional Interactive Application) | |
| CN102521332B (en) | Graphic mode matching method, device and system based on strong simulation | |
| CN104022913B (en) | For method of testing and the device of data cluster | |
| CN108460068A (en) | Method, apparatus, storage medium and the terminal that report imports and exports | |
| CN104050193B (en) | Generate the method for message and realize the data handling system of this method | |
| CN106294128A (en) | A kind of automated testing method deriving report data and device | |
| CN108304322A (en) | A kind of method for testing pressure and terminal device | |
| CN109165102B (en) | Constraint solver distributed scheduling method based on intelligent contracts | |
| CN109492055B (en) | A method of power grid big data warehouse is established based on CIM model | |
| CN107480056A (en) | A kind of method for testing software and device | |
| CN106155822A (en) | A kind of disposal ability appraisal procedure and device | |
| CN104951442A (en) | Method and device for determining result vector | |
| JP5972472B2 (en) | Data processing apparatus, data processing method, and program | |
| CN108564261A (en) | Method, apparatus and computer equipment are determined based on the power information of work ticket | |
| CN101770367A (en) | Compressing method and compressing device of .NET file |
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 |