IADIS International Journal on Computer Science and Information Systems

Published by IADIS (International Association for Development of the Information Society) • ISSN (Online): 1646-3692 • ISSN (Print): 1646-3692
100% Open Access
Double-Blind Peer Review
Crossref DOI Persistent IDs
Open Access Peer-Reviewed Foundational Models & Architectures

Adaptive Storage Model for Xml in Object-relational Databases

Michael Kamel. Dept. of Computer *
Systems Engineering *
Faculty of Engineering *
Alexandria Researcher *
* University, Egypt. Elshatby, Alexandria, Egypt. mkamel@alex.edu.eg Khaled Nagi. Dept. of Computer and Systems Engineering, Faculty of Engineering, Alexandria University, Egypt. Elshatby, Alexandria, Egypt. knagi@alex.edu.eg Nagwa El-Makky. Dept. of Computer and Systems Engineering, Faculty of Engineering, Alexandria University, Egypt. Elshatby, Alexandria, Egypt. nagwamakky@alex.edu.eg (Portugal)
* University, Egypt. Elshatby, Alexandria, Egypt. mkamel@alex.edu.eg Khaled Nagi. Dept. of Computer and Systems Engineering, Faculty of Engineering, Alexandria University, Egypt. Elshatby, Alexandria, Egypt. knagi@alex.edu.eg Nagwa El-Makky. Dept. of Computer and Systems Engineering, Faculty of Engineering, Alexandria University, Egypt. Elshatby, Alexandria, Egypt. nagwamakky@alex.edu.eg (Portugal)
* University, Egypt. Elshatby, Alexandria, Egypt. mkamel@alex.edu.eg Khaled Nagi. Dept. of Computer and Systems Engineering, Faculty of Engineering, Alexandria University, Egypt. Elshatby, Alexandria, Egypt. knagi@alex.edu.eg Nagwa El-Makky. Dept. of Computer and Systems Engineering, Faculty of Engineering, Alexandria University, Egypt. Elshatby, Alexandria, Egypt. nagwamakky@alex.edu.eg (Portugal)
* University, Egypt. Elshatby, Alexandria, Egypt. mkamel@alex.edu.eg Khaled Nagi. Dept. of Computer and Systems Engineering, Faculty of Engineering, Alexandria University, Egypt. Elshatby, Alexandria, Egypt. knagi@alex.edu.eg Nagwa El-Makky. Dept. of Computer and Systems Engineering, Faculty of Engineering, Alexandria University, Egypt. Elshatby, Alexandria, Egypt. nagwamakky@alex.edu.eg (Portugal)

Abstract

Object relational database management systems (ORDBMS) are becoming more popular in storing and retrieving XML than native XML DBMS. In most ORDBMS, XML is stored as CLOB inside the relation. Efficient XML parsers a nd indexing techniques are used to retrieve the desired XML nodes. However, less attention is given to XML updates queries. With the upcoming standa rdization of XML updates queries, the current implementation of the lock granularity imposes a great limitation on the concurrency of parallel transactions. This motivat ed several experimental ORDBMS to shred the XML nodes across internal relations. This approach has also several drawbacks. In this paper, we propose an adaptive technique for selective shredding. It is based on existing database engines and takes the changes in the workload pattern into consideration. We an alyze the performance of our approach and compare it to the CLOB and the complete shredding approaches.

Keywords

XML storage models data shredding techniques ORDBMS performance analysis.
Full-Text PDF Available

Read Complete Peer-Reviewed Manuscript

Includes full econometric models, data tables, policy recommendations, declarations, and citations.

Declarations & Ethics

Funding: This research received academic dissemination support through ESCAP / JournalsHub publishing programs.
Conflicts of Interest: The authors declare no competing financial or institutional interests.
Peer Review: Double-blind peer reviewed by international subject specialists.
License: Creative Commons Attribution 4.0 International (CC BY 4.0).
How to Cite This Article
APA / MLA / BibTeX
Computer, et al. (2009). Adaptive Storage Model for Xml in Object-relational Databases. IADIS International Journal on Computer Science and Information Systems, 4(2). https://doi.org/10.33965/ijcsis_2009_v4i2_05
Computer, et al. "Adaptive Storage Model for Xml in Object-relational Databases." IADIS International Journal on Computer Science and Information Systems, vol. 4, no. 2, 2009. https://doi.org/10.33965/ijcsis_2009_v4i2_05
Computer, et al. "Adaptive Storage Model for Xml in Object-relational Databases." IADIS International Journal on Computer Science and Information Systems 4, no. 2 (2009). https://doi.org/10.33965/ijcsis_2009_v4i2_05