An ID Based Algorithm for storing XML documents in Relational Databases.
XML has emerged as a standard for representing data over the internet. Relational Databases provides a mature Way to Store and Query these documents. XML documents can be stored either schema based or schema less in relational databases. Query Translation of XML queries in to SQL Queries is found an interesting problem for researchers. In this paper we deal with translation of XPATH query in to SQL . We provide an Algorithm which will convert XPATH in to SQL without using advanced SQL operator. This Algorithm will handle the parent-child and ancestor-descendant relationship of XPATH expression and shows how translation of these expressions in to SQL expressions occurs.
Keywords: Relational Database, XML, XPATH, SQL
Download Full-Text
ABOUT THE AUTHORS
Divyesh Sharma
She is a research scholar in department of computer science and applications.
Pushpa Suri
She is Retd. Professor from department of computer science and applications.
Divyesh Sharma
She is a research scholar in department of computer science and applications.
Pushpa Suri
She is Retd. Professor from department of computer science and applications.