Time series data storage query method and device, server and storage medium

A time series data and data storage technology, applied in the database field, can solve the problem of low compression rate, achieve the effect of improving compression efficiency, improving query efficiency, and saving storage resources

Pending Publication Date: 2020-04-28
ENVISION DIGITAL INT PTE LTD +1
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, the time-series database in the related art stores all data indiscriminately, cannot pr

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
  • Time series data storage query method and device, server and storage medium
  • Time series data storage query method and device, server and storage medium
  • Time series data storage query method and device, server and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0029] In order to make the objectives, technical solutions, and advantages of the present application clearer, the following will further describe the embodiments of the present application in detail with reference to the accompanying drawings.

[0030] The "plurality" mentioned herein means two or more. "And / or" describes the association relationship of the associated object, indicating that there can be three types of relationships, for example, A and / or B, which can mean: A alone exists, A and B exist at the same time, and B exists alone. The character " / " generally indicates that the associated objects are in an "or" relationship.

[0031] In related technologies, time-series database software is usually used for the storage of time-series data. For data to be stored with different indicators sent by different IoT devices, the database server stores it in the corresponding data storage table, but all data uses the time-series database software default The compression metho

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 embodiment of the invention discloses a time series data storage query method and device, a server and a storage medium, and belongs to the field of databases. The method comprises the steps of determining a data type of to-be-stored data; compressing the to-be-stored data according to a data compression mode corresponding to the data type; storing the compressed data into a data storage tablecorresponding to the data type; receiving a query request, wherein the query request comprises a query data type and a query time condition; and querying the target data meeting the query time condition from the data storage table corresponding to the query data type. In the embodiment of the invention, different compression modes are adopted for different types of data, so that the compression efficiency of the time series data is improved, and storage resources are saved; moreover, during data query, the time series data meeting the query time condition is searched from the data storage table corresponding to the query data type according to the query data type, so that the query efficiency of different types of time series data is improved.

Description

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

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
Owner ENVISION DIGITAL INT PTE 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