XAPP: An Implementation of SAX-Based Method for Mapping XML Document to and from a

The international arab journal of information technology

article

Relational Database¹  Joshua Ayeni²  Samson Arekete²  Mba Odim² 

[1] Department of Computer Science Redeemer’s University;Department of Computer Science, Redeemer’s University

关键词: Extensible markup language;    XML document;    relational database;    reconstruction time;    mapping time;   

DOI  :  10.34028/iajit/19/4/2

学科分类：计算机科学（综合）

来源: Zarqa University

【 摘 要 】

Extensible Markup Language (XML) is the standard medium for data exchange among businesses over the Internet,hence the need for effective management. However, since XML was not designed for storage and retrieval, its management hasbecome an open research area in the database community. Existing mapping techniques for XML-to-relational database adopteither the structural mapping or the model mapping. Though numerous mapping approaches have been developed, mappingand reconstruction time had been problematic, especially when the document size is large and can hardly fit into mainmemory. In this research, an application codenamed XAPP, a new lightweight application that adopts a novel model mappingapproach was developed using Simple API for XML (SAX) parser. XAPP accepts a document with or without Document TypeDefinition (DTD). It implements two algorithms: one maps XML data to a relational database and improves mapping time,and the other reconstructs an XML document from a relational database to improve reconstruction time and minimise memoryusage. The performance of XAPP was analysed and compared with the Document Object Model (DOM) algorithm. XAPPproves to perform significantly better than the DOM-based algorithm in terms of mapping and reconstruction time, andmemory efficiency. The correctness of XAPP was also verified.

【 授权许可】

Unknown