9results about How to "Improve query performance" patented technology

This invention relates to an index construction method, device, program product, and storage medium, and pertains to the technical field of vector databases. The method includes: acquiring query vectors; calculating the coordinate region identifiers of each query vector in the vector space; statistically analyzing the query frequency of each coordinate region identifier within a preset time window to obtain regional query frequency distribution data; calculating the frequency growth rate of the regional query frequency distribution data of each coordinate region identifier at the current moment compared to the regional query frequency distribution data at the previous moment; calculating a query popularity fluctuation coefficient based on each frequency growth rate; monitoring the load parameters of the vector database system in real time and calculating a comprehensive system load index based on the load parameters; and constructing an index for each query vector based on the query popularity fluctuation coefficient and the comprehensive system load index. Implementing the technical solution provided in this application can achieve a balance between indexing effectiveness and system stability.

This application provides one or more embodiments of a relational database management method and apparatus. The method includes: obtaining a creation instruction for creating a target data table in the relational database; wherein the creation instruction includes column information corresponding to basic data columns in the target data table; responding to the creation instruction, creating the target data table in the relational database, including the basic data columns and hidden data columns, based on the column information; wherein the hidden data columns are extended data columns independent of the basic data columns; after the target data table is created, establishing a unique tree-structured index for the target data table based on the data in the hidden data columns; wherein the data in the hidden data columns corresponding to data rows in the target data table includes monotonically increasing values.

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.

This application discloses a data aggregation method, data aggregation device, electronic device, and storage medium, relating to the field of computer technology. It can improve the query performance of data after it is stored in the database, and reduce the difficulty and cost of querying. The specific solution includes: acquiring network data stream traffic data; generating at least one first data log and at least one second data log based on the traffic data; aggregating all first data logs according to a first aggregation rule based on the link identifier corresponding to the first data log to obtain at least one first aggregated log; and aggregating all second data logs according to a second aggregation rule based on the link identifier corresponding to the second data log to obtain at least one second aggregated log.

This invention discloses a method and system for automated generation and optimization of database table structures. The method specifically includes: receiving the user's backend project source code; extracting a semantic information network graph related to data persistence through static code scanning; inputting the semantic information network graph into an intelligent parsing engine to analyze code logic relationships and obtain index recommendation strategies and potential table structure design flaws; based on the index recommendation strategies and potential table structure design flaws, identifying sensitive fields and recommending encryption or de-identification schemes to obtain a first table structure; performing automated stress testing on the first table structure and adjusting the index strategy and partitioning scheme based on the test results; and optimizing the first table structure according to the adjusted index strategy and partitioning scheme to obtain a second table structure. This invention achieves intelligent generation and optimization of database table structures, improving development efficiency, enhancing maintainability, improving user experience, and ensuring data security.

This application relates to a method, system, and medium for querying order communication data based on order status changes. The method includes: monitoring the status of a target order, where the target order status includes an order creation status used to trigger data preloading; when an order creation status is detected, acquiring historical communication data associated with the target order and storing the historical communication data in a preloaded cache area; in response to receiving a compliant query request for the target order, merging the historical communication data with real-time acquired incremental data to obtain the target order communication data; and performing a compliant query on the target order communication data to obtain the query results. This addresses the problem of how to improve the performance of order communication data querying in related technologies.

This application belongs to the field of computer technology, specifically relating to a data query method, a data query device, a computer-readable medium, an electronic device, and a computer program product. The method includes: parsing a data query request to obtain query conditions, the query conditions including one or more of a subject, an object, and a predicate, the predicate representing the logical relationship between the subject and the object; determining a target data partition in a graph database based on the query conditions, the graph database including a first-level data partition obtained by dividing regions according to the density relationship between nodes, the first-level data partition including a second-level data partition obtained by dividing regions according to the logical relationship between nodes; and retrieving data query results matching the query conditions from the target data partition. This application can improve data query efficiency and reduce resource consumption in the data query process.

The application relates to the field of databases, and particularly provides a small-range out-of-order time sequence data fast query method and device, which limits the out-of-order degree, makes the time sequence data be in order from the overall trend, and uses a dichotomy search and local traversal mode to query the record at a certain time point or filter all records in a certain time period. Compared with the prior art, the application can limit the out-of-order degree of the time sequence data, use the dichotomy search and local traversal mode, make it unnecessary to traverse all records when the record at a certain time point or in a certain time period is queried, improve the overall query performance of the database, reduce the IO of the disk, and improve the use experience of the user.

The present application belongs to the technical field of program analysis, and relates to a high-efficiency analysis method and system for a result of a pollution analysis. The method comprises the following steps: receiving and verifying an input propagation process file and a node relationship file; constructing a mapping relationship from a source node to a target node for the node relationship file and extracting instruction numbers, generating a source node-target node mapping file and an index file according to the mapping relationship from the source node to the target node, and generating an instruction number file according to the instruction numbers; performing segmented processing on the propagation process file to obtain a segmented file and a segmented information file; and locating and querying pollution propagation information of any instruction number or index position by using the files. The present application realizes high-efficiency processing and fast querying of a large-scale pollution analysis result file, solves the problems of excessively large file size, low querying efficiency and excessive memory occupation in the prior art, and significantly improves the analysis and querying capacity for pollution analysis result data.