Query Optimization in Multidatabase Systems

作者: D.K. Subramanian , K. Subramanian

DOI: 10.1023/A:1008691331104

关键词:

摘要: Global query execution in a multidatabase system can be done parallelly, as all the local databases are independent. In this paper, cost model that considers parallel of subqueries for global is developed. order to obtain maximum parallelism execution, it required find plan represented form bushy tree and should balanced maximal possible extent with respect time. A new bottom up approach called Agglomerative Approach (AA) proposed construct trees By deterministic nature approach, generates optimal solutions. This minima problem will severe case graph queries, i.e., queries structure. Simulated annealing (SA) employed (near) solution. These approaches (AA SA) suitable handling on-line off-line respectively. Hybrid (HA), an integration AA SA, optimize which estimated time spent on optimization known priori. Results obtained SA both structured presented.

参考文章(45)
Carlo Zaniolo, Ravi Krishnamurthy, Haran Boral, Optimization of Nonrecursive Queries very large data bases. pp. 128- 137 ,(1986)
Yannis E. Ioannidis, Kristin P. Bennett, Michael C. Ferris, A Genetic Algorithm for Database Query Optimization ICGA. pp. 400- 407 ,(1991)
Rosana S. G. Lanzelotte, Patrick Valduriez, Extending the Search Strategy in a Query Optimizer very large data bases. pp. 363- 373 ,(1991)
Giuseppe Pelagatti, Stefano Ceri, Distributed Databases: Principles and Systems ,(1984)
Kian-Lee Tan, Ming-Chien Shan, Hongjun Lu, Optimization of Multi-Way Join Queries for Parallel Execution very large data bases. pp. 549- 560 ,(1991)
Qiang Zhu, Query optimization in multidatabase systems conference of the centre for advanced studies on collaborative research. pp. 111- 127 ,(1992)
Guy M. Lohman, Lothar F. Mackert, R* Optimizer Validation and Performance Evaluation for Distributed Queries very large data bases. pp. 537- 547 ,(1994)
Guy M. Lohman, C. Mohan, Laura M. Haas, Dean Daniels, Bruce G. Lindsay, Patricia G. Selinger, Paul F. Wilms, Query Processing in R Query Processing in Database Systems. pp. 31- 47 ,(1985) , 10.1007/978-3-642-82375-6_2
Ravi Krishnamurthy, Weimin Du, Ming-Chien Shan, Query Optimization in a Heterogeneous DBMS very large data bases. pp. 277- 291 ,(1992)
Richard C. Dubes, Anil K. Jain, Algorithms for clustering data ,(1988)