Partition strategy for distributed query processing in fast local networks
- 1 June 1989
- journal article
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Transactions on Software Engineering
- Vol. 15 (6) , 780-793
- https://doi.org/10.1109/32.24731
Abstract
[[abstract]]A partition-and-replicate strategy for processing distributed queries referencing no fragmented relation is sketched. An algorithm is given to determine which relation and which copy of the relation is to be partitioned into fragments, how the relation is to be partitioned, and where the fragments are to be sent for processing. Simulation results show that the partition strategy is useful for processing queries in fast local network environments. The results also show that the number of partitions does not need to be large. The use of semijoins in the partition strategy is discussed. A necessary and sufficient condition for a semijoin to yield an improvement is provided[[fileno]]2030208010042[[department]]資訊工程學This publication has 26 references indexed in Scilit:
- R* optimizer validation and performance evaluation for local queriesACM SIGMOD Record, 1986
- Fragmentation: a technique for efficient query processingACM Transactions on Database Systems, 1986
- Optimization of join operations in horizontally partitioned database systemsACM Transactions on Database Systems, 1986
- Database partitioning in a cluster of processorsACM Transactions on Database Systems, 1985
- Distributing a database for parallelismPublished by Association for Computing Machinery (ACM) ,1983
- Optimization Algorithms for Distributed QueriesIEEE Transactions on Software Engineering, 1983
- Transforming cyclic schemas into treesPublished by Association for Computing Machinery (ACM) ,1982
- Using Semi-Joins to Solve Relational QueriesJournal of the ACM, 1981
- Preemptive Scheduling of Real-Time Tasks on Multiprocessor SystemsJournal of the ACM, 1970
- Scheduling with Deadlines and Loss FunctionsManagement Science, 1959