ADAPTIVE ROW-BATCH PROCESSING OF DATABASE DATA
First Claim
1. A computer-implemented query system having a physical storage media, comprising:
- a query plan for execution against data stores that include row data stores and column data stores; and
a query execution component that controls execution of the query plan to switch between row-wise processing and column-wise processing based on the data stores accessed as part of query plan execution.
2 Assignments
0 Petitions
Accused Products
Abstract
Architecture that provides for greater interoperability between column stores and row stores by leveraging the advantages both have to offer. The architecture operates automatically (e.g., dynamically) to move between row oriented processing mode and batch processing mode, and the combination thereof, when it is more beneficial to run in one mode relative to the other mode, or both modes. The auto-switching of data processing between batch and row oriented mode occurs during the execution of a single query. The architecture can automatically modify an operator in the query tree and/or remove an operator if desired at runtime for more efficient processing. This approach also accounts for memory constraints for either of row or column processing.
-
Citations
20 Claims
-
1. A computer-implemented query system having a physical storage media, comprising:
-
a query plan for execution against data stores that include row data stores and column data stores; and a query execution component that controls execution of the query plan to switch between row-wise processing and column-wise processing based on the data stores accessed as part of query plan execution. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A computer-implemented query system having a physical storage media, comprising:
-
a query plan for execution against data stores that include row data stores and column data stores; and a query execution component that controls execution of the query plan to switch between row-wise processing and column-wise processing at runtime based on available memory as part of query plan execution, the query execution component defaults to row-wise processing of the query plan and switches to column-wise processing based on memory available to accommodate column-wise processing of the query plan. - View Dependent Claims (11, 12, 13)
-
-
14. A computer-implemented query method executable via a processor and memory, comprising:
-
receiving a query plan for execution against row data stores and column data stores; determining available resources for query plan processing; monitoring query results at steps of plan execution relative to the available resources; and dynamically switching between row-wise processing and column-wise processing at runtime based on the available resources. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification