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
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.