Processor allocation strategies for multiprocessor database machines
- 1 June 1981
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 6 (2) , 227-254
- https://doi.org/10.1145/319566.319570
Abstract
In this paper four alternative strategies for assigning processors to queries in multiprocessor database machines are described and evaluated. The results demonstrate that SIMD database machines are indeed a poor design when their performance is compared with that of the three MIMD strategies presented. Also introduced is the application of data-flow machine techniques to the processing of relational algebra queries. A strategy that employs data-flow techniques is shown to be superior to the other strategies described by several experiments. Furthermore, if the data-flow query processing strategy is employed, the results indicate that a two-level storage hierarchy (in which relations are paged between a shared data cache and mass storage) does not have a significant impact on performance.Keywords
This publication has 17 references indexed in Scilit:
- Optimization of query evaluation algorithmsACM Transactions on Database Systems, 1979
- Direct—A Multiprocessor Organization for Supporting Relational Database Management SystemsIEEE Transactions on Computers, 1979
- DBC—A Database Computer for Very Large DatabasesIEEE Transactions on Computers, 1979
- Implementing a relational database by means of specialzed hardwareACM Transactions on Database Systems, 1979
- Performance evaluation of a relational associative processorACM Transactions on Database Systems, 1977
- A Data Flow MultiprocessorIEEE Transactions on Computers, 1977
- Storage and access in relational data basesIBM Systems Journal, 1977
- The design and implementation of INGRESACM Transactions on Database Systems, 1976
- Optimizing the performance of a relational algebra database interfaceCommunications of the ACM, 1975
- MonitorsCommunications of the ACM, 1974