XPS a database server for data warehousing

Authors:
Andreas Weininger
Affiliations:
IBM Data Management Solutions
Venue:
Proceedings of the 4th ACM international workshop on Data warehousing and OLAP
Year:
2001

Citing 3
Cited 1

Multi-table joins through bitmapped join indices

ACM SIGMOD Record
The data warehouse toolkit: practical techniques for building dimensional data warehouses

The data warehouse toolkit: practical techniques for building dimensional data warehouses
Materialized views: techniques, implementations, and applications

Materialized views: techniques, implementations, and applications

Efficient execution of joins in a star schema

Proceedings of the 2002 ACM SIGMOD international conference on Management of data

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.