The invention discloses an OLAP query
processing method based on array storage and vector
processing. In the method, array subscript mapping is carried out on major keys and foreign keys according to
referential integrity constraint in a
data warehouse model, the major keys of a
dimension table and the foreign keys of a
fact table are directly mapped to be array subscript addresses, the complex model is converted into a virtual materialized table, and a unified
data access view is provided for different queries. The OLAP query is simplified to be three stages of predicate
processing, grouping processing and gathering processing. In the stage of predicate processing, selection vectors are used for processing a selection result, on the
fact table, of a plurality of predicates many times; in the stage of grouping processing, grouping vectors are used for distributing grouping array subscripts for each
fact table record for meeting the predicate condition; in the stage of gathering processing, gathering vectors are used for providing an aggregator based on an array for an
aggregate function. The OLAP query processing method based on array storage and vector processing simplifies the OLAP query processing process under a complex mode, eliminates the connection operation between the tables, and improves the code execution efficiency when the OLAP query processing is carried out.