Measuring transaction performance based on storage approaches of Native XML database
Many organizations today store their critical business information permanently in XML format. XML data can be managed using: XML-Enabled Database (XED) systems which convert and store XML files in traditional database systems; Native XML Database (NXD) systems which store XML data natively using thr...
| Main Authors: | , , , |
|---|---|
| Format: | Article |
| Published: |
Elsevier
2018
|
| Subjects: |
| _version_ | 1796961412647485440 |
|---|---|
| author | Marjani, Mohsen Nasaruddin, Fariza Hanum Gani, Abdullah Shamshirband, Shahaboddin |
| author_facet | Marjani, Mohsen Nasaruddin, Fariza Hanum Gani, Abdullah Shamshirband, Shahaboddin |
| author_sort | Marjani, Mohsen |
| collection | UM |
| description | Many organizations today store their critical business information permanently in XML format. XML data can be managed using: XML-Enabled Database (XED) systems which convert and store XML files in traditional database systems; Native XML Database (NXD) systems which store XML data natively using three main storage technologies – text-based, model-based, and schema-based techniques; and Hybrid Database systems which are comprised of both XML-Enabled and Native XML database systems. NXDs are faster than other database technologies because there is no need to convert the format of the data prior to storage. No performance evaluation has been carried out to compare all three storage strategies, hence, this paper reports on the first attempt to evaluate all three storage strategies by using open source products to measure the response time taken for each of the database basic tasks such as database creation, dataset insertion, and data manipulation. The results of the evaluation show that the schema-based storage strategy: performs 3.5 times faster than the other two storage techniques in data insertion; shows very good performance in query processing on small and large datasets; performs 10.33 times faster than text-based, and 7.5 times faster than model-based storage techniques in query processing of large datasets. |
| first_indexed | 2024-03-06T05:53:51Z |
| format | Article |
| id | um.eprints-21334 |
| institution | Universiti Malaya |
| last_indexed | 2024-03-06T05:53:51Z |
| publishDate | 2018 |
| publisher | Elsevier |
| record_format | dspace |
| spelling | um.eprints-213342019-05-27T07:20:19Z http://eprints.um.edu.my/21334/ Measuring transaction performance based on storage approaches of Native XML database Marjani, Mohsen Nasaruddin, Fariza Hanum Gani, Abdullah Shamshirband, Shahaboddin QA75 Electronic computers. Computer science Many organizations today store their critical business information permanently in XML format. XML data can be managed using: XML-Enabled Database (XED) systems which convert and store XML files in traditional database systems; Native XML Database (NXD) systems which store XML data natively using three main storage technologies – text-based, model-based, and schema-based techniques; and Hybrid Database systems which are comprised of both XML-Enabled and Native XML database systems. NXDs are faster than other database technologies because there is no need to convert the format of the data prior to storage. No performance evaluation has been carried out to compare all three storage strategies, hence, this paper reports on the first attempt to evaluate all three storage strategies by using open source products to measure the response time taken for each of the database basic tasks such as database creation, dataset insertion, and data manipulation. The results of the evaluation show that the schema-based storage strategy: performs 3.5 times faster than the other two storage techniques in data insertion; shows very good performance in query processing on small and large datasets; performs 10.33 times faster than text-based, and 7.5 times faster than model-based storage techniques in query processing of large datasets. Elsevier 2018 Article PeerReviewed Marjani, Mohsen and Nasaruddin, Fariza Hanum and Gani, Abdullah and Shamshirband, Shahaboddin (2018) Measuring transaction performance based on storage approaches of Native XML database. Measurement, 114. pp. 91-101. ISSN 0263-2241, DOI https://doi.org/10.1016/j.measurement.2017.09.028 <https://doi.org/10.1016/j.measurement.2017.09.028>. https://doi.org/10.1016/j.measurement.2017.09.028 doi:10.1016/j.measurement.2017.09.028 |
| spellingShingle | QA75 Electronic computers. Computer science Marjani, Mohsen Nasaruddin, Fariza Hanum Gani, Abdullah Shamshirband, Shahaboddin Measuring transaction performance based on storage approaches of Native XML database |
| title | Measuring transaction performance based on storage approaches of Native XML database |
| title_full | Measuring transaction performance based on storage approaches of Native XML database |
| title_fullStr | Measuring transaction performance based on storage approaches of Native XML database |
| title_full_unstemmed | Measuring transaction performance based on storage approaches of Native XML database |
| title_short | Measuring transaction performance based on storage approaches of Native XML database |
| title_sort | measuring transaction performance based on storage approaches of native xml database |
| topic | QA75 Electronic computers. Computer science |
| work_keys_str_mv | AT marjanimohsen measuringtransactionperformancebasedonstorageapproachesofnativexmldatabase AT nasaruddinfarizahanum measuringtransactionperformancebasedonstorageapproachesofnativexmldatabase AT ganiabdullah measuringtransactionperformancebasedonstorageapproachesofnativexmldatabase AT shamshirbandshahaboddin measuringtransactionperformancebasedonstorageapproachesofnativexmldatabase |