Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Time series data storage method and device, and time series data query method and device

A time series and query method technology, applied in the computer field, can solve the problems of not supporting column type changes, time series data type changes, and IoT platform not supporting sensor data field type changes well, so as to avoid data loss Effect

Active Publication Date: 2022-02-15
树根互联股份有限公司
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This type of time series database organizes data according to columns, but these time series databases generally do not support column type changes
The business requirement that the IoT platform cannot support the change of the field type of the sensor data well
[0004] Therefore, the existing time series data storage and query methods have the technical problem of not being able to support the type change of time series data

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention.

[0057] The components of the embodiments of the invention generally described and illustrated in the figures herein may be arranged and designed in a variety of different configurations. Accordingly, the following detailed description of the embodiments of the invention provided in the accompanying drawings is not intended to limit the scope of the claimed invention, but merely represents selected embodiments of the invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without making creative efforts belong to the protection scope of the present invention.

[0058] Hereinafter, the terms "comprising",...

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 a time series data storage method and device, and a time series data query method and device. The query method comprises the following steps: receiving data of to-be-stored time series data; judging the data type of the time sequence data according to the character features corresponding to the time sequence data; based on the working condition fields and the data type of the time sequence data, establishing a mapping relation between the working condition fields and a first type of column type storage unit of the time sequence database; based on the mapping relationship, storing each working condition data to the corresponding first-class column type storage unit, and according to a pre-established name corresponding relationship between the non-working condition field and the second-class column type storage unit, storing the non-working condition data to the second-class column type storage unit; and associating the working condition data in the same time sequence data with the non-working condition data in the time sequence database. The method does not depend on a time sequence database of a bottom layer, the storage unit to be written is determined according to the time sequence data, and data loss caused by equipment model evolution is avoided.

Description

technical field [0001] The present application relates to the field of computer technology, and in particular to a storage method, query method and device for time series data. Background technique [0002] The data generated by IoT devices usually has time-series characteristics, that is, time-series data, and there are various types of IoT devices, and the type of time-series data that each type of device can process may be different. Therefore, when replacing a device, if the data type of the new device is different from the type of data stored in the replaced device, it is necessary to change the field type of the data, and the data stored in the original device is different from that of the replaced device. The data uploaded by the device needs to be coherent. In addition, the model of the Internet of Things device also has a gradual evolution and maturity process. The definition of the device model will be continuously revised, including the change of the type of the ...

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): G06F16/2455G06F16/25
CPCG06F16/24568G06F16/25
Inventor 陈晓艳徐晓旻焦丽梅陈垚亮黄胜
Owner 树根互联股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products