Skip to main content
U.S. Department of Energy
Office of Scientific and Technical Information

Data-flow query processing using multiprocessor hash-partitioned algorithms

Thesis/Dissertation ·
OSTI ID:5254628
This thesis demonstrates that hash-partitioned query-processing algorithms can serve as a basis for a highly parallel, high-performance relational data-base machine. In addition to demonstrating that parallelism can really be made to work in a data-base machine context, it is shown that such parallelism can be controlled with minimal overhead using data-flow query-processing techniques that pipeline data between highly autonomous, distributed processes. For this purpose, the design, implementation techniques, and initial performance evaluation of Gamma, a new relational data-base machine are presented. Gamma is a fully operational prototype consisting of 20 VAX 11/750 computers. The Gamma architecture illustrates that a high-performance data-base machine can be constructed without the assistance of special-purpose hardware components. Finally, a simulation model of Gamma is presented that accurately reflects the measured performance of the actual Gamma prototype. Using this simulation model, the performance of Gamma is explored for large multiprocessor systems with varying hardware capabilities.
Research Organization:
Wisconsin Univ., Madison (USA)
OSTI ID:
5254628
Country of Publication:
United States
Language:
English