Performance Evaluation of Native XML Database and XML Enabled Database

S. Balamurugan, A. Ayyasamy
2017 International Journal of Advanced Research in Computer Science and Software Engineering  
Now-a-days, there is a authentic need for a database system for storing, retrieving and manipulate XML based data to the purpose of exchange data over the web with an efficient manner. XML provides a noteworthy boost to web-based and business-to-business (B2B) applications. Data were normally stored in relational databases and XML was used as a medium to transport data between web-based and business-to-business (B2B) applications. XML quickly became the de facto standard for deploying
more » ... ns that managed large volumes of data and either wanted to be able to communicate with other businesses or to expose their data on the web. The paper helps to explore and compare between the performance of XML-based database and native XML database. This model was supported by XML-enabled databases (XEDs), which adopted a simple strategy to store XML data: each XML document is decomposed and its data are stored within tables. The fundamental difference between XEDs and NXDs is that the latter adopt the XML data model for storing XML data. Much like hierarchical and object databases, they are able to preserve the hierarchy and ordering of nodes of XML documents in a much more efficient manner than XMLenabled databases, hence the tremendous performance improvement in handling large XML documents. XML Data provides a new approach to data management, which positively impact many organization manage and exchange information. A database is that can be treated as either a Native XML Database or as an XML Enabled Database depending on the requirements of the application. II. XML-ENABLED DATABASES The need to support XML data storage, retrieval and update by utilizing existing database systems, along with their well-established technologies, is the main reason that the solution of the XML-enabling layer over the RDBMS [11] was adopted. This extra software layer contains extensions for transferring data between XML documents and the data structures supported by the underlying databases. The storage methods employed by XML-enabled databases [5, 17] for XML data, along with the main features the systems provide for retrieving, converting and updating XML data are the main topics that are discussed in the sections that follow. When using an XML-enabled database, it is necessary to map the database schema to the XML schema (or vice versa). Such mappings are many-to-many. For example, a database schema for sales order information can be mapped to an XML schema for sales order documents, or it can be mapped to an XML schema for reports showing the total sales by region. There are two important kinds of mappings: (a). Table- based mapping (b). Object-relational mapping Both table-based mapping and object-relational mappings define bi-directional mappings, that is, the same mapping can be used to transfer data both to and from the database.
doi:10.23956/ijarcsse/sv7i5/0109 fatcat:ibnbh75elzaa3ny6b4dlzk2lcq