Multi-Dimensional OLAP Query Processing Method Oriented to Column Store Data Warehouse
First Claim
1. A multi-dimensional on-line analytical processing (OLAP) query processing method oriented to a column store data warehouse, an OLAP query being divided into a bitmap filtering operation, a group-by operation and an aggregate operation, a fact table and dimension tables being stored by adopting a column store model, wherein:
- in the bitmap filtering operation, a predicate is executed on the dimension table to generate a predicate vector bitmap, and a join operation is converted, through address mapping of a surrogate key, into a direct dimension table tuple access operation, thereby implementing access according to a position;
in the group-by operation, a fact table tuple satisfying a filtering condition is pre-generated into a group-by unit according to a group-by attribute in an SQL command and is allocated with an increasing ID; and
in the aggregate operation, group-by aggregate calculation is performed according to a group item of a fact table filtering group-by vector through one-pass column scan on a fact table measure attribute.
1 Assignment
0 Petitions
Accused Products
Abstract
A multi-dimensional OLAP query processing method oriented to a column store data warehouse is described. With this method, an OLAP query is divided into a bitmap filtering operation, a group-by operation and an aggregate operation. In the bitmap filtering operation, a predicate is first executed on a dimension table to generate a predicate vector bitmap, and a join operation is converted, through address mapping of a surrogate key, into a direct dimension table tuple access operation; in the group-by operation, a fact table tuple satisfying a filtering condition is pre-generated into a group-by unit according to a group-by attribute in an SQL command and is allocated with an increasing ID; and in the aggregate operation, group-by aggregate calculation is performed according to a group item of a fact table filtering group-by vector through one-pass column scan on a fact table measure attribute.
55 Citations
10 Claims
-
1. A multi-dimensional on-line analytical processing (OLAP) query processing method oriented to a column store data warehouse, an OLAP query being divided into a bitmap filtering operation, a group-by operation and an aggregate operation, a fact table and dimension tables being stored by adopting a column store model, wherein:
-
in the bitmap filtering operation, a predicate is executed on the dimension table to generate a predicate vector bitmap, and a join operation is converted, through address mapping of a surrogate key, into a direct dimension table tuple access operation, thereby implementing access according to a position; in the group-by operation, a fact table tuple satisfying a filtering condition is pre-generated into a group-by unit according to a group-by attribute in an SQL command and is allocated with an increasing ID; and in the aggregate operation, group-by aggregate calculation is performed according to a group item of a fact table filtering group-by vector through one-pass column scan on a fact table measure attribute. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
Specification