Johnson T.,Dr. M.G.R. Educational and Research Institute |
Johnson T.,Ethiraj College for Women |
Srivatsa S.K.,Prathyusha Institute of Technology and Management PITAM
ARPN Journal of Engineering and Applied Sciences | Year: 2016
The problem of query optimization has been approached in several methods but suffers with the problem of accuracy. To overcome this issue and to improve the performance of our previous solution, we propose a multi level relational mapping algorithm in this paper. The method first identifies the relational objects and generates relational maps. From the relational maps the method identifies the objects and entity of query. Based on the above the method generates different rules to perform the query and computes the dependency measure for each part of the query. The use of relational map helps to identify the query dependency according to the object and to compute the dependency measure for each of the rule being produced. Finally a subset of dependency rule is produced as a result and the method improve the performance of rule generation and improves the performance of query optimization by scheduling the execution of query parts efficiently. © 2006-2016 Asian Research Publishing Network (ARPN).