Query processing for decision support: the SQLmpp solution

Author

Colby, Latha S. ; Martin, Nancy L. ; Wehrmeister, Robert M.

Author_Institution

Data Parallel Syst. Inc., Bloomington, IN, USA

fYear

1994

fDate

28-30 Sep 1994

Firstpage

121

Lastpage

130

Abstract

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

Keywords

SQL; decision support systems; file servers; indexing; parallel processing; query processing; SQLmpp; aggregation; complete relations; data parallelism; decision support systems; large data sets; maximal index usage; minimal processing; multi-way joins; nesting; parallel database server; query processing; Algorithm design and analysis; Decision support systems; Hardware; Pipeline processing; Query processing; Relational databases; Spatial databases; Throughput; Transaction databases; Volcanoes;

fLanguage

English

Publisher

ieee

Conference_Titel

Parallel and Distributed Information Systems, 1994., Proceedings of the Third International Conference on

Conference_Location

Austin, TX

Print_ISBN

0-8186-6400-2

Type

conf

DOI

10.1109/PDIS.1994.331724

Filename

331724