Indian Journal of Science and Technology

Abstract

Background/Objectives: Since most of the enterprises are still using relational database as the back-end database, XML Enabled Database (XED) plays an important role to ensure the seamless integration of XML technology via the relational database. Methods/Statistical analysis: In this paper, we will compare the features supported in XED product, namely Microsoft SQL Server, Oracle and IBM DB2. In order to do so, we propose and develop XR-Gine to measure the performance of these storages. Findings: Some of the performance comparisons include speed of storing, retrieving, and updating functions in the database approaches. Based on the results obtained, the best performance of storing evaluation is Oracle. On the other hand, in terms of query retrieval, Microsoft SQL Server outperforms especially in supporting huge datasets, which is a necessity with the overwhelming data produced across the web nowadays. Application/Improvements: The results generated by the engine are beneficial to aid the community to choose the appropriate XED database system.

Keywords: Benchmarking, Data Storage, Native XML Database, Performance Evaluation, Query Evaluation