Distributed databases principles and systems
Distributed databases principles and systems
ACM Computing Surveys (CSUR)
Query Processing in a Fragmented Relational Distributed System: Mermaid
IEEE Transactions on Software Engineering - Annals of discrete mathematics, 24
An Optimal Algorithm for Processing Distributed Star Queries
IEEE Transactions on Software Engineering
Optimization of join operations in horizontally partitioned database systems
ACM Transactions on Database Systems (TODS)
Modeling the storage architectures of commercial database systems
ACM Transactions on Database Systems (TODS)
Set query optimization in distributed database systems
ACM Transactions on Database Systems (TODS)
R* optimizer validation and performance evaluation for local queries
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
Algorithms to Process Distributed Queries in Fast Local Networks
IEEE Transactions on Computers
SIGMOD '88 Proceedings of the 1988 ACM SIGMOD international conference on Management of data
A benchmark of NonStop SQL on the debit credit transaction
SIGMOD '88 Proceedings of the 1988 ACM SIGMOD international conference on Management of data
Optimizing Join Queries in Distributed Databases
IEEE Transactions on Software Engineering
Petri-Net-Based Modeling and Evaluation of Pipelined Processing of Concurrent Database Queries
IEEE Transactions on Software Engineering
Optimizing Joins in Fragmented Database Systems on a Broadcast Local Network
IEEE Transactions on Software Engineering
A case study for distributed query processing
DPDS '88 Proceedings of the first international symposium on Databases in parallel and distributed systems
Node autonomy in distributed systems
DPDS '88 Proceedings of the first international symposium on Databases in parallel and distributed systems
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
The Raid Distributed Database System
IEEE Transactions on Software Engineering
Partition Strategy for Distributed Query Processing in Fast Local Networks
IEEE Transactions on Software Engineering
An effective algorithm for parallelizing sort merge joins in the presence of data skew
DPDS '90 Proceedings of the second international symposium on Databases in parallel and distributed systems
Query processing in a system for distributed databases (SDD-1)
ACM Transactions on Database Systems (TODS)
Introduction to a system for distributed databases (SDD-1)
ACM Transactions on Database Systems (TODS)
Using Semi-Joins to Solve Relational Queries
Journal of the ACM (JACM)
Distributed query processing in a relational data base system
SIGMOD '78 Proceedings of the 1978 ACM SIGMOD international conference on management of data
Distributing a database for parallelism
SIGMOD '83 Proceedings of the 1983 ACM SIGMOD international conference on Management of data
Estimating block transfers and join sizes
SIGMOD '83 Proceedings of the 1983 ACM SIGMOD international conference on Management of data
Overview of an Ada compatible distributed database manager
SIGMOD '83 Proceedings of the 1983 ACM SIGMOD international conference on Management of data
Common expression analysis in database applications
SIGMOD '82 Proceedings of the 1982 ACM SIGMOD international conference on Management of data
The Gamma Database Machine Project
IEEE Transactions on Knowledge and Data Engineering
An Evaluation of Relational Join Algorithms in a Pipelined Query Processing Environment
IEEE Transactions on Software Engineering
Proceedings of the Fifth International Conference on Data Engineering
Experiences with Distributed Query Processing
Proceedings of the Sixth International Conference on Data Engineering
A Multiuser Performance Analysis of Alternative Declustering Strategies
Proceedings of the Sixth International Conference on Data Engineering
Chained Declustering: A New Availability Strategy for Multiprocessor Database Machines
Proceedings of the Sixth International Conference on Data Engineering
A Methodology for Benchmarking Distributed Database Management Systems
Proceedings of the Seventh International Conference on Data Engineering
An Effective Algorithm for Parallelizing Hash Joins in the Presence of Data Skew
Proceedings of the Seventh International Conference on Data Engineering
Proceedings of the Second International Conference on Data Engineering
R* Optimizer Validation and Performance Evaluation for Distributed Queries
VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
A Heuristic Approach to Distributed Query Processing
VLDB '82 Proceedings of the 8th International Conference on Very Large Data Bases
Benchmarking Database Systems A Systematic Approach
VLDB '83 Proceedings of the 9th International Conference on Very Large Data Bases
Distributed Query Processing Strategies in Mermaid, A Frontend to Data Management Systems
Proceedings of the First International Conference on Data Engineering
A heuristic algorithm for partition strategy in distributed query processing
SAC '96 Proceedings of the 1996 ACM symposium on Applied Computing
Reasoning about Qualitative Spatial Relationships
Journal of Automated Reasoning
Reasoning About Spatial Relationships in Picture Retrieval Systems
VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
Generating query plans for distributed query processing using genetic algorithm
ICICA'11 Proceedings of the Second international conference on Information Computing and Applications
Distributed Query Plan Generation using Particle Swarm Optimization
International Journal of Swarm Intelligence Research
| Hi-index | 0.00 |
The authors discuss various performance issues in distributed query processing. Theyvalidate and evaluate the performance of the local reduction (LR) the fragment andreplicate strategy (FRS) and the partition and replicate strategy (PRS) optimizationalgorithms. The experimental results reveal that the choices made by these algorithmsconcerning which local operations should be performed, which relation should remainfragmented or which relation should be partitioned are valid. It is shown usingexperimental results that various parameters, such as the number of processing sites,partitioning speed relative to join speed, and sizes of the join relations, affect theperformance of PRS significantly. It is also shown that the response times of queryexecution are affected significantly by the degree of site autonomy, interferences amongprocesses, interface with the local database management systems (DBMSs) andcommunications facilities. Pipeline strategies for processing queries in an environmentwhere relations are fragmented are studied.