Adaptive database partition method and system for industrial time series database

A database and self-adaptive technology, applied in the field of database processing, to achieve the effect of standardizing queries and avoiding overall performance

Active Publication Date: 2021-03-12
北京工业大数据创新中心有限公司
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, at present, many data management systems have partition functions, but only basic partition creation, addition, and deletion functions, and there is no method for adaptively creating and maintaining partitions according to the characteristics of industrial time series data (such as frequency, etc.)

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
  • Adaptive database partition method and system for industrial time series database
  • Adaptive database partition method and system for industrial time series database
  • Adaptive database partition method and system for industrial time series database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0025] Those skilled in the art can understand that, unless otherwise defined, all terms (including technical terms and scientific terms) used herein have the same meaning as commonly understood by those of ordinary skill in the art to which this invention belongs. It should also be understood that terms, such as those defined in commonly used dictionaries, should be understood to have meanings consistent with the meanings in the co...

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 provides an industrial time series database-oriented adaptive database partitioning method and system. The method comprises the steps of receiving a data definition operation request byutilizing a partitioning parameter analysis module and extracting partitioning parameters in the data definition operation request; and searching for pre-stored partitioning parameters according to analyzed partitioning parameters by utilizing a storage sub-library establishment module, and comparing the analyzed partitioning parameters with the pre-stored partitioning parameters, and when the analyzed partitioning parameters are inconsistent with the pre-stored partitioning parameters, newly creating a partitioning parameter and scheme storage sub-library in an industrial time series databaseaccording to the analyzed partitioning parameters. According to the method and the system, the partitioning parameter and scheme storage sub-library is updated in real time, so that the problem thatthe stored data possibly does not correspond to partitions is solved, and effective and standard partitions are provided for the database of a user.

Description

technical field [0001] The invention relates to the technical field of database processing, in particular to an adaptive database partition system method and system for industrial time series databases. Background technique [0002] 7 * 24 hours of continuous access to industrial time-series massive data, it is necessary to improve the rationality of data organization and the efficiency of data access by partitioning the data. Industrial time-series databases have their own unique properties, such as frequency, device version upgrades, etc. It is necessary to create a unique partition method and system for industrial time-series databases based on these unique properties, providing partition parameter generation, storage and access functions, in order to Maintain the rationality and efficiency of industrial time series data partitioning. [0003] However, at present, many data management systems have partition functions, but they only have basic partition creation, addition...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22G06F16/23G06F16/2458
CPCG06F16/22G06F16/2329G06F16/2462
Inventor 李佳宁张硕王增龙王晨
Owner 北京工业大数据创新中心有限公司
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