Topic : qualitative data analysis
An analysis paper on
Storage method for XML document based on relational database
Submitted by
ABSTRACT
With the advancement of XML technology, finding a new approach for efficient XML data management is becoming increasingly vital. Since relational databases are reliable and can scale well, storing XML documents in them is a prominent issue. Novel approaches to store XML document in relational database are made. According to the suggested storage structure, an algorithm for translating an XML document to a relational database is provided which converts X path query to SQL query. In this paper, the algorithm explains how to use the storing structure to storage and query the XML document in RDBMS. Also followed by this, an example is taken to compare this novel approach to previous methods to show the efficiency of the algorithm.
INTRODUCTION
As the eXtensible Markup Language (XML) becomes more widely used in terms of transferring data on the web, additional applications such as storing and querying XML documents in the database systems are becoming available.
The existing work in this area was only to transfer XML Schema to relational database tables, but the change of the schema will result in the variety of the relational database table. With the frequent changes in XML data in the internet, storing of these values in the relational databases becomes difficult.
Previous research has shown that a file system can be utilized to store XML data with little effort, however the file system has flaws when it comes to XML data querying. Furthermore, an object-oriented database would allow clustering of XML elements and sub-elements, which could be advantageous for some applications, but the current generation of object-oriented databases is not yet sophisticated enough to assess queries on massive databases.
To store, manage, and query XML documents in a cost-effective manner becomes a critical challenge. At present, the prominent way to store XML based data is in relational database.
PROBLEM STATEMENT
With the frequent changes of XML data on the Internet, storing this kind of data in relational databases becomes challenging. The changes in the schema will result in the variety of the relational database table. A new algorithm is proposed to solve this issue and comparisons are made with the previous existing methods and showed how efficiently this approach fixes the problem.
RELATED WORK
Compression Coding of Supporting Data (CCSU) algorithm is proposed by Bing Wang in Research on the Compression Coding of Supporting Data Update Completely paper [2], which is used to store the XML data in relational databases which also compresses the structure of data. It also uses repeated information to reduce labelling lengths. Also, in Amjad Qtaish and Kamsuriah Ahmad paper [4], the model-mapping approaches are examined in terms of description, technique, and the RDB schema is generated.
FUTURE WORK
Although this proposed technique produces good results in terms of XML schema in relational databases, the response time for sql queries to retrain data from the database is high. By decreasing the search space and the amount of join operations in SQL statements, the suggested approach should optimally preserve parent–child and ancestor–descendant links among XML nodes.
CONCLUSION
Dangling tables, dangling columns, and column overhead size were all issues with XML documents stored in RDBs in terms of storage space. This will increase the amount of space required in the RDB to store XML documents. A unique storage format for XML documents using a relational database is proposed in this study. Signatures are used to replace nodes in the XML tree, and signatures are used to represent relative positions. XPath inquiries are transformed to SQL queries using relational databases, which is a mature technology.
BIBLIOGRAPHY
[1] Sun Wei, Liu Dating. Research on Query Optimization and Correlative Technologies in XML Database [D]. Harbin: Harbin Engineering University, 2006.6.
[2] Research on the Compression Coding of Supporting Data Update Completely.
[3] SMXIR: Efficient way of Storing and Managing XML Documents Using RDBMSs Based on Paths.
[4] Storing XML documents and XML policies in Relational Databases.
[5] Schema less Approach of Mapping XML Document into Relational Database.
[6] Model mapping approaches for XML Documents.