Supercharge Your Innovation With Domain-Expert AI Agents!

Time series database data interaction method and system based on container and hierarchical model

A hierarchical model and database technology, applied in database management systems, database models, database indexes, etc., can solve problems such as low efficiency, error-prone, and complex, and achieve the effect of improving access efficiency and efficiency

Active Publication Date: 2020-10-09
NR ELECTRIC CO LTD +1
View PDF1 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, the method of obtaining time series data in the application of power dispatching automation system is to first obtain the measurement point information of the power monitoring object through the business model library, and then use the ID of the measurement point to a conversion table to find the time series database point number corresponding to the measurement point , and finally access the time series database to obtain data through the time series database point number. This process involves three steps: model library access, ID mapping conversion, and time series database access. The efficiency is low, and the intermediate links are complex and error-prone. Therefore, there is an urgent need for a An interface capable of one-time access to solve time-series data 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
  • Time series database data interaction method and system based on container and hierarchical model
  • Time series database data interaction method and system based on container and hierarchical model
  • Time series database data interaction method and system based on container and hierarchical model

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0062] This embodiment introduces a time series database data interaction method, refer to figure 1 As shown, the methods include:

[0063] Obtain the data update status information of the business model library, and in response to a data update event in the business model library, obtain the updated business model information, and update to the preset hierarchical model cache; the hierarchical model cache records the time of each measurement point Sequence database point number;

[0064] In response to receiving the time series data access request message, analyze the message to obtain the access target measuring point information;

[0065] According to the access target measurement point information, obtain or obtain the time series database point number of each access target measurement point from the hierarchical model cache;

[0066] In response to the fact that the access target measurement point is a single measurement point, determine a corresponding unilateral point...

Embodiment 1-1

[0073] This embodiment specifically introduces an implementation manner of Embodiment 1.

[0074] Method of the present invention mainly relates to the following aspects:

[0075] 1. Model version and hierarchical model cache management and maintenance

[0076] In order to simplify the access complexity, the present invention realizes the management and maintenance of the model version and the measurement point record object in the hierarchical model cache through incremental modification.

[0077] The method of this embodiment also includes: saving the acquired updated business model as the latest version model to a preset model version library;

[0078] The acquisition of data update status information of the business model library includes receiving external business model change notification information;

[0079] Updating the updated business model information to the preset hierarchical model cache includes:

[0080] Obtain the latest version model information in the pr...

example 2

[0121] Determine the time-series database instance corresponding to the measurement point according to the time-series database point number of the measurement point and the preset point number management range of each time-series database instance; the point number management range of the time-series database instance is set when the time-series database instance is registered, It is a point number interval, for example, 10,000 points with a point number from 0-9999 are interacted by time-series database instance 1; measuring points with point numbers 10000-19999 are interacted by time-series database instance 2;

[0122] For each time series database instance, summarize the single-point access request queue corresponding to each measurement point within its management scope;

[0123] According to the preset sequential access queue length, the aggregated access request queue is divided into at least one access request queue that can be executed in parallel, and the queue lengt...

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 discloses a time series database data interaction method and system based on a container and a hierarchical model. The method comprises the following steps: a hierarchical model of a power monitoring object is managed and maintained and a measuring point is associated with a model object; the point number of the time sequence database accessing the target measuring point is queried by searching the hierarchical model cache for the external access request, and then access operation is performed on the corresponding time series database according to the point number, so that the complexity of accessing the time sequence database by the application is simplified; for multi-measuring-point access requests, the multi-measuring-point access requests are divided into access requestqueues corresponding to single time sequence database instances through the container technology, the access request queues are distributed to different containers to run in parallel, and elastic extension of access processing capacity is achieved. According to the invention, the access efficiency can be greatly improved.

Description

technical field [0001] The invention relates to the technical field of time-series database access in an electric power dispatching automation system, in particular to a time-series database data interaction method and system based on a container and a hierarchical model. Background technique [0002] At present, the method of obtaining time series data in the application of power dispatching automation system is to first obtain the measurement point information of the power monitoring object through the business model library, and then use the ID of the measurement point to a conversion table to find the time series database point number corresponding to the measurement point , and finally access the time series database to obtain data through the time series database point number. This process involves three steps: model library access, ID mapping conversion, and time series database access. The efficiency is low, and the intermediate links are complex and error-prone. Ther...

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): G06F16/22G06F16/2455G06F16/2458G06F16/25G06F16/28G06Q50/06
CPCG06F16/2228G06F16/2474G06F16/252G06F16/28G06F16/24552G06Q50/06
Inventor 孙超艾文凯吕志强徐丹
Owner NR ELECTRIC CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com