Query processing for decision support: the SQLmpp solution

  • Authors:
  • Latha S. Colby;Nancy L. Martin;Robert M. Wehrmeister

  • Affiliations:
  • -;-;-

  • Venue:
  • PDIS '94 Proceedings of the third international conference on on Parallel and distributed information systems
  • Year:
  • 1994

Quantified Score

Hi-index 0.00

Visualization

Abstract

Decision support systems are chacterized 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.