Abstract
DarGrid II is an implemented database gird system whose goal is to provide a semantic solution for integrating database resources on the web. Although many algorithms have been proposed for optimizing query-processing in order to minimize costs and/or response time, associated with obtaining the answer to query in a distributed database system, database grid query optimization problem is fundamentally different from distributed query optimization. These differences are shown to be the consequences of autonomy and heterogeneity of databases in database grid. Therefore, more challenges have arisen for query optimization in database grid than traditional distributed database. Following this observation, we present the design of a query optimizer in DartGrid II, and a heuristic, dynamic, and parallel query optimization approach for processing query in database grid is proposed.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Kossmann, D., Storcker, K.: Iterative Dynamic Programming: A New Class of Query Optimization Algorithms. ACM Transactions on Database Systems 25(1), 43–82 (2000)
Bitton, D., Boral, H., DeWitt, D.J., Wilkinson, W.K.: Parallel Algorithms for the Execution of Relational Database Operations. ACM Trans. Database Syst. 8(3), 324–353 (1983)
Galindo-Legaria, C., Pellenkoft, A., Kersten, M.: Fast, randomized join-order selection-why use transformations? In: Proceedings of the 20th International Conference on Very Large Data Bases, September 1994, pp. 85–95 (1994)
Graefe, G., DeWitt, D.: The EXODUS optimizer generator. In: Proceedings of the ACM-SIGMOD Conference on Management of Data, May 1987, pp. 160–172 (1987)
Graefe, G., Mckenna, W.J.: The volcano optimizer generator: Extensibility and efficient search. In: Proceedings of the 9th International Conference on Data Engineering, April 1993, pp. 209–218 (1993)
Lu, H., Ooi, B.-C., Goh, C.-H.: Multidatabase query optimization: issues and solutions. Research Issues in Data Engineering, 137–143 (April 1993)
Zhuge, H., Liu, J., Feng, L., Sun, X., He, C.: Query Routing in a Peer-to-Peer Semantic Link Network. Computational Intelligence 21(2), 197–216 (2005)
Ioannidis, Y.E., Kang, Y.C.: Randomized algorithms for optimizing large join queries. In: Proceedings of the 1990 ACM SIGMOD International Conference on Management of Data, May 1990, pp. 312–321 (1990)
Wang, J.-C., Horng, J.-T., Hsu, Y.-M.: A genetic algorithm for set query optimization in distributed database systems. In: IEEE International Conference on Systems, Man, and Cybernetics, vol. 3, pp. 14–17 (1996)
Veijalainen, J., Popescu-Zeletin.: Multidatabase systems in ISO/OSI environment. Standards in Information Technology and Industrial Control, 83–97 (1988)
Lanzelotte, R., Valduries, P., Zait, M.: On the effectiveness of optimization search strategies for parallel execution spaces. In: Proceedings of the Conference on Very Large Data Bases, Auguest 1993, pp. 493–504 (1993)
Tamer Özsu, M., Valduriez, P.: Principles of Distributed Database Systems. Prentice Hall, Inc., Englewood Cliffs (1999)
Ono, K., Lohman, G.: Measuring the complexity of join enumeration in query optimization. In: Proceedings of the 16th International Conference on Very Large Data Bases, August 1990, pp. 314–325 (1990)
Palermo, F.P.: A data base search problem. In: Information Systems COINS IV, pp. 67–101 (1974)
Bernstein, P.A., Goodman, N., et al.: Query Processing in a System for Distributed Database (SDD-1). ACM trans. Database Syst. 6(4), 602–625 (1981)
Valduriez, P., Gardarin, G.: Join and Semi-join Algorithms for a Multi Processor Database Machine. ACM Trans. Databases Syst. 9(1), 133–161 (1984)
Zhu, Q.: Query Optimization in Multidatabase Systems. In: Proc. the Centre for Advanced Studies Conf. on Collaborative research, November 1992, pp. 111–127 (1992)
Selinger, P.G., Astrahan, M.M., Lorie, R.A., Price, T.G.: Access path selection in a relational database management system. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, May-June 1979, pp. 23–34 (1979)
Selinger, P.G., Adiba, M.: Access Path Seletion in Distributed Data Base Management Systems. In: Proc. First Int. Conf. on Data Bases, pp. 204–215 (1980)
Shekita, E., Young, H., Tan, K.-L.: Multi-join optimization for symmetric multiprocessors. In: Proc. Conf. on Very Large Data Bases, Auguest 1993, pp. 479–492 (1993)
Steinbrunn, M., Moerkotte, G., Kemper, A.: Heuristic and randomized optimization for the join ordering problem, 191–208 (August 1997)
Swami, A.: Optimization of large join queries: Combining heuristics and combinational techniques. In: Proceedings of the ACM Conference on Management of Data, May 1989, pp. 367–376 (1989)
Ioannidis, Y.E., Wong, E.: Query optimization by simulated annealing. In: proc. ACM SIGMOD Int. Conf. on Management of Data, June 1987, pp. 9–22 (1987)
Wu, Z., Chen, H., Changhuang, C., Zheng, G., Xu, J.: DartGrid: Semantic-Based Database Grid. In: ICCS 2004, pp. 59–66 (2004)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Zheng, X., Chen, H., Wu, Z., Mao, Y. (2005). Query Optimization in Database Grid. In: Zhuge, H., Fox, G.C. (eds) Grid and Cooperative Computing - GCC 2005. GCC 2005. Lecture Notes in Computer Science, vol 3795. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11590354_62
Download citation
DOI: https://doi.org/10.1007/11590354_62
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-30510-1
Online ISBN: 978-3-540-32277-1
eBook Packages: Computer ScienceComputer Science (R0)