Research on Query Optimization Technology in Distributed Database

Article Preview

Abstract:

Through the in-depth study of the existing distributed database query processing technology, this paper proposes a distributed database query processing program. This program optimizes the existing query processing, stores the commonly used query results according to the query frequency, to be directly used by the subsequent queries or used as intermediate query results, thus avoiding possible transmission of a large number of data, thereby reducing the query time and improving query efficiency.

You might also be interested in these eBooks

Info:

Periodical:

Advanced Materials Research (Volumes 433-440)

Pages:

3335-3339

Citation:

Online since:

January 2012

Authors:

Export:

Price:

Permissions CCC:

Permissions PLS:

Сopyright:

© 2012 Trans Tech Publications Ltd. All Rights Reserved

Share:

Citation:

[1] WU Yu-qing, J. M. Patel and H. V. Jagadish, Structural Join Order Selection for XML Query Optimization[C]. Proceedings of 19th International Conference on Data Engineering, Bangalore, India, 2003: 443-454.

DOI: 10.1109/icde.2003.1260812

Google Scholar

[2] D. Kossmann, K. Stoeker. Iterative Dynamic Programming: A New Class of Query Optimization Algorithms [J], ACM Transactions on Database Systems, 2000, 25(l): 43-82.

DOI: 10.1145/352958.352982

Google Scholar

[3] G. N. Khan and A. Sydhom. Fault-tolerant scheduling of real-time tasks having software faults[C]. Saskatoon: Canadian Conference on Electrical and Computer Engineering, 2005: 731-734.

DOI: 10.1109/ccece.2005.1557033

Google Scholar

[4] LEEE Chiang, CHIH Chi-sheng, CHEN Yaw-huei. Optimizing large join queries using a graph-based approach, IEEE Trans on Knowledge and Data Eng, 2001, 13 (2): 298-315.

DOI: 10.1109/69.917567

Google Scholar

[5] Bandyopadhyay S. Q. Fu and A. Sengupta, A cyclic multi-relation semi join operation for query optimization in distributed databases.Proc.19th IEEE International Performance, Computing and Communications Conference-IPCCC 2000: 101-107.

DOI: 10.1109/pccc.2000.830307

Google Scholar

[6] S. Sundaresan and G. Hu, Schema Integration of Distributed Databases Using Hyper-Graph Data Model. Proceedings of the IEEE International Conference on information Reuse, 2005: 548-553.

DOI: 10.1109/iri-05.2005.1506531

Google Scholar

[7] TSAIPSM, CHENALP. Optimizing queries with foreign function in a distributed environment [J], IEEE Trans on Knowledge and Data Eng, 2002, V14 (2): 809-824.

Google Scholar