CFP last date
22 April 2024
Reseach Article

SQOPI: Semantic Query Optimization Framework

by Mohamed Mounir Hassan, Ahmed Mohammed Sultan
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 96 - Number 6
Year of Publication: 2014
Authors: Mohamed Mounir Hassan, Ahmed Mohammed Sultan
10.5120/16800-6516

Mohamed Mounir Hassan, Ahmed Mohammed Sultan . SQOPI: Semantic Query Optimization Framework. International Journal of Computer Applications. 96, 6 ( June 2014), 27-32. DOI=10.5120/16800-6516

@article{ 10.5120/16800-6516,
author = { Mohamed Mounir Hassan, Ahmed Mohammed Sultan },
title = { SQOPI: Semantic Query Optimization Framework },
journal = { International Journal of Computer Applications },
issue_date = { June 2014 },
volume = { 96 },
number = { 6 },
month = { June },
year = { 2014 },
issn = { 0975-8887 },
pages = { 27-32 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume96/number6/16800-6516/ },
doi = { 10.5120/16800-6516 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:21:03.804478+05:30
%A Mohamed Mounir Hassan
%A Ahmed Mohammed Sultan
%T SQOPI: Semantic Query Optimization Framework
%J International Journal of Computer Applications
%@ 0975-8887
%V 96
%N 6
%P 27-32
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Semantic query optimization uses semantic knowledge in databases to rewrite queries and logic programs for the purpose of more efficient query evaluation. There has been a large body of work in the area of semantic query optimization. But, unfortunately, till now no commercial application of sematic query optimization techniques has received wide attention. In this paper, we address this problem by developing a unified framework (Application Programming Interface) called SQOPI that could be used by any application developer to semantically optimize queries executed against relational database regardless of DBMS type used. Our results show that SQOPI improves both time and I/O efficiency.

References
  1. U. S. Chakravarthy, J. Grant, and J. Minker, "Logic-based approach to semantic query optimization," ACM Transactions on Database Systems (TODS), vol. 15, pp. 162-207, 1990.
  2. M. Hammer and S. B. Zdonik, "Knowledge-based query processing," in Proceedings of the sixth international conference on Very Large Data Bases-Volume 6, 1980, pp. 137-147.
  3. M. Jarke, J. Clifford, and Y. Vassiliou, "An optimizing prolog front-end to a relational query system," ACM SIGMOD Record, vol. 14, pp. 296-306, 1984.
  4. J. J. King, "Quist: A system for semantic query optimization in relational databases," in Proceedings of the seventh international conference on Very Large Data Bases-Volume 7, 1981, pp. 510-517.
  5. S. T. Shenoy and Z. M. Ozsoyoglu, "Design and implementation of a semantic query optimizer," Knowledge and Data Engineering, IEEE Transactions on, vol. 1, pp. 344-361, 1989.
  6. Q. Cheng, J. Gryz, F. Koo, T. C. Leung, L. Liu, X. Qian, et al. , "Implementation of two semantic query optimization techniques in DB2 universal database," in VLDB, 1999, pp. 687-698.
  7. P. Godfrey, J. Gryz, and C. Zuzarte, "Exploiting constraint-like data characterizations in query optimization," in ACM SIGMOD Record, 2001, pp. 582-592.
  8. J. Chomicki, "Querying with intrinsic preferences," in Advances in Database Technology—EDBT 2002, ed: Springer, 2002, pp. 34-51.
  9. B. G. Lowden and J. Robinson, "Improved data retrieval using semantic transformation," in Database and Expert Systems Applications, 2004, pp. 391-400.
  10. B. G. Lowden and J. Robinson, "Constructing inter-relational rules for semantic query optimisation," in Database and Expert Systems Applications, 2002, pp. 587-596.
  11. J. Grant, J. Gryz, J. Minker, and L. Raschid, "Semantic query optimization for object databases," in Data Engineering, 1997. Proceedings. 13th International Conference on, 1997, pp. 444-453.
  12. H. H. Pang, H. J. Lu, and B. C. Ooi, "An efficient semantic query optimization algorithm," in Data Engineering, 1991. Proceedings. Seventh International Conference on, 1991, pp. 326-335.
  13. S. -C. Yoon, L. J. Henschen, E. Park, and S. Makki, "Using domain knowledge in knowledge discovery," in Proceedings of the eighth international conference on Information and knowledge management, 1999, pp. 243-250.
  14. B. Genet and G. Dobbie, "Is semantic optimisation worthwhile," in Proceedings of the 21st Australasian Computer Science Conference, pp. 245-256.
  15. X. Zhang and Z. M. Ozsoyoglu, "Implication and referential constraints: A new formal reasoning," Knowledge and Data Engineering, IEEE Transactions on, vol. 9, pp. 894-910, 1997.
  16. C. -N. Hsu and C. A. Knoblock, "Discovering robust knowledge from databases that change," Data Mining and Knowledge Discovery, vol. 2, pp. 69-95, 1998.
  17. P. Godfrey, J. Gryz, and J. Minker, Semantic query optimization for bottom-up evaluation: Springer, 1996.
  18. A. Sayli and B. Lowden, "The use of statistics in semantic query optimization," CYBERNETICS AND SYSTEMS RESEARCH, pp. 991-996, 1996.
  19. S. T. Shenoy and Z. M. Ozsoyoglu, A system for semantic query optimization vol. 16: ACM, 1987.
  20. D. K. Burleson, Practical application of object-oriented techniques to relational databases: Wiley-QED Publishing, 1994.
  21. C. J. Date, An Introduction To Database Systems, 8/E: Pearson Education India, 2006.
  22. A. C. Bloesch and T. A. Halpin, "Conceptual queries using ConQuer-II," in Conceptual Modeling—ER'97, ed: Springer, 1997, pp. 113-126.
  23. "ADO. NET Framework," http://msdn. microsoft. com/en-us/library/aa286484. aspx.
  24. B. H. Genet and A. Hinze, "Open issues in semantic query optimization in relational DBMS," 2004.
  25. T. P. P. Council, "'TPC Benchmark B," Standard Specification, Waterside Associates, Fremont, CA, 1990.
Index Terms

Computer Science
Information Sciences

Keywords

Semantic Query Optimization Query Rewrite.