The week's pick
Random Articles
Reseach Article
Implementing Semantic Query Optimization in Relational Databases
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 52 - Number 9 |
| Year of Publication: 2012 |
| Authors: Jyoti Mor, Indu Kashyap, R. K. Rathy |
10.5120/8234-1395
|
Jyoti Mor, Indu Kashyap, R. K. Rathy . Implementing Semantic Query Optimization in Relational Databases. International Journal of Computer Applications. 52, 9 ( August 2012), 41-46. DOI=10.5120/8234-1395
Abstract
Semantic query optimization is applied to relational databases using the inductive learning approach. This approach generates an alternate query using the learning framework and the algorithm. The alternate query should be semantically equivalent to original query. The semantically equivalent query generated should be less expensive than the original query. These can be implemented in SQL using the SQL hints. These hints allow user to implement the desired plan for the query.
References
- Bruno Nicolas, Chaudhuri Surajit and Ravishankar Ramamurthy, "Power Hints for Query Optimization"; In Proceedings of the International Conference on Data Engineering (ICDE), IEEE, 2009.
- Cardiff J, "The Use of Integrity Constraints to Perform Query Transformations in Relational Databases"; Proc. PARBASG 90, IEEE Computer Society Press, 1990.
- Cardiff J. and M. Orlowska, "A Geometric Approach to Semantic Query Optimisation in Relational Databases"; Proc. of the Fifth Int. Symposium on Methodologies for Intelligent Systems, Elsevier Publishing Co. , 1990.
- Carlos Ordonez, "Optimization of Linear Recursive Queries in SQL"; IEEE Transactions on Knowledge and Data Engineering, Vol. 22, No. 2, page(s): 264-277, February 2010.
- Hsu C. and C. A. Knoblock, "Rule induction for semantic query optimization"; In Proc. 11th International Conference on Machine Learning, pages 112–120, Morgan Kaufmann, 1994.
- Hsu C. and C. A. Knoblock, "Semantic query optimization for query plans of heterogeneous multidatabase systems"; Knowledge and Data Engineering, 12(6):959–978, 2000.
- Hsu C. and C. A. Knoblock, "Using inductive learning to generate rules for semantic query optimization"; In Advances in Knowledge Discovery and Data Mining, pages 425–445. 1996.
- Kumar P. Mohan and J. Vaideeswaran, "Semantic based Efficient Cache Mechanism for Database Query Optimization"; International Journal of Computer Applications Volume 43– No. 23, page(s): 14-18, April 2012.
- Panus Jan and Josef Pirkl, "Testing of Oracle database utilization"; International Journal of Applied Mathematics and Informatics, Issue 3, Vol. 4, page(s): 58-65, 2010.
- Saini Mayank, Sharma Dharmendar and P. K. Gupta, "Enhancing Information Retrieval Efficiency Using Semantic-based-Combined-Similarity-Measure"; International Conference on Image Information Processing (ICIIP 2011), IEEE Computer Society, 2011.
- Taniar D. , Khaw H. Y. , Tjioe H. C. and J. W. Rahayu, "The use of hints in object-relational query optimization"; International Journal of Computer Systems Science and Engineering 19(6), page(s): 337-346, 2004.
- Wang Xiaoyun and Jiayin Liu, "A query optimization based on semantic user focus"; First International Workshop on Database Technology and Applications, IEEE Computer Society, 2009.
Index Terms
Keywords