High-concurrency query operator and method

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.