CFP last date
20 May 2024
Call for Paper
June Edition
IJCA solicits high quality original research papers for the upcoming June edition of the journal. The last date of research paper submission is 20 May 2024

Submit your paper
Know more
The week's pick
Responsive image
Enhancing Privacy Preservation: Multi-Attribute Protection with P-Sensitive K-Anonymity

Twinkle Patel Kiran Amin
Random Articles
Reseach Article

Designing of the CASE Tool to develop Star Schema using the XML Schema consisting of Clinical Data

by Anita Nagar, Gunjan Chandwani
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 104 - Number 2
Year of Publication: 2014
Authors: Anita Nagar, Gunjan Chandwani
10.5120/18173-9060

Anita Nagar, Gunjan Chandwani . Designing of the CASE Tool to develop Star Schema using the XML Schema consisting of Clinical Data. International Journal of Computer Applications. 104, 2 ( October 2014), 12-16. DOI=10.5120/18173-9060

@article{ 10.5120/18173-9060,
author = { Anita Nagar, Gunjan Chandwani },
title = { Designing of the CASE Tool to develop Star Schema using the XML Schema consisting of Clinical Data },
journal = { International Journal of Computer Applications },
issue_date = { October 2014 },
volume = { 104 },
number = { 2 },
month = { October },
year = { 2014 },
issn = { 0975-8887 },
pages = { 12-16 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume104/number2/18173-9060/ },
doi = { 10.5120/18173-9060 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:35:06.121150+05:30
%A Anita Nagar
%A Gunjan Chandwani
%T Designing of the CASE Tool to develop Star Schema using the XML Schema consisting of Clinical Data
%J International Journal of Computer Applications
%@ 0975-8887
%V 104
%N 2
%P 12-16
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Data Warehouse is most widely used for data analysis which supports the management's decision making process. The sources for the Data Warehouse are commonly taken from the online transactional systems in various formats. XML is one of the standard format used to represent and transport the data in web based systems. XML allows easy sharing of data between different internet applications which enhances the decision making in organizations. This paper focuses on conversion method of XML Schema into the Star and Snowflake schema.

References
  1. Soumya Sen, Ranak Ghosh, Debanjali Paul, Nabendu Chaki; "Integrating Related XML Data into Multiple Data Warehouse Schemas"; Proc. of the First International Conference on Information
  2. Sarbani Dasgupta, Soumya Sen, Nabendu Chaki; "A Framework To Convert XML Schema to ROLAP"; Proc. of 2nd Intl. Conf. on Emerging Applications of Information Technology, 2011.
  3. Yuan Sun; Hexin Chen; Mianshu Chen; Xinying Wang; Aijun Sang; "Multi-dimension Multimedia Retrieval Model Implementation Based on XML Database" International Conference on Signal Processing Systems, 2009.
  4. Rajugan, R. ; Chang, E. ; Dillon, T. S. ; "Conceptual Design of an XML FACT Repository for Dispersed XML Document Warehouses and XML Marts", 5th International Conference on Computer and Information Technology, 2005.
  5. Tim Bray, Jean Paoli, C. M. Sperberg-McQueen, Eve Maler, François Yergeau; "Extensible Markup Language (XML) 1. 0 (Fifth Edition)"; W3C Recommendation; www. w3. org/TR/RECxml.
  6. Parimala N and Payel pahwa; "From XML schema to cube" International Journal of Computer Theory and Engineering; Vol. 1, No 3 August 2009.
  7. Boris Vrdoljak, Marko Banek, and Stefano Rizzi: Designing Web Warehouses from XMLSchemasY. Kambayashi, M. Mohania, W. Wöß (Eds. ): LNCS 2737, pp. 89-98, 2003
  8. Wolfgang Hummer, Andreas Bauer, Gunnar Harde: XCube – XML for Data Warehouses, DOLAP'03, November 7, 2003, USA.
  9. M. Golfarelli, S. Rizzi, and B. Vrdoljak, . Data warehouse design from XML sources. , Proc. DOLAP'01, Atlanta, pp. 40-47, 2001.
  10. Data Mining Concepts and Technique,2nd Edition, Jiawei Han and Micheline Kamber, Morgan Kaufmann Publisher.
  11. Payel pahwa and Parimala N; "Conceptual design of data warehouses from xml schemas" 2nd International Conference on Intellectual Capital, knowledge management & Organizational Learning 21-22 Nov, 2005 American University of Dubai, United Arab Emirates.
  12. M. Jensen, T. Møller, and T. B. Pedersen, . Specifying OLAP Cubes On XML Data. , Journal of Intelligent Information Systems, 2001.
  13. Ramanath, M. ; Kumar, K. S. ; "A rank-rewrite framework for summarizing XML documents" 24th International Conference on Data Engineering Workshop, ICDEW 2008
  14. Rajugan, R. ; Chang, E. ; Dillon, T. S. ; "Conceptual Design of an XML FACT Repository for Dispersed XML Document Warehouses and XML Marts", 5th International Conference on Computer and Information Technology, 2005.
  15. Belen Vela; Carlos Blanco; Eduardo Fernandez; E. Marcos "Model Driven Development of Secure XML Data Warehouses: A Case Study". EDBT 2010, Lausanne, Switzerland.
Index Terms

Computer Science
Information Sciences

Keywords

Warehouse Schema Schema graph Elements XML Schema Fact table and dimension table.

Powered by PhDFocusTM