Data fragmentation method for fragmentation real-time database of energy management system

An energy management system and data sharding technology, applied in the real-time database technology application field, can solve the problems of reduced data access performance and excessive number of records in a single table, and achieve the effect of reducing the amount of data and providing data consistency

Inactive Publication Date: 2015-01-21
NARI TECH CO LTD +4
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In a real-time database, if the number of records in a single table is too large, the performance of data access will be greatly reduced

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data fragmentation method for fragmentation real-time database of energy management system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0013] Below in conjunction with the accompanying drawings and specific embodiments, the present invention will be further clarified. It should be understood that these embodiments are only used to illustrate the present invention and not to limit the scope of the present invention. Modifications of equivalent forms all fall within the scope defined by the appended claims of this application.

[0014] see figure 1 As shown, the present invention firstly adds a grouping number field to all the plant data in the database, the field is an integer value, and is used to represent the data grouping corresponding to each plant data.

[0015] All plant data is divided into different groups according to requirements, the number of the group to which it belongs is written into the grouping number field of the database, and the work of plant grouping has been completed.

[0016] For all device data that needs to be fragmented, according to the value of the attribute field of the device ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a data fragmentation method for a fragmentation real-time database of an energy management system. Data fragmentation is conducted on the real-time database according to the specific plant station-device relevance of the energy management system, and consistency of fragmentation information can be improved. The data fragmentation method comprises the steps that 1 plant station data in the real-time database are grouped; 2 all data tables required to be fragmented contain information of plant stations according to the requirement for plant station-device relevance, and database tables relevant with devices contain plant station identifiers serving as external keys; 3 the data of the data tables required to be fragmented are fragmented in a plant station grouping mode, namely the device data of the same plant station belong to the same fragmentation, and the device data belonging to the same group belong to the same fragmentation.

Description

technical field [0001] The invention relates to the application field of real-time database technology. Background technique [0002] In a real-time database, if the number of records in a single table is too large, the data access performance will be greatly reduced. SUMMARY OF THE INVENTION [0003] The purpose of the present invention is to provide a data sharding method for sharding a real-time database of an energy management system in view of the deficiencies in the prior art, which improves the consistency of sharding information on the premise of ensuring sharding retrieval performance. [0004] In order to achieve the above purpose, the data fragmentation method of the energy management system fragmentation real-time database of the present invention can adopt the following technical solutions: [0005] A data sharding method for sharding a real-time database of an energy management system, which shards the data of the real-time database according to the unique p...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30G06Q10/06
CPCG06F16/27G06Q10/0631
Inventor 彭晖徐展强吴庆曦王瑾靳晶魏娜曾坚永刘洋邓大为赵瑞锋
Owner NARI TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap