Method and device for managing time series database

A time series and time management technology, applied in the field of database management, can solve the problem of huge amount of time series data, and achieve the effect of improving storage and query efficiency

Active Publication Date: 2015-04-15
IBM CORP
View PDF7 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

It can be seen that the amount of time series data in a conventional application environment is huge
[0005] In addition, due to different application environments, the operations performed on the collected data may also be different. For example, in addition to inserting the collected data into the database, there are query operations

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
  • Method and device for managing time series database
  • Method and device for managing time series database
  • Method and device for managing time series database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] Preferred embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although preferred 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 to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

[0022] Those skilled in the art know that the present invention can be implemented as a system, method or computer program product. Therefore, the present disclosure can be specifically implemented in the following forms, that is: it can be complete hardware, it can also be complete software (including firmware, resident software, microcode, etc.), and it can also be a combination of hardware and software. Called a "circuit", "module" or "s...

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

A method for managing a time series database, includes: monitoring multiple operations that access the time series database, so as to identify types of the multiple operations, the types of the multiple operations comprising at least one of the query types or insert types; with respect to a storage mode among multiple storage modes, obtaining costs that the multiple operations access the time series database based on the types, respectively; selecting a storage mode with the minimum cost from the multiple storage modes; and during a predetermined time period, storing into the time series database data values that are collected from multiple measurement points according to the selected storage mode. In one embodiment, there is provided an apparatus for managing a time series database. By means of the method and apparatus of the present invention, the storage and query efficiency with respect to the time series database can be increased.

Description

technical field [0001] Various embodiments of the present invention relate to database management, and more particularly, to methods and devices for managing a time series database (Time Series Database). Background technique [0002] With the development of technologies such as computers, data communications, and real-time monitoring, time series databases have been used in many aspects such as equipment monitoring, production line management, and financial analysis. Time series (Time Sequence) refers to a collection of measured values ​​arranged in chronological order. A time-series database refers to the database used to store these measurements. The measured value can include various data. For example, in the application environment of monitoring bridge safety, the collected data can include pressure data collected by a sensor; in the application environment of weather forecast, the collected data can include temperature, humidity, pressure, wind force (for example, in...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/30144G06F17/30091G06F17/30386G06Q10/067G06F17/30365G06F16/13G06F16/1734G06F16/235G06F16/24G06F16/2228G06F16/2474
Inventor 陈垚亮陈晓艳刘凯孙国荣王晨黄胜
Owner IBM CORP
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