XPS a database server for data warehousing

摘要

A database server used for implementing a data warehouse must support other features than a database server used for OLTP. Therefore, in this paper we will look specifically at features necessary for efficiently processing queries on a database with a star schema model, a database scheme which is used very often in data warehousing. We will especially analyze the features provided for this by the IBM Extended Parallel Server (XPS). There are special star join methods like the Push-Down Hash Semi Join, new access methos like Generalized Key (GK) indices, and specific index usages like multi-index scans for supporting the efficient processing of star schema queries.