A Novel Method for XML/SQL Query Translation Using Twice Indexing With Caching Approach

SQL/XML has gained increasing interest whenever relational data has to be transformed to XML data, which is transferred, stored, or further processed in internet-based systems. The performance of query processing in a relational XML storage system is closely related to the query translation technique employed in the query mapping stage. For efficiently querying XML documents, many indexing methods have bee proposed. In this paper, the study and analysis of four approaches regarding XML/SQL query translation are focused like query translation using intelligent path deviation, query translation using interval encoding, query evaluation using double indexes and generalizing and improving SQL/XML query evaluation. Each method have its own advantage and drawbacks. This paper survey these methods and propose an efficient twice indexing with caching which provides further modification to these methods and provides efficient query processing technique.