CN101976251A - Method for realizing power utilization information acquisition terminal embedded database management model - Google Patents

Method for realizing power utilization information acquisition terminal embedded database management model Download PDF

Info

Publication number
CN101976251A
CN101976251A CN 201010518474 CN201010518474A CN101976251A CN 101976251 A CN101976251 A CN 101976251A CN 201010518474 CN201010518474 CN 201010518474 CN 201010518474 A CN201010518474 A CN 201010518474A CN 101976251 A CN101976251 A CN 101976251A
Authority
CN
China
Prior art keywords
data
database
memory
base administration
hash table
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
Application number
CN 201010518474
Other languages
Chinese (zh)
Other versions
CN101976251B (en
Inventor
蒋晓宇
刘剑欣
刘韶华
贺永胜
成海生
蔡华
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Nanrui Purui Electric Technology Co ltd
Nari Technology Co Ltd
NARI Nanjing Control System Co Ltd
Original Assignee
Nari Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Nari Technology Co Ltd filed Critical Nari Technology Co Ltd
Priority to CN201010518474A priority Critical patent/CN101976251B/en
Publication of CN101976251A publication Critical patent/CN101976251A/en
Application granted granted Critical
Publication of CN101976251B publication Critical patent/CN101976251B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a method for realizing a power utilization information acquisition terminal embedded database management model, which is characterized by comprising the following steps: 1) analyzing an extensive makeup language( XML) configuration table and generating a memory database, a file database and a memory relationship HASH table for describing the relationship between data items and databases; 2) operating the memory database in a mode in which a database management process and an application program serve as a client and the memory database and the memory relationship HASH table serve as a server; and 3) operating the file database by using a C/S architecture in which the application program serves as the client, and the database management process serves as the server. In the invention, the complex work of the application process for operating the databases is avoided, and the reusability in different power utilization information acquisition terminals as well as the transferability and consistency of application software and functional software are guaranteed.

Description

The implementation method of power information acquisition terminal embedded database administrative model
Technical field
The invention belongs to power information acquisition terminal field, be specifically related to a kind of implementation method of the power information acquisition terminal embedded database administrative model based on the C/S framework.
Background technology
The power information acquisition terminal is the equipment that each information gathering point power information is gathered, and is called for short acquisition terminal.Can realize collection, data management, the data double-way transmission of electric energy meter data and the equipment of transmitting or carry out control command.The power information acquisition terminal is divided into types such as special change acquisition terminal, centralized automatic meter-reading terminal (comprising concentrator, collector), distributed energy monitor terminal by application places.
The power information acquisition terminal need be supported the access of the various measurement point devices that quantity is huge, kind is numerous and diverse, definition of data item is different, how effectively to form the data management unified interface of each series terminal product, realize application software, the reusability of functional software, portability, consistance, press for the implementation method of creating a kind of general, unified power information acquisition terminal data base administration model.
Summary of the invention
The objective of the invention is to propose a kind of implementation method of power information acquisition terminal embedded database administrative model, this method can be used for providing unified, configurable Database Management Interface for the various application software of various power information acquisition terminals.
For solving the problems of the technologies described above, the implementation method of a kind of power information acquisition terminal embedded database administrative model provided by the present invention is characterized in that: may further comprise the steps:
1) the analyzing XML allocation list generates the related HASH table with the internal memory of database relation of memory database, document data bank and data of description project;
2) for the operation of memory database, data base administration process and application program all are clients, and the related HASH table with internal memory of memory database can be considered the server end pattern;
3) for the operation of document data bank, adopt the C/S framework to carry out, wherein application program is a client, the data base administration process is a server end;
4) data base administration process is according to the related HASH table of internal memory, on-the-fly modify the related HASH table of internal memory measurement point incidence relation table, measurement point tables of data entity in the Dynamic Maintenance memory database, application process is according to the direct visit of the related HASH table of internal memory realization to memory database;
5) application process is with read-write operation order write operation command queue, after the data base administration process is operated the command messages triggering, according to related HASH table of internal memory and operational order formation content, with the read write command dynamic translation is the database SQL statement, and document data bank operated, operating result returns by the ephemeral data table in the memory database;
6) data base administration process realizes that according to the data item sign in the measurement point internal storage data table entity memory database freezes to the historical data benefit of document data bank;
7) data base administration process is by the power down message mechanism, guarantees that memory database data do not lose.
The implementation method of aforesaid power information acquisition terminal embedded database administrative model, it is characterized in that: in described step 6), be timed freeze task message and trigger after, after the data base administration service processes application operation signal amount, according to the related HASH table of internal memory, detect the sign of each data item in the measurement point internal storage data table entity, the valid data item is added the triggered time stamp and prepares to prestore document data bank, at first detect the identical data that whether has identical time stamp, if exist then abandon depositing in, otherwise write data and remove data item sign in the internal storage data table entity, thereby realize that memory database freezes to the historical data benefit of document data bank.
The implementation method of aforesaid power information acquisition terminal embedded database administrative model, it is characterized in that: in described step 7), after terminal dead electricity message trigger, after the data base administration service processes moves and seizes the operation signal amount, memory database is imported document data bank to be preserved, closing database service, until terminal again.
Beneficial effect of the present invention is: in the present invention, adopt the C/S framework between application process and the data base administration process, the various application processes that are embodied as various power information acquisition terminals provide Database Management Interface a kind of unification, configurable, avoid the miscellaneous work of application process, guarantee application software, reusability, portability, the consistance of functional software in different power information acquisition terminals the data operation.
Description of drawings
Fig. 1 is a data base administration C/S configuration diagram.
Fig. 2 is a database XML allocation list synoptic diagram.
Fig. 3 is the related HASH hoist pennants of internal memory.
Fig. 4 is the process flow diagram of data base administration C/S framework applications process.
Fig. 5 is the initialization flowchart of data base administration C/S framework managing process.
Fig. 6 is the main memory DBM process flow diagram of data base administration C/S framework managing process.
Fig. 7 mends for the data of data base administration C/S framework managing process and freezes process flow diagram.
Fig. 8 is the document data bank operational flowchart of data base administration C/S framework managing process.
Fig. 9 is the anti-loss of data process flow diagram of data base administration C/S framework managing process.
Embodiment
Below in conjunction with Figure of description, the present invention is described in detail, and provide concrete form of implementation.
For the operation of memory database, data base administration process and application program all are client modes, and memory database cooperates the related HASH table of internal memory to can be considered the server end pattern; For the operation of document data bank, adopt the C/S framework to carry out, wherein application program is a client, and the data base administration process is a server end, and application program does not need to understand document data bank and mode of operation thereof.Data base administration C/S framework as shown in Figure 1.
As shown in Figure 2, the XML allocation list has comprised data items table and initialization SQL statement table; Data items comprises data item name and data item attribute, and data item attribute comprises data type, measurement point type and tables of data type; Initialization SQL statement table comprises memory bank initialization statement table and library initialization statement table.
By the analyzing XML allocation list, can create the related HASH table of internal memory of the memory database, document data bank and data of description project and the database relation that are complementary with data items XML allocation list.The related HAHS table with internal memory of memory database all is present among the internal memory, can directly visit by the corresponding interface, and document data bank exists with the database file pattern, must conduct interviews by the data base administration process.The related HASH table of internal memory can be that key word is retrieved with data item, measurement point, table name, as shown in Figure 3.
The data base administration process is according to measurement point parameter, the related HASH table of internal memory, be responsible in memory database, creating the tables of data entity of each measurement point, and from the data table related of document data bank, extract the historical data project, import measurement point internal storage data table, remove each data item " dirty " sign, insert validity flag.The data base administration process is responsible for the operational order formation of initialization files database, creates the exclusive semaphore of document data bank operational order formation, creates the exclusive semaphore of memory database.As shown in Figure 5.
After measurement point parameter modification message trigger, the data base administration service processes dynamically increases, revises, deletes the measurement point tables of data entity in the memory database newly.As shown in Figure 6.
Application process can be by the exclusive semaphore of application memory database, after obtaining the operation power of memory database, according to measurement point parameter, the related HASH table of internal memory each data item of measurement point internal storage data table entity is carried out direct control, operation can influence data item " dirty " sign and validity flag.As shown in Figure 4.
Application process can be by the exclusive semaphore of application documents database manipulation command queue, after the operation power of acquisition document data bank operational order formation, the write data content is write write operation command queue; The data base administration service processes by the write order message trigger after, according to the related HASH table of measurement point parameter, internal memory data content is read and is converted to that SQL writes, the replacement operation statement, write document data bank.Application process can be by the exclusive semaphore of application documents database manipulation command queue, the exclusive semaphore of memory database, after the operation power of acquisition document data bank operational order formation and the operation power of memory database, create interim interaction data table in the memory database application, the read data content is write read operation command queue; The data base administration service processes by the read command message trigger after, according to the related HASH table of measurement point parameter, internal memory the SQL query action statement is read and be converted to data content, the SQL statement Query Result is inserted interim interaction data table after conversion; Application process is obtained the read operation result by detecting interim interaction data table, the interim interaction data table of deletion after operation success or the operation overtime.As Fig. 4 and shown in Figure 8.
After being timed the message trigger of freezing task, the data base administration service processes is by the exclusive semaphore of application documents database manipulation command queue, the exclusive semaphore of memory database, after the operation power of acquisition document data bank operational order formation and the operation power of memory database, detect each data item " dirty " sign and the validity flag of measurement point internal storage data table, to meet the data item that imposes a condition is that timestamp is prestored into document data bank with the timed task triggered time, and whether detection exists the data item of identical time stamp, if exist then do not write, otherwise write freezing data and " dirty " sign that clears data, thereby the history benefit that realizes the measure dot number certificate is frozen.As shown in Figure 7.
After terminal dead electricity message trigger, the moving exclusive semaphore of document data bank operational order formation and the exclusive semaphore of memory database seized of data base administration service processes, internal storage data base content is imported document data bank to be preserved, closing database service also enters dormant state, until terminal again.As shown in Figure 9.
The present invention also can have other various embodiments, without departing from the spirit and substance of the case in the method for the present invention, according to various changes or the distortion that the inventive method is made, all belongs to the claim protection domain of the inventive method.

Claims (3)

1. the implementation method of a power information acquisition terminal embedded database administrative model is characterized in that: may further comprise the steps:
1) the analyzing XML allocation list generates the related HASH table with the internal memory of database relation of memory database, document data bank and data of description project;
2) for the operation of memory database, data base administration process and application program all are clients, and the related HASH table with internal memory of memory database can be considered the server end pattern;
3) for the operation of document data bank, adopt the C/S framework to carry out, wherein application program is a client, the data base administration process is a server end;
4) data base administration process is according to the related HASH table of internal memory, on-the-fly modify the related HASH table of internal memory measurement point incidence relation table, measurement point tables of data entity in the Dynamic Maintenance memory database, application process is according to the direct visit of the related HASH table of internal memory realization to memory database;
5) application process is with read-write operation order write operation command queue, after the data base administration process is operated the command messages triggering, according to related HASH table of internal memory and operational order formation content, with the read write command dynamic translation is the database SQL statement, and document data bank operated, operating result returns by the ephemeral data table in the memory database;
6) data base administration process realizes that according to the data item sign in the measurement point internal storage data table entity memory database freezes to the historical data benefit of document data bank;
7) data base administration process is by the power down message mechanism, guarantees that memory database data do not lose.
2. want the implementation method of 1 described power information acquisition terminal embedded database administrative model according to right, it is characterized in that: in described step 6), be timed freeze task message and trigger after, after the data base administration service processes application operation signal amount, according to the related HASH table of internal memory, detect the sign of each data item in the measurement point internal storage data table entity, the valid data item is added the triggered time stamp and prepares to prestore document data bank, at first detect the identical data that whether has identical time stamp, if exist then abandon depositing in, otherwise write data and remove data item sign in the internal storage data table entity, thereby realize that memory database freezes to the historical data benefit of document data bank.
3. want the implementation method of 1 or 2 described power information acquisition terminal embedded database administrative models according to right, it is characterized in that: in described step 7), after terminal dead electricity message trigger, after the data base administration service processes moves and seizes the operation signal amount, memory database is imported document data bank to be preserved, closing database service, until terminal again.
CN201010518474A 2010-10-26 2010-10-26 Method for realizing power utilization information acquisition terminal embedded database management model Active CN101976251B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201010518474A CN101976251B (en) 2010-10-26 2010-10-26 Method for realizing power utilization information acquisition terminal embedded database management model

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201010518474A CN101976251B (en) 2010-10-26 2010-10-26 Method for realizing power utilization information acquisition terminal embedded database management model

Publications (2)

Publication Number Publication Date
CN101976251A true CN101976251A (en) 2011-02-16
CN101976251B CN101976251B (en) 2012-10-03

Family

ID=43576137

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201010518474A Active CN101976251B (en) 2010-10-26 2010-10-26 Method for realizing power utilization information acquisition terminal embedded database management model

Country Status (1)

Country Link
CN (1) CN101976251B (en)

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103067376A (en) * 2012-12-26 2013-04-24 北京讯鸟软件有限公司 Structured query language (SQL) injection attacking protection method based on internal storage
CN103064950A (en) * 2012-12-27 2013-04-24 北京思特奇信息技术股份有限公司 Database client construction method and database client system
CN103679552A (en) * 2013-12-06 2014-03-26 宁波三星电气股份有限公司 Method for counting power utilization information applied to power consumer power utilization information collection system
CN104252501A (en) * 2013-06-29 2014-12-31 华为技术有限公司 Computing equipment and method for executing database operating command
CN105956166A (en) * 2016-05-19 2016-09-21 北京京东尚科信息技术有限公司 Database reading-writing method and database reading-writing apparatus
CN106874124A (en) * 2017-03-30 2017-06-20 光科技股份有限公司 A kind of object-oriented power information acquisition terminal based on the quick loading techniques of SQLite
CN107633056A (en) * 2017-09-19 2018-01-26 威胜信息技术股份有限公司 Data managing method for power information acquisition terminal
CN108595302A (en) * 2018-04-04 2018-09-28 厦门科灿信息技术有限公司 A kind of data management-control method and system for monitoring system
CN108737890A (en) * 2018-08-21 2018-11-02 深圳Tcl数字技术有限公司 Multi-process channel data switching method, device, television set and storage medium
CN108871428A (en) * 2018-05-09 2018-11-23 南京思达捷信息科技有限公司 A kind of geology monitor supervision platform and its method based on big data
CN111125129A (en) * 2019-12-10 2020-05-08 珠海格力电器股份有限公司 Data processing method and device, storage medium and processor
CN112256697A (en) * 2020-10-14 2021-01-22 宁波三星医疗电气股份有限公司 Method for managing data of power acquisition terminal

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN201104293Y (en) * 2005-10-26 2008-08-20 德阳汇川科技有限公司 Electric power marketing pre-payment managing system based on mobile network
CN101430357A (en) * 2008-12-12 2009-05-13 深圳市科陆电子科技股份有限公司 Energy consumption data acquisition method and system, and energy consumption management terminal
US20100117856A1 (en) * 2008-11-11 2010-05-13 Itron, Inc. System and method of high volume import, validation and estimation of meter data

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN201104293Y (en) * 2005-10-26 2008-08-20 德阳汇川科技有限公司 Electric power marketing pre-payment managing system based on mobile network
US20100117856A1 (en) * 2008-11-11 2010-05-13 Itron, Inc. System and method of high volume import, validation and estimation of meter data
CN101430357A (en) * 2008-12-12 2009-05-13 深圳市科陆电子科技股份有限公司 Energy consumption data acquisition method and system, and energy consumption management terminal

Cited By (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103067376B (en) * 2012-12-26 2017-03-15 北京讯鸟软件有限公司 A kind of SQL injection attacks means of defences based on internal memory
CN103067376A (en) * 2012-12-26 2013-04-24 北京讯鸟软件有限公司 Structured query language (SQL) injection attacking protection method based on internal storage
CN103064950A (en) * 2012-12-27 2013-04-24 北京思特奇信息技术股份有限公司 Database client construction method and database client system
CN103064950B (en) * 2012-12-27 2016-09-14 北京思特奇信息技术股份有限公司 A kind of database client construction method and system
CN104252501A (en) * 2013-06-29 2014-12-31 华为技术有限公司 Computing equipment and method for executing database operating command
CN104252501B (en) * 2013-06-29 2018-08-21 华为技术有限公司 A kind of computing device and method executing database manipulation order
CN103679552A (en) * 2013-12-06 2014-03-26 宁波三星电气股份有限公司 Method for counting power utilization information applied to power consumer power utilization information collection system
CN105956166A (en) * 2016-05-19 2016-09-21 北京京东尚科信息技术有限公司 Database reading-writing method and database reading-writing apparatus
CN106874124B (en) * 2017-03-30 2023-04-14 光一科技股份有限公司 SQLite rapid loading technology-based object-oriented electricity utilization information acquisition terminal
CN106874124A (en) * 2017-03-30 2017-06-20 光科技股份有限公司 A kind of object-oriented power information acquisition terminal based on the quick loading techniques of SQLite
CN107633056A (en) * 2017-09-19 2018-01-26 威胜信息技术股份有限公司 Data managing method for power information acquisition terminal
CN108595302A (en) * 2018-04-04 2018-09-28 厦门科灿信息技术有限公司 A kind of data management-control method and system for monitoring system
CN108871428A (en) * 2018-05-09 2018-11-23 南京思达捷信息科技有限公司 A kind of geology monitor supervision platform and its method based on big data
CN108737890A (en) * 2018-08-21 2018-11-02 深圳Tcl数字技术有限公司 Multi-process channel data switching method, device, television set and storage medium
CN111125129A (en) * 2019-12-10 2020-05-08 珠海格力电器股份有限公司 Data processing method and device, storage medium and processor
CN112256697A (en) * 2020-10-14 2021-01-22 宁波三星医疗电气股份有限公司 Method for managing data of power acquisition terminal

Also Published As

Publication number Publication date
CN101976251B (en) 2012-10-03

Similar Documents

Publication Publication Date Title
CN101976251B (en) Method for realizing power utilization information acquisition terminal embedded database management model
CN102685221B (en) Distributed storage and parallel mining method for state monitoring data
CN102609417B (en) Engine device and method for data integration and exchange of building information mode based on IFC (industry foundation classes) standards
CN111432295A (en) Power consumption information acquisition master station system based on distributed technology
CN102508908B (en) Method for acquiring subordinate financial business data and system for acquiring subordinate financial business data
CN102855271B (en) The storage of a kind of multi-version power grid model and traceable management method
CN106951552A (en) A kind of user behavior data processing method based on Hadoop
CN111405032A (en) General cloud platform of industry thing networking
CN102508886B (en) Extensive makeup language (XML)-based method for synchronously updating increment of spatial data
CN102013056A (en) Configurable power report management system and operating method thereof
CN105205185B (en) The method of data interaction and data modeling between monitoring system and management information system
CN104361457A (en) Information modeling method for production overhaul management of power distribution network and information interactive system and method
CN108846072A (en) A kind of data realization encapsulation technology based on visual analyzing
CN107330017A (en) A kind of electric power mass data storage and query and statistical analysis method and its system based on subject example
CN115934856A (en) Method and system for constructing comprehensive energy data assets
CN108876445A (en) A kind of data interoperation application based on battalion's distribution end-equipment common information model
CN117194156A (en) Unified monitoring operation and maintenance management method and system for multi-cloud platform
CN107633056A (en) Data managing method for power information acquisition terminal
CN114257593A (en) Communication method, device, equipment and storage medium of block chain system
Huang et al. Research on key technologies of electricity trading platform of next generation
CN206193922U (en) Data management platform system
CN106096824A (en) A kind of main distribution integrative graph resource share method
CN105677853A (en) Data storage method and device based on big data technology framework
CN104933106A (en) Database device for IFC informatization model
Wang et al. SOA based electric power real-time data warehouse

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
ASS Succession or assignment of patent right

Owner name: NARI NANJING CONTROL SYSTEM LTD.

Effective date: 20141202

C41 Transfer of patent application or patent right or utility model
TR01 Transfer of patent right

Effective date of registration: 20141202

Address after: High road high tech Development Zone Nanjing city Jiangsu province 210061 No. 20

Patentee after: NARI TECHNOLOGY Co.,Ltd.

Patentee after: NARI NANJING CONTROL SYSTEM Co.,Ltd.

Address before: High road high tech Development Zone Nanjing city Jiangsu province 210061 No. 20

Patentee before: NARI TECHNOLOGY Co.,Ltd.

TR01 Transfer of patent right

Effective date of registration: 20230104

Address after: 211100 Building 2, 19 Chengxin Avenue, Jiangning Economic and Technological Development Zone, Nanjing, Jiangsu Province

Patentee after: NARI TECHNOLOGY Co.,Ltd.

Patentee after: NARI NANJING CONTROL SYSTEM Co.,Ltd.

Patentee after: BEIJING STATE GRID PURUI EXTRA-HIGH VOLTAGE POWER TRANSMISSION TECHNOLOGY Co.,Ltd.

Address before: High road high tech Development Zone Nanjing city Jiangsu province 210061 No. 20

Patentee before: NARI TECHNOLOGY Co.,Ltd.

Patentee before: NARI NANJING CONTROL SYSTEM Co.,Ltd.

TR01 Transfer of patent right
CP03 Change of name, title or address

Address after: 211100 Building 2, 19 Chengxin Avenue, Jiangning Economic and Technological Development Zone, Nanjing, Jiangsu Province

Patentee after: NARI TECHNOLOGY Co.,Ltd.

Country or region after: China

Patentee after: NARI NANJING CONTROL SYSTEM Co.,Ltd.

Patentee after: Beijing Nanrui Purui Electric Technology Co.,Ltd.

Address before: 211100 Building 2, 19 Chengxin Avenue, Jiangning Economic and Technological Development Zone, Nanjing, Jiangsu Province

Patentee before: NARI TECHNOLOGY Co.,Ltd.

Country or region before: China

Patentee before: NARI NANJING CONTROL SYSTEM Co.,Ltd.

Patentee before: BEIJING STATE GRID PURUI EXTRA-HIGH VOLTAGE POWER TRANSMISSION TECHNOLOGY Co.,Ltd.