A query transaction allocation method and device

Abstract

The embodiment of the invention provides an inquiry transaction distribution method and device. The method includes the steps that an inquiry request is received; the source list information including data time, data sources and inquiry complexity is analyzed from the inquiry request; the source list information is matched with a set allocation strategy, so that distribution information is generated; the inquiry request is selected to be sent to a corresponding transaction processing system or a data warehouse to be executed according to the distribution information. By means of the inquiry transaction distribution method and device, the load of the transaction processing system can be greatly lowered, and thus the transaction processing system can execute the transaction processing work more efficiently. An inquiry statement of the transaction processing system is automatically converted into an inquiry statement of the data warehouse, a request party of the inquiry request can concentrate on the logic of the inquiry request, and there is no need to write different inquiry requests for different inquiry systems. Due to the participation of the data warehouse, the inquiry request can be more complex, the time span is wider, and therefore various inquiry needs can be met.

Description

technical field [0001] The present invention relates to the field of database technology and data processing technology, in particular to the field of data query technology, specifically a method and device for allocating query tasks in the field of data query. Background technique [0002] With the rapid development of enterprise business, inter-system query requests and system data query requirements become more and more complex and frequent. Generally, such requests will be directly submitted to the data generator, that is, transaction executed in the processing system. The advantage of this execution method is that the latest and most timely data can be obtained, and the disadvantage is that it will occupy the resources of the transaction processing system. Moreover, this execution method usually does not support cross-system data query, and cannot execute more complex queries to reduce the impact on normal transaction processing, and the data retention time is short, w...

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to overcome the shortcomings of the current transaction processing system, such as the short data time span, the data range is limited to a single transaction and is not suitable for executing complex and large-scale query requests, and the data warehouse data has low timeliness, and proposes a query The transaction allocation method and device, by automatically analyzing the query requests to be submitted to the transaction processing system, choose to allocate different query requests to the transaction processing system or data warehouse for execution, so as to improve query efficiency

Images