Efficient algorithms for resource allocation in distributed and parallel query processing environments

Several effective algorithms are presented for the optimal allocation of computer resources in a proposed stream-oriented parallel-processing scheme for database operations. These algorithms can be utilized to obtain the optimal allocation of memory resources for every type of query in sequential-processing environments, parallel-processing environments with shared-memory multiprocessors, and distributed-processing environments. The computation complexities of the proposed algorithms are analyzed and used to clarify the effectiveness of those algorithms.<<ETX>>

[1]  Steven R. Vegdahl,et al.  A Survey of Proposed Architectures for the Execution of Functional Languages , 1984, IEEE Transactions on Computers.

[2]  Won Kim,et al.  A new way to compute the product and join of relations , 1980, SIGMOD '80.

[3]  John Miles Smith,et al.  Optimizing the performance of a relational algebra database interface , 1975, CACM.

[4]  Michael Stonebraker,et al.  Operating system support for database management , 1981, CACM.

[5]  Patricia G. Selinger,et al.  Access path selection in a relational database management system , 1979, SIGMOD '79.

[6]  Stavros Christodoulakis,et al.  Estimating block transfers and join sizes , 1983, SIGMOD '83.

[7]  David J. DeWitt,et al.  Performance Analysis of Alternative Database Machine Architectures , 1982, IEEE Transactions on Software Engineering.

[8]  Eugene Wong,et al.  Decomposition—a strategy for query processing , 1976, TODS.

[9]  Clement T. Yu,et al.  Distributed query processing , 1984, CSUR.

[10]  Takashi Masuda,et al.  A Stream-Oriented Approach to Parallel Processing for Deductive Databases , 1987, IWDM.

[11]  Takashi Masuda,et al.  A Relational-Database Machine Based on Functional Programming Concepts , 1986, FJCC.

[12]  Yasushi Kiyoki,et al.  Performance Analysis for Parallel Processing Schemes of Relational Operations and a Relational Database Machine Architecture with Optimal Scheme Selection Mechanism , 1982, IEEE International Conference on Distributed Computing Systems.

[13]  David J. DeWitt,et al.  Processor allocation strategies for multiprocessor database machines , 1981, TODS.