Title :
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
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;
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
DOI :
10.1109/PDIS.1994.331724
