Generating free redundancy XML documents from non normalized 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 non normalized relational views to XML documents using flat-based that causes data redundancy which leads to ge...
| Main Authors: | , , , |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
IEEE
2008
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/43118/1/Generating%20free%20redundancy%20XML%20documents%20from%20non%20normalized%20relational%20views%20using%20a%20statistically%20approach.pdf |
| _version_ | 1825929296616620032 |
|---|---|
| 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 |
| collection | UPM |
| 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 non normalized 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 reduce the redundancy for the XML documents that are generated from non normalized 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 document based on the blocks that are created according to frequency of the data values for the first column which has the most frequent of the data values. |
| first_indexed | 2024-03-06T08:54:43Z |
| format | Conference or Workshop Item |
| id | upm.eprints-43118 |
| institution | Universiti Putra Malaysia |
| language | English |
| last_indexed | 2024-03-06T08:54:43Z |
| publishDate | 2008 |
| publisher | IEEE |
| record_format | dspace |
| spelling | upm.eprints-431182016-05-18T02:51:32Z http://psasir.upm.edu.my/id/eprint/43118/ Generating free redundancy XML documents from non normalized 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 non normalized 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 reduce the redundancy for the XML documents that are generated from non normalized 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 document based on the blocks that are created according to frequency of the data values for the first column which has the most frequent of the data values. IEEE 2008 Conference or Workshop Item PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/43118/1/Generating%20free%20redundancy%20XML%20documents%20from%20non%20normalized%20relational%20views%20using%20a%20statistically%20approach.pdf Ahmed, Mohammed Nasser and Ibrahim, Hamidah and Mamat, Ali and Sulaiman, Md. Nasir (2008) Generating free redundancy XML documents from non normalized relational views using a statistically approach. In: 3rd International Conference on Information and Communication Technologies: from Theory to Applications, 7-11 Apr. 2008, Damascus, Syria. . 10.1109/ICTTA.2008.4530131 |
| spellingShingle | Ahmed, Mohammed Nasser Ibrahim, Hamidah Mamat, Ali Sulaiman, Md. Nasir Generating free redundancy XML documents from non normalized relational views using a statistically approach |
| title | Generating free redundancy XML documents from non normalized relational views using a statistically approach |
| title_full | Generating free redundancy XML documents from non normalized relational views using a statistically approach |
| title_fullStr | Generating free redundancy XML documents from non normalized relational views using a statistically approach |
| title_full_unstemmed | Generating free redundancy XML documents from non normalized relational views using a statistically approach |
| title_short | Generating free redundancy XML documents from non normalized relational views using a statistically approach |
| title_sort | generating free redundancy xml documents from non normalized relational views using a statistically approach |
| url | http://psasir.upm.edu.my/id/eprint/43118/1/Generating%20free%20redundancy%20XML%20documents%20from%20non%20normalized%20relational%20views%20using%20a%20statistically%20approach.pdf |
| work_keys_str_mv | AT ahmedmohammednasser generatingfreeredundancyxmldocumentsfromnonnormalizedrelationalviewsusingastatisticallyapproach AT ibrahimhamidah generatingfreeredundancyxmldocumentsfromnonnormalizedrelationalviewsusingastatisticallyapproach AT mamatali generatingfreeredundancyxmldocumentsfromnonnormalizedrelationalviewsusingastatisticallyapproach AT sulaimanmdnasir generatingfreeredundancyxmldocumentsfromnonnormalizedrelationalviewsusingastatisticallyapproach |