Supercharge Your Innovation With Domain-Expert AI Agents!

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

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

Active Publication Date: 2022-07-22
NR ELECTRIC CO LTD +1
View PDF1 Cites 0 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
  • A time series database data interaction method and system based on container and hierarchical model
  • A time series database data interaction method and system based on container and hierarchical model
  • A 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 shown, methods include:

[0063] Obtain the data update status information of the business model library, and in response to the occurrence of a data update event in the business model library, obtain the updated business model information, and update it to a 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, parse 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 access target measuring point being a single measuring point, determine the corresponding single-sided point ...

Embodiment 1-1

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

[0074] The method of the present invention mainly involves the following contents:

[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 measuring point record objects in the model version and the hierarchical model cache through incremental modification.

[0077] The method of this embodiment further includes: saving the obtained updated business model as the latest version model to a preset model repository;

[0078] The acquiring data update status information of the business model library includes receiving business model change notification information from the outside;

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

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

example 2

[0121] 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, determine the time series database instance corresponding to the measurement point; the point number management range of the time series database instance is set when the time series database instance is registered. For the point number interval, for example, 10,000 points with point numbers from 0 to 9999 are responsible for interaction by time series database instance 1; the measurement points with point numbers from 10000 to 19999 are responsible for interaction by time series database instance 2;

[0122] For each time series database instance, summarize the single measurement 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 requ...

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 manages and maintains a hierarchical model of a power monitoring object and associates measurement points and model objects, so that external access requests can be queried by searching the hierarchical model cache. The time series database point number of the target measurement point is accessed, and then the corresponding time series database is accessed according to the point number, which simplifies the complexity of the application accessing the time series database; for the multi-measurement point access request, the present invention utilizes the container technology to access the multi-measurement points. Requests are divided into access request queues corresponding to a single time series database instance, and are allocated to different containers to run in parallel, realizing elastic expansion of access processing capabilities. Using the present invention can greatly improve the access efficiency.

Description

technical field [0001] The invention relates to the technical field of time series database access of 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 the power dispatch automation system is to first obtain the measuring point information of the power monitoring object through the business model library, and then use the ID of the measuring point to search for the time series database point number corresponding to the measuring point in a conversion table. , and finally access the time series database to obtain data through the point number of the time series database. 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 complicated and prone...

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/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