Generating nested XML documents from unnormalized relational views using a statistically approach
Converting relational database into XML is increasing daily for publishing and exchanging the business applications data on the Web. Most of the current approaches and products convert the unnormalized relational views to XML documents using flat-based that causes data redundancy which leads to gene...
| Main Authors: | , , , |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
IEEE
2008
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/43097/ http://psasir.upm.edu.my/id/eprint/43097/1/Generating%20nested%20XML%20documents%20from%20unnormalized%20relational%20views%20using%20a%20statistically%20approach.pdf |
| _version_ | 1848850136990482432 |
|---|---|
| author | Ahmed, Mohammed Nasser Ibrahim, Hamidah Mamat, Ali Sulaiman, Md. Nasir |
| author_facet | Ahmed, Mohammed Nasser Ibrahim, Hamidah Mamat, Ali Sulaiman, Md. Nasir |
| author_sort | Ahmed, Mohammed Nasser |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | Converting relational database into XML is increasing daily for publishing and exchanging the business applications data on the Web. Most of the current approaches and products convert the unnormalized relational views to XML documents using flat-based that causes data redundancy which leads to generate a massive data. This paper proposes an approach to generate nested XML documents with full automatic from flat relational views. The proposed approach includes two steps: the first is extracting the nested view from the flat relational view using a statistically approach for counting and removing the data redundancy. The statistically approach is based on the analysis of functional dependency taking into account the frequency of the data values for the columns of the relational views. The second step is converting the nested view into nested XML. The columns of the nested view are also divided into groups to achieve the nesting for XML document. The proposed approach generates nested XML documents from the unnormalized relational views with full automatic. The generated nested XML document by the proposed approach has good features such as minimal redundancy and less size of storage. |
| first_indexed | 2025-11-15T10:01:30Z |
| format | Conference or Workshop Item |
| id | upm-43097 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T10:01:30Z |
| publishDate | 2008 |
| publisher | IEEE |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-430972016-05-18T01:36:15Z http://psasir.upm.edu.my/id/eprint/43097/ Generating nested XML documents from unnormalized relational views using a statistically approach Ahmed, Mohammed Nasser Ibrahim, Hamidah Mamat, Ali Sulaiman, Md. Nasir Converting relational database into XML is increasing daily for publishing and exchanging the business applications data on the Web. Most of the current approaches and products convert the unnormalized relational views to XML documents using flat-based that causes data redundancy which leads to generate a massive data. This paper proposes an approach to generate nested XML documents with full automatic from flat relational views. The proposed approach includes two steps: the first is extracting the nested view from the flat relational view using a statistically approach for counting and removing the data redundancy. The statistically approach is based on the analysis of functional dependency taking into account the frequency of the data values for the columns of the relational views. The second step is converting the nested view into nested XML. The columns of the nested view are also divided into groups to achieve the nesting for XML document. The proposed approach generates nested XML documents from the unnormalized relational views with full automatic. The generated nested XML document by the proposed approach has good features such as minimal redundancy and less size of storage. IEEE 2008 Conference or Workshop Item PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/43097/1/Generating%20nested%20XML%20documents%20from%20unnormalized%20relational%20views%20using%20a%20statistically%20approach.pdf Ahmed, Mohammed Nasser and Ibrahim, Hamidah and Mamat, Ali and Sulaiman, Md. Nasir (2008) Generating nested XML documents from unnormalized relational views using a statistically approach. In: International Conference on Computer and Communication Engineering 2008 (ICCCE08), 13-15 May 2008, Kuala Lumpur, Malaysia. (pp. 843-848). 10.1109/ICCCE.2008.4580724 |
| spellingShingle | Ahmed, Mohammed Nasser Ibrahim, Hamidah Mamat, Ali Sulaiman, Md. Nasir Generating nested XML documents from unnormalized relational views using a statistically approach |
| title | Generating nested XML documents from unnormalized relational views using a statistically approach |
| title_full | Generating nested XML documents from unnormalized relational views using a statistically approach |
| title_fullStr | Generating nested XML documents from unnormalized relational views using a statistically approach |
| title_full_unstemmed | Generating nested XML documents from unnormalized relational views using a statistically approach |
| title_short | Generating nested XML documents from unnormalized relational views using a statistically approach |
| title_sort | generating nested xml documents from unnormalized relational views using a statistically approach |
| url | http://psasir.upm.edu.my/id/eprint/43097/ http://psasir.upm.edu.my/id/eprint/43097/ http://psasir.upm.edu.my/id/eprint/43097/1/Generating%20nested%20XML%20documents%20from%20unnormalized%20relational%20views%20using%20a%20statistically%20approach.pdf |