Distributed query processing a multiple database system
- 1 April 1989
- journal article
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Journal on Selected Areas in Communications
- Vol. 7 (3) , 390-398
- https://doi.org/10.1109/49.16871
Abstract
Mermaid is a testbed system which provides integrated access to multiple databases. Two query optimization algorithms have been developed for Mermaid. The semijoin algorithm tends to reduce the data transmission cost, while the replicate algorithm reduces the processing cost. An algorithm that integrates the features of these two algorithms to optimize the processing cost as well as the transmission cost is presented. A dynamic network environment is considered where processing speeds at each site and transmission speeds at each link can be variable. Moreover, distributed processing of aggregates is considered based on the functional dependency among the fragment attribute, the aggregate attribute, and the group-by attribute. Semantic information is utilized to obtain efficient query processing.Keywords
This publication has 12 references indexed in Scilit:
- Algorithms to Process Distributed Queries in Fast Local NetworksIEEE Transactions on Computers, 1987
- Mermaid—A front-end to distributed heterogeneous databasesProceedings of the IEEE, 1987
- An Optimal Algorithm for Processing Distributed Star QueriesIEEE Transactions on Software Engineering, 1985
- Query Processing in a Fragmented Relational Distributed System: MermaidIEEE Transactions on Software Engineering, 1985
- Improvement Algorithms for Semijoin Query Processing Programs in Distributed Database SystemsIEEE Transactions on Computers, 1984
- Query Optimization in Database SystemsACM Computing Surveys, 1984
- Optimizing Chain Queries in a Distributed Database SystemSIAM Journal on Computing, 1984
- Query processing in a system for distributed databases (SDD-1)ACM Transactions on Database Systems, 1981
- Using Semi-Joins to Solve Relational QueriesJournal of the ACM, 1981
- A methodology for interpreting tree queries into optimal semi-join expressionsPublished by Association for Computing Machinery (ACM) ,1980