CN110008213A - A kind of regulator control system real time data separate type management method - Google Patents
A kind of regulator control system real time data separate type management method Download PDFInfo
- Publication number
- CN110008213A CN110008213A CN201910188640.2A CN201910188640A CN110008213A CN 110008213 A CN110008213 A CN 110008213A CN 201910188640 A CN201910188640 A CN 201910188640A CN 110008213 A CN110008213 A CN 110008213A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- different
- storage medium
- control 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.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of regulator control system real time data separate type management methods to determine the data use of each field of two-dimensional data table according to the metadata definition of database；Created according to different data uses includes the storage medium cached in memory database, disk database and process；The different field data of two-dimensional data table are loaded into corresponding storage medium according to data use, and the data-interface by providing carries out Uniform Access access to the data of different medium.Management method of the present invention enables the data in database to be split to different storage mediums according to different requirements for access to be stored；The different storage medium of database uniformly can access and manage.
Description
Technical field
The invention belongs to Automation of Electric Systems electric network model administrative skill field more particularly to a kind of regulator control system are real-time
Data separating formula management method.
Background technique
As grid operation mode is increasingly sophisticated, the power dispatch system operation and management of power grid is faced with new challenges, and pacifies to as power grid
More stringent requirements are proposed for the electric network model and parameter on full stable operation basis.The database of single storage medium is difficult to meet number
According to the requirement of different access frequency and access throughput, and simple multiple database results in upper layer application in data user
The complication in face.
Existing regulator control system real time data is uniformly stored in single storage medium, i.e., stores all data single
In database.But stored using centralized database, it is easy to produce data hot spot, influences data storage access efficiency.
Summary of the invention
Goal of the invention: it in view of the above problems, the present invention proposes a kind of regulator control system real time data separate type management method, uses
It in the separation storage of different medium and is managed in realization database.
Technical solution: to achieve the purpose of the present invention, the technical scheme adopted by the invention is that: a kind of regulator control system is real-time
Data separating formula management method, comprising steps of
(1) according to the metadata definition of database, the data use of each field of two-dimensional data table is determined；
(2) being created according to different data uses includes the storage cached in memory database, disk database and process
Medium；
(3) the different field data of two-dimensional data table are loaded into corresponding storage medium according to data use, and passed through
The data-interface of offer carries out Uniform Access access to the data of different medium.
Further, in the step (1), in the metadata, each field of database table has an attribute, label
Its storage medium is memory database, disk database or memory cache.
Further, it in the step (2), in database creation, according to metadata, is created in different storage mediums
Build corresponding storage organization；When creating table, different storage mediums is created to according to metadata simultaneously.
Further, in the step (3), all DDL and DML processing require the field category according to metadata definition
Property, it goes to corresponding storage medium and is operated.
Further, the storage media different to database accesses, comprising steps of
(1) metadata definition is obtained；
(2) SQL-DML sentence is parsed, operation field information is obtained；
(3) different operation field is obtained, operation field is converted into the operation of multiple storage mediums；
(4) Xiang Butong storage medium operation data.
The utility model has the advantages that management method of the present invention enables the data in database to be split to not according to different requirements for access
Same storage medium is stored；The different storage medium of database uniformly can access and manage.
Detailed description of the invention
Fig. 1 is regulator control system real time data separate type management method flow chart of the present invention；
Fig. 2 is that the different storage medium of database accesses and management flow chart.
Specific embodiment
Further description of the technical solution of the present invention with reference to the accompanying drawings and examples.
As depicted in figs. 1 and 2, regulator control system real time data separate type management method of the present invention, to regulator control system
Used in real time data according to the heterogeneity and usage mode of data, take different modes to be stored and unite
One management and the unified access of offer, comprising steps of
(1) according to the metadata definition of database, the data use of each field of two-dimensional data table is determined；
(2) being created according to different data uses includes the storage cached in memory database, disk database and process
Medium；
(3) the different field data of tables of data are loaded into corresponding storage medium, and the number by providing depending on the application
Uniform Access access is carried out according to data of the interface to different medium.
As shown in Fig. 2, the different storage medium of database is accessed and is managed, comprising steps of
(1) metadata definition is obtained；
(2) SQL-DML sentence is parsed, operation field information is obtained；
(3) different operation field is obtained, operation field is converted into the operation of multiple storage mediums；
(4) Xiang Butong storage medium operation data.
According to the metadata definition of database, the data use of each field of two-dimensional data table is determined, comprising: in first number
In, have an attribute to each field of database table, marking its storage medium is memory database, disk database or
Person's memory cache.
The different field data of tables of data are loaded into corresponding storage medium depending on the application, comprising: create in database
When, according to metadata, corresponding storage organization is created in different storage mediums；When creating table, simultaneously according to metadata
It is created to different storage mediums.
Carry out Uniform Access access by the data of the data-interface of offer to different medium, comprising: all DDL and
DML processing requires the field attribute according to metadata definition, goes to corresponding storage medium and is operated.
Further details of introduction is made to the present invention below in conjunction with specific embodiment.
In the present invention, to a tables of data, the metadata of definition can should include the table structure information of database, and
Have the attribute of storage medium in field attribute, includes 10 Property IDs for tables of data X, dev_name, owner,
Location, description, p, q, i, v and rdf_id.The corresponding storage medium of different fields see the table below.
Table 1
| Serial number | Field name | Storage medium |
| 1 | ID | All |
| 2 | dev_name | Relational database |
| 3 | owner | Memory database |
| 4 | location | Relational database |
| 5 | description | Relational database |
| 6 | p | Memory cache |
| 7 | q | Memory cache |
| 8 | i | Memory cache |
| 9 | v | Memory cache |
| 10 | rdf_id | Relational database |
In the present invention, in database table creation, different data storage medium storage contents is created, such as above-mentioned Table X,
Relationship can be created in relational database store ID, dev_name, location, description and rdf_id, it can be in memory
Memory storage owner is created in database, and the storage organization of p, q, i and v are created in memory cache.
In the present invention, when database accesses, can according to metadata by DML statement decompose different storage mediums into
Row processing.
Data separating formula management method of the present invention is to combine work on the database of the independent development of application layer
It realizes, independent of specific operating system, is suitable for various operating systems.
It is of the present invention mostly to ensure that portability using the real-time data base data method of synchronization, it can be with real-time database
System safely and steadly operates in the operation such as IBM AIX, Sun Solaris, Alpha Tru64, HPUX, Linux, Windows
In system platform；System programming language uses ANSIC/C++, and meets IEEE POSIX.2 standard.
Claims (5)
1. a kind of regulator control system real time data separate type management method, which is characterized in that comprising steps of
(1) according to the metadata definition of database, the data use of each field of two-dimensional data table is determined；
(2) being created according to different data uses includes the storage medium cached in memory database, disk database and process；
(3) the different field data of two-dimensional data table are loaded into corresponding storage medium according to data use, and offer is provided
Data-interface Uniform Access access is carried out to the data of different medium.
2. regulator control system real time data separate type management method according to claim 1, which is characterized in that the step
(1) in, in the metadata, each field of database table has an attribute, and marking its storage medium is memory database, magnetic
Disk database or memory cache.
3. regulator control system real time data separate type management method according to claim 1, which is characterized in that the step
(2) in, in database creation, according to metadata, corresponding storage organization is created in different storage mediums；In creation table
When, different storage mediums is created to according to metadata simultaneously.
4. regulator control system real time data separate type management method according to claim 1, which is characterized in that the step
(3) in, all DDL and DML processing require the field attribute according to metadata definition, go to corresponding storage medium and carry out
Operation.
5. regulator control system real time data separate type management method according to claim 4, which is characterized in that not to database
Same storage media accesses, comprising steps of
(1) metadata definition is obtained；
(2) SQL-DML sentence is parsed, operation field information is obtained；
(3) different operation field is obtained, operation field is converted into the operation of multiple storage mediums；
(4) Xiang Butong storage medium operation data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910188640.2A CN110008213A (en) | 2019-03-13 | 2019-03-13 | A kind of regulator control system real time data separate type management method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910188640.2A CN110008213A (en) | 2019-03-13 | 2019-03-13 | A kind of regulator control system real time data separate type management method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110008213A true CN110008213A (en) | 2019-07-12 |
Family
ID=67166932
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910188640.2A Pending CN110008213A (en) | 2019-03-13 | 2019-03-13 | A kind of regulator control system real time data separate type management method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110008213A (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101901250A (en) * | 2010-06-08 | 2010-12-01 | 中兴通讯股份有限公司 | Memory database and data processing method thereof |
| CN101923569A (en) * | 2010-07-09 | 2010-12-22 | 南京朗坤软件有限公司 | Storage method of structure type data of real-time database |
| US7895244B1 (en) * | 2006-02-14 | 2011-02-22 | Network Appliance, Inc. | Method and apparatus to utilize free cache in a storage system |
| CN102902628A (en) * | 2012-09-18 | 2013-01-30 | 记忆科技(深圳)有限公司 | Flash memory and method and system for automatically separating cold and hot data based on same |
| CN102945251A (en) * | 2012-10-12 | 2013-02-27 | 浪潮电子信息产业股份有限公司 | Method for optimizing performance of disk database by memory database technology |
| CN103488581A (en) * | 2013-09-04 | 2014-01-01 | 用友软件股份有限公司 | Data caching system and data caching method |
| CN106202566A (en) * | 2016-08-02 | 2016-12-07 | 山东鲁能软件技术有限公司 | A kind of magnanimity electricity consumption data mixing based on big data storage system and method |
| CN106980672A (en) * | 2017-03-28 | 2017-07-25 | 中国电子科技集团公司第二十九研究所 | The data-storage system and method for a kind of isomerous environment Based on Object-Oriented Technology |
| CN107895017A (en) * | 2017-11-14 | 2018-04-10 | 国网江苏省电力公司电力科学研究院 | A kind of electric energy quality monitoring system construction method based on big data technology |
-
2019
- 2019-03-13 CN CN201910188640.2A patent/CN110008213A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7895244B1 (en) * | 2006-02-14 | 2011-02-22 | Network Appliance, Inc. | Method and apparatus to utilize free cache in a storage system |
| CN101901250A (en) * | 2010-06-08 | 2010-12-01 | 中兴通讯股份有限公司 | Memory database and data processing method thereof |
| CN101923569A (en) * | 2010-07-09 | 2010-12-22 | 南京朗坤软件有限公司 | Storage method of structure type data of real-time database |
| CN102902628A (en) * | 2012-09-18 | 2013-01-30 | 记忆科技(深圳)有限公司 | Flash memory and method and system for automatically separating cold and hot data based on same |
| CN102945251A (en) * | 2012-10-12 | 2013-02-27 | 浪潮电子信息产业股份有限公司 | Method for optimizing performance of disk database by memory database technology |
| CN103488581A (en) * | 2013-09-04 | 2014-01-01 | 用友软件股份有限公司 | Data caching system and data caching method |
| CN106202566A (en) * | 2016-08-02 | 2016-12-07 | 山东鲁能软件技术有限公司 | A kind of magnanimity electricity consumption data mixing based on big data storage system and method |
| CN106980672A (en) * | 2017-03-28 | 2017-07-25 | 中国电子科技集团公司第二十九研究所 | The data-storage system and method for a kind of isomerous environment Based on Object-Oriented Technology |
| CN107895017A (en) * | 2017-11-14 | 2018-04-10 | 国网江苏省电力公司电力科学研究院 | A kind of electric energy quality monitoring system construction method based on big data technology |
Non-Patent Citations (2)
| Title |
|---|
| YF.Z: "横向和纵向的数据库分表", 《CSDN》 * |
| 科普中国科学百科词条编写与应用: "《百度百科》", 3 July 2018, 百度 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103218402B (en) | General database data structure and data mover system and method thereof | |
| CN101789045B (en) | Realization method of MDA modeling tool orienting to manufacturing field | |
| CN103593422A (en) | Virtual access management method of heterogeneous database | |
| CN104317864B (en) | A method of the information model automatic identification based on IEC61850 logical nodes | |
| CN103577440A (en) | Data processing method and device in non-relational database | |
| CN101770518A (en) | Metadata management method of power grid enterprise integrated information die | |
| CN104536965B (en) | A kind of data query display systems under the conditions of big data and method | |
| CN103699638A (en) | Method for realizing cross-database type synchronous data based on configuration parameters | |
| CN109522312A (en) | A kind of data processing method, device, server and storage medium | |
| CN109871470B (en) | Power grid equipment data labeling management system and implementation method | |
| CN102262758A (en) | Method for unified modeling and management of space-time multidimensional power grid model based on CIME (certified internet marketing engineer) file | |
| CN111159365A (en) | Method, system and storage medium for implementing intelligent question-answering system of scheduling model body | |
| CN102521332A (en) | Graphic mode matching method, device and system based on strong simulation | |
| CN103606032B (en) | A kind of method in two dimension power grid GIS data set | |
| CN112632025A (en) | Power grid enterprise management decision support application system based on PAAS platform | |
| CN107451222A (en) | Model data management system | |
| CN110069392A (en) | A kind of acquisition methods reflecting data center's information technoloy equipment efficiency feature | |
| CN104391949B (en) | A kind of wide-area data method for managing resource based on data dictionary | |
| CN110008213A (en) | A kind of regulator control system real time data separate type management method | |
| CN103345485B (en) | A kind of mainframe platform dynamic statement automatic generation method and system | |
| CN102968666B (en) | Storage definition method for electric power system data holographic complete time domain management | |
| CN115509693A (en) | Data optimization method based on cluster Pod scheduling combined with data lake | |
| CN103092841B (en) | A kind of data processing method and device | |
| Liu et al. | Research on middle platform construction and large data analysis of power enterprises based on Aliyun | |
| CN108090151A (en) | Spatial data accessing method and storage medium based on multi-data source |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190712 |
|
| RJ01 | Rejection of invention patent application after publication |