Constraint preserving mapping algorithm for XML storage
The use of XML as the common format for representing, exchanging, storing, integrating and accessing data poses many new challenges to database systems. Most of application data are stored in relational databases due to its popularity and rich development experiences over it. Therefore, how to provi...
| Main Authors: | , , , |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
2006
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/59097/ http://psasir.upm.edu.my/id/eprint/59097/1/88.pdf |
| _version_ | 1848853828531650560 |
|---|---|
| author | Ahmad, Kamsuriah Mamat, Ali Ibrahim, Hamidah Mohd Noah, Shahrul Azman |
| author_facet | Ahmad, Kamsuriah Mamat, Ali Ibrahim, Hamidah Mohd Noah, Shahrul Azman |
| author_sort | Ahmad, Kamsuriah |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | The use of XML as the common format for representing, exchanging, storing, integrating and accessing data poses many new challenges to database systems. Most of application data are stored in relational databases due to its popularity and rich development experiences over it. Therefore, how to provide a proper mapping approach from XML model to relational model becomes the major research problem. The mapping from XML to relational is not an easy task because the data model of an XML document is fundamentally different from that of a relational database. Especially the structure of an XML document is hierarchy and the XML elements may be nested and repeated. So it is also useful in information exchange and data integration for preserving the semantics of data originating in XML to relational databases. Although several approaches exist, they are incomplete in the sense that they focus only on a part of constraints and ignore the constraints for XML as expressed in functional dependencies. In this paper, we propose an algorithm how to preserve these constraints while mapping from XML to relational schema. Compared with other methods, our approach can preserve more XML constraints, while reduced nesting and redundant data. |
| first_indexed | 2025-11-15T11:00:10Z |
| format | Conference or Workshop Item |
| id | upm-59097 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T11:00:10Z |
| publishDate | 2006 |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-590972018-02-22T06:40:45Z http://psasir.upm.edu.my/id/eprint/59097/ Constraint preserving mapping algorithm for XML storage Ahmad, Kamsuriah Mamat, Ali Ibrahim, Hamidah Mohd Noah, Shahrul Azman The use of XML as the common format for representing, exchanging, storing, integrating and accessing data poses many new challenges to database systems. Most of application data are stored in relational databases due to its popularity and rich development experiences over it. Therefore, how to provide a proper mapping approach from XML model to relational model becomes the major research problem. The mapping from XML to relational is not an easy task because the data model of an XML document is fundamentally different from that of a relational database. Especially the structure of an XML document is hierarchy and the XML elements may be nested and repeated. So it is also useful in information exchange and data integration for preserving the semantics of data originating in XML to relational databases. Although several approaches exist, they are incomplete in the sense that they focus only on a part of constraints and ignore the constraints for XML as expressed in functional dependencies. In this paper, we propose an algorithm how to preserve these constraints while mapping from XML to relational schema. Compared with other methods, our approach can preserve more XML constraints, while reduced nesting and redundant data. 2006 Conference or Workshop Item PeerReviewed text en http://psasir.upm.edu.my/id/eprint/59097/1/88.pdf Ahmad, Kamsuriah and Mamat, Ali and Ibrahim, Hamidah and Mohd Noah, Shahrul Azman (2006) Constraint preserving mapping algorithm for XML storage. In: International Conference on Computing and Informatics (ICOCI 2006), 6-8 June 2006, Kuala Lumpur, Malaysia. (pp. 1-8). |
| spellingShingle | Ahmad, Kamsuriah Mamat, Ali Ibrahim, Hamidah Mohd Noah, Shahrul Azman Constraint preserving mapping algorithm for XML storage |
| title | Constraint preserving mapping algorithm for XML storage |
| title_full | Constraint preserving mapping algorithm for XML storage |
| title_fullStr | Constraint preserving mapping algorithm for XML storage |
| title_full_unstemmed | Constraint preserving mapping algorithm for XML storage |
| title_short | Constraint preserving mapping algorithm for XML storage |
| title_sort | constraint preserving mapping algorithm for xml storage |
| url | http://psasir.upm.edu.my/id/eprint/59097/ http://psasir.upm.edu.my/id/eprint/59097/1/88.pdf |