Patent ID: 8285709

Claim:
A method comprising: concurrently executing a set of multiple queries, through a processor, to improve a resource usage within a data warehouse system; permitting a group of users of the data warehouse system to simultaneously run a set of queries; applying a high-concurrency query operator to continuously optimize a large number of concurrent queries for a set of highly concurrent dynamic workloads; efficiently evaluating the set of queries through the high-concurrency query operator; increasing a query throughput and adjusting a query response time when the number of concurrent queries increases; sharing a set of resources associated with the data warehouse system across the set of queries; limiting a redundancy of a workload by answering the set of queries during a first scan of a fact table; reducing an output time and a set of costs associated with a corresponding set of results of the set of queries; assigning a unique positive identifier information to a particular query in the set of queries when the particular query registers with the operator; reusing the unique positive identifier information after an evaluation of the particular query is complete; and utilizing a set of system parameters to organize, denote and bound the set of concurrent queries; wherein the high concurrency query operator is a physical operator that allows a high-concurrency in a query and other queries that involve at least one of a JOIN operator; and wherein the set of resources associated with the data warehouse system is at least one of a disk I/O resource, a computation resource, and an in-memory data resource.