Skip to main content
Article
An Efficient Semantic Query Optimization Algorithm
Proceedings of the 7th IEEE International Conference on Data Engineering (ICDE): April 8-12, 1991, Kobe, Japan
  • Hwee Hwa PANG, Singapore Management University
  • Hongjun LU, National University of Singapore
  • Beng Chin LU, Institute of Systems Science, Singapore
Publication Type
Conference Proceeding Article
Version
publishedVersion
Publication Date
4-1991
Abstract

An efficient semantic query optimization algorithm is proposed, in which all possible transformations are tentatively applied to the query. Instead of physically modifying the query, the transformation process classifies the predicates into imperative, optional or redundant. At the end of the transformation process, all the imperative predicates are retained while the redundant predicates are eliminated. Optional predicates are retrained or discarded based on the estimated cost/benefit of retaining them. The issue of the grouping of semantic constraints to reduce the overhead of retrieving constraints and checking whether each constraint is relevant to the current query is also addressed. Based on the proposed algorithm, a prototype semantic query optimizer has been built and preliminary experiments show that the optimizer performs well for large databases.

ISBN
9780818621383
Identifier
10.1109/ICDE.1991.131480
Publisher
IEEE Computer Society
City or Country
Los Alamitos, CA
Copyright Owner and License
Authors
Creative Commons License
Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International
Additional URL
http://doi.org/10.1109/ICDE.1991.131480
Citation Information
Hwee Hwa PANG, Hongjun LU and Beng Chin LU. "An Efficient Semantic Query Optimization Algorithm" Proceedings of the 7th IEEE International Conference on Data Engineering (ICDE): April 8-12, 1991, Kobe, Japan (1991) p. 326 - 335
Available at: http://works.bepress.com/hweehwa-pang/8/