Open Access Open Access  Restricted Access Subscription Access

XR-Gine: A Simulation Engine for Performance Evaluation on XML Enabled Databases


Affiliations
1 Department of Computing and Informatics, Jalan Multimedia, Cyberjaya – 63100, Malaysia
 

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.
User

Abstract Views: 131

PDF Views: 0




  • XR-Gine: A Simulation Engine for Performance Evaluation on XML Enabled Databases

Abstract Views: 131  |  PDF Views: 0

Authors

Su-Cheng Haw
Department of Computing and Informatics, Jalan Multimedia, Cyberjaya – 63100, Malaysia
Qing-Feng Ang
Department of Computing and Informatics, Jalan Multimedia, Cyberjaya – 63100, Malaysia

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.



DOI: https://doi.org/10.17485/ijst%2F2016%2Fv9i48%2F139193