6results about How to "Reduce query cost" patented technology

The invention discloses a data query method and device based on a dynamic script, equipment and a storage medium. Comprising the steps of obtaining query related information; wherein the query related information comprises at least one of the following items: a group name, a script name, a version number, a tenant identifier and a query parameter; obtaining dynamic script data and a script object according to the group name, the script name, the version number and the tenant identifier; loading the dynamic script data into the script object; generating a structured query language (SQL) statement based on the script object loaded with the dynamic script data and the query parameter; and querying target data from a data source corresponding to the tenant identifier based on the SQL statement. According to the dynamic script-based data query method provided by the embodiment of the invention, the SQL statement is generated through the script object loaded with the dynamic script data and the query parameter, so that the query of the target data is realized, the SQL statement is dynamically generated, a user does not need to manually write the SQL statement, the data query efficiency can be improved, and the query cost can be reduced.

The present application relates to a query method, device, computer equipment and storage medium. The method first obtains the associated information of the data table where the information to be queried is located, then determines the query strategy based on the associated information, and finally queries the information to be queried in the data table according to the query strategy to obtain the query result. Among them, the query strategy includes one of a statement query method, an index query method, and an engine query method. The above method determines the query strategy by analyzing the associated information of the information to be queried, and can flexibly select the most suitable query method for different scenarios of the associated information. The index query method and the engine query method are introduced. When the data scale is large, the problem of low efficiency of the statement query method can be improved to maximize the query efficiency. At the same time, the query cost can also be reduced.

The invention relates to the field of financial science and technology, in particular to the field of artificial intelligence and large models in the field of intelligent customer service, and particularly relates to a question and answer pair generation method and device, equipment and a storage medium. Calculating the in-block word importance degree of each word in each document block; on the basis of the in-block word importance degree of each word in each document block and a preset domain knowledge table, determining a domain knowledge category of each document block; determining a document block category of each document block based on each word in each document block; and based on each document block and the domain knowledge category and the document block category of each document block, determining a question and answer pair of each document block. According to the method, the query accuracy of the knowledge retrieval enhancement model is improved, and the query cost is reduced.

The present application relates to the technical field of bioinformatics, and particularly relates to a microbial classification integrated management method and device, a terminal and a storage medium, the method comprising: obtaining a data source, and obtaining a wide-format classification framework based on the data source; converting the wide-format classification framework into a long-format classification unit index, wherein the long-format classification unit index comprises an accepted name, a standardized name, a synonym, a rank element and a complete phylogeny; and based on the long-format classification unit index, performing phylogeny query on a classification name of any rank element to obtain a complete phylogeny result matching the classification name. The present application converts the wide-format classification framework into a data asset that is computable, batch-retrievable and updatable through the long-format classification unit index, and then performs phylogeny query on any rank element, is suitable for batch and repeatable phylogeny query on a large number of classification units, and reduces the query cost.

The invention relates to a database partition adjustment method and device, equipment, a storage medium and a program product. The method comprises the following steps: firstly, acquiring a target load set which accesses a database in a target time period and comprises a plurality of database access requests, then, according to the target load set, determining the query cost of the target load set which comprises the average query delay of the target load set, and if the query cost meets a preset switching condition, switching the database according to the query cost. And determining a dynamic database partition of the database according to the target load set, and performing partition adjustment processing on the database according to the dynamic database partition. By adopting the method, partition adjustment can be performed on the database according to the load of the database, and the query cost of the load is reduced, so that the query efficiency of the database is improved.

The application discloses a data query method and device and a computer readable storage medium, and belongs to the technical field of databases. The method comprises the following steps: determining a query template corresponding to a query request of a user; performing syntax analysis on the query request and the query template to generate a corresponding query statement; executing the query statement to obtain a corresponding query result, and sending the query result to the user. The application aims to reduce the query cost of the user.