The System of XML Extraction from Relational Databases Based on Document Object Model

Abstract

EXtensible Markup Language (XML) is a self-describing meta-language and fast emerging a standard for Web data exchange among various applications. XML is also a new technology that attracts a great deal of interest and dominates some areas of information system development. Relational database is a mature technology that dominates the implementation of database system. This paper implements the irregular varies structures to regular structures and can be extracted XML document by using the table-based mapping into relational databases. It proposes the system that extracts the XML document from the data stored in the database. It provides a generalised mapping between relational databases and XML document that is based on Document Access Definition (DAD) and the tree structure of the Document Object Model (DOM). In this paper, the system is proposed for storing nodes of input XML document as a relational tuple by node numbering scheme. It reduces the redundant components of XML document, collects and stores the elements and contents according to their same paths.