An Efficient Middleware for Storing and Querying XML Data in Relational Database Management System | Science Publications

Journal of Computer Science

Mohammed A.I. Fakheraldien¹  Norrozila Sulaiman¹  Jasni M. Zain¹ 

关键词: Extensible Markup Language (XML);    relational database;    XParent;    Structured Query Language (SQL);    middleware;    Database Administrators (DBAs);   

DOI  :  10.3844/jcssp.2011.314.319

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

来源: Science Publications

【 摘 要 】

Problem statement: In this study, we propose a middleware that provides a transformationutility for storing and querying XML data in relational databases using model mapping method.Approach: To store XML documents in RDBMS, several mapping approaches can be used. Wechose structure independent approach. In this middleware the model mapping method XParent and freeof cost available technologies MYSQL, PhpMyAdmin and PHPclasses are used as examples. Results:This middleware stores XML tables and does not require a direct extension of SQL thus thismiddleware can be used with any relational databases management system with little changes in themiddleware interface. The middleware offers two alternative methods -namely XParent and XReal- forstoring XML in the database. Conclusion: The key to proposed middleware is to store XML documentin a relational database through a user interface and with an XPath query processor. We present acomparative experimental study on the performance of insertion and retrieval of two types of XMLdocuments with a set of XPath queries executed though the XPath. XML and Relational databasescannot be kept separately because XML is becoming the universal standard data format for therepresentation and exchanging the information whereas most existing data lies in RDBMS and theirpower of data capabilities cannot be degraded so the solution to this problem a middleware prototype isrequired. The proposed schema dependent solutions have a drawback that evens a small change in thelogical structure of XML documents influence on the database schemas and several problems occur duringthe updating process. A new efficient data middleware is proposed in the study to face these issues.

【 授权许可】

Unknown