XPND: Storing XML in Relational Database Systems Using Mapping Approach

Abstract

The Extensible Markup Language (XML) is used for representing data over the web. Database systems are well-known for consistent storage, retrieval, and manipulation of data. Storing XML documents in relational databases uses two kinds of approaches: Model mapping and Structured mapping. This paper explores a model mapping approach for storing XML data in relational database. XML documents could be easily stored in relational databases through XPND's three tables: Path table, Node table and Data table. Path table maintains path expressions. Node table stores all node ID’s along with node names. Data table stores corresponding node values in it. This paper also proposes an algorithm that shows how the nodes of the XML document are stored in terms of tables in database.