3results about How to "Speed up query" patented technology

The application discloses a system and method for accelerating reading compressed files based on A Virtual File System, and belongs to the technical field of time series databases; the technical problem to be solved by the application is how to realize column format compressed storage and reading of time series data types, reduce IO, memory and CPU consumption caused by decompression, and improve the ability of the system to process time series data; the technical scheme adopted is as follows: in the time series engine of the open database ZNBase, an execution engine generates an execution plan according to SQL semantic analysis, calls a storage layer interface of ZNBase, and queries accurate time series history partition compressed data; the storage layer completes fast execution of the query in the storage layer based on various compressed query interfaces provided by AVFS, and accelerates the query of the database; the specific steps are as follows: pre-analysis; compressed file pre-reading; reading compressed data.

The application discloses a planning processing method and system for pre-aggregation calculation of a time series database, belongs to the technical field of time series databases, and aims to solve the technical problem of how to quickly query the aggregation calculation results of each collection point. The method comprises the following steps: obtaining a pre-aggregation calculation statement input by a user; calling a logical execution plan generation interface of a parser to analyze the pre-aggregation calculation statement, analyzing the pre-aggregation calculation statement into a corresponding logical plan, and analyzing the result type of the aggregation rule of the pre-aggregation calculation statement; creating a result table according to the obtained result type, wherein the result table is used for storing the aggregation calculation results; calling an execution plan generation interface of the parser to generate a general execution plan based on the logical plan; clipping the execution plan to obtain a clipped execution plan; and matching the clipped execution plan with the result table and executing the result table.

The application discloses a kind of graph data heterogenous layered storage structure and method based on persistent memory, the application uses layered hash table heterogenous storage structure, stores the equivalent query data structure in topology data and index data in graph data, simultaneously using a layered storage B+Tree storage structure, stores the range query data structure in index data, solves the problem of query speed and limited memory space, simultaneously by converting the random write of persistent memory into sequential write, reduce write delay, by constructing the architecture of layered storage, reduce the write times of data structure in persistent memory, improve query efficiency.