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

Mode conversion method and device for time series database

A technology of time series and mode conversion, applied in database design/maintenance, structured data retrieval, special data processing applications, etc., can solve problems such as error-prone and time-consuming mode conversion

Active Publication Date: 2020-06-23
时来智启(上海)科技有限公司 +1
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0011] In order to overcome the problem of laborious and error-prone mode conversion of the data in the time series database in the existing manual way, or at least partially solve the above problems, the embodiment of the present invention provides a mode conversion method and device for the time series database

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
  • Mode conversion method and device for time series database
  • Mode conversion method and device for time series database
  • Mode conversion method and device for time series database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description These are some embodiments of the present invention. Those skilled in the art can also obtain other drawings based on these drawings without creative work.

[0029] Before the embodiment of the present invention, the inventive idea of ​​the present invention is firstly introduced.

[0030] Let S be the time series based on metrics and labeled data patterns MT , the time series based on the path data pattern is S p , a set of several time series Among them, TS i represents the i-th time series, Represents an integer, and N represents the total number of time series in the collection.

[0031] For different data modes, TS i are expressed differently. In ...

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 mode conversion method and device for a time sequence database. The method comprises the steps that a time sequence based on a measurement and label data mode is converted into a two-tuple, wherein the two-tuples comprise measurement names in a time sequence and one or more labels, and each label comprises a label field and a label value of the label field; if the measurement name exists in a pre-created double-layer mapping table, obtaining a sub-mapping table corresponding to the measurement name from the double-layer mapping table; and if the path positions of all the label fields of the two-tuples in the sub-mapping table in the path data mode are not null, creating a path, adding the label values of the label fields corresponding to the path positions to the corresponding path positions in the path, and adding a measurement name to the last position of the path. According to the invention, conversion from a measurement and label data mode to a path data mode is realized, and the resource overhead is low.

Description

technical field [0001] The invention belongs to the technical field of computer data management, and in particular relates to a time series database mode conversion method and device. Background technique [0002] As a NoSQL (Not Only Structured Query Language) database, time series databases have been widely used in industrial production, medical care, finance and other fields. By using a time-series database, users can conveniently and efficiently store and retrieve time-series data from various equipment sensors. [0003] There are differences in how time series schemas are managed by different time series database software products. At present, there are many time series databases in the international market, and there are mainly two ways for these databases to uniquely identify a time series. One is the identification method based on metrics (Metric) and tags (Tags), such as the data schema of database systems such as InfluxDB and KairosDB, using this method; the othe...

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/21
CPCG06F16/211
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