SYSTEM AND METHOD FOR BATCH QUERY PROCESSING

摘要

A system and method of batch query processing includes accumulating data queries in a query holding area of a query assistant running in a computer server, separating the accumulated data queries into a plurality of partitions, ordering the partitions, ordering the accumulated data queries within each of the partitions, and processing the accumulated data queries in an order based on the ordering of the partitions and the ordering of the data queries within each of the partitions. Each of the partitions includes data queries with a respective from-type. Each respective from-type is associated with a combination of storage tables accessed by each of the data queries in a corresponding partition. In some examples, ordering the accumulated data queries within each of the partitions includes processing the data queries in each partition against a test data set and ordering the data queries based on results of the processing.

主权项

1. A method of processing data source queries, the method comprising:
accumulating the data source queries in a query holding area of a query assistant running in a computer server; separating the accumulated data source queries into a plurality of partitions, each of the partitions including data source queries with a respective from-type, each respective from-type being associated with a combination of storage tables accessed by each of the data source queries in a corresponding partition; ordering the partitions; ordering the accumulated data source queries within each of the partitions; and processing the accumulated data source queries in an order based on the ordering of the partitions and the ordering of the data source queries within each of the partitions.