Patent ID: 8660985

Claim:
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; among them, a fact table and dimension tables being stored by adopting a column store model, a dimensional attribute column is loaded into main memory to form a memory dimensional attribute array, wherein a primary key is corresponding to a subscript of the memory dimensional attribute array; a foreign key attribute value of the fact table tuple is mapped to a subscript of the memory dimensional attribute array in the corresponding dimension table; and the fact table and the dimension tables complete a multi-table join operation through a corresponding relation between the foreign key and the primary key, 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.