Query processing for decision support: the SQLmpp solution

Decision support systems are characterized by large data sets and complex queries with multi-way joins, aggregation and nesting. SQLmpp is a highly parallel database server designed to efficiently support these applications. SQLmpp's query processing strategy is driven by three principal goals: (1) data parallelism in all operations, (2) maximal use of any relevant indexes, and (3) minimal processing of complete relations. This paper describes the general query processing techniques and the specific operations used to achieve these goals.<
>