Conceptual Design of an XML FACT Repository for Dispersed XML Document Warehouses and XML Marts

Since the introduction of extensible Markup Language (XML), XML repositories have gained a foothold in many global (and government) organizations, where, e-commerce and e-business models have maturated in handling daily transactional data among heterogeneous information systems in multi-data formats. Due to this, the amount of data available for enterprise decision-making process is increasing exponentially and are being stored and/or communicated in XML. This presents an interesting challenge to investigate models, frameworks and techniques for organizing and analyzing such voluminous, yet distributed XML documents for business intelligence in the form of XML warehouse repositories and XML marts. In this paper, we address such an issue, where we propose a view-driven approach for modeling and designing of a Global XML FACT (GxFACT) repository under the MDA initiatives. Here we propose the GxFACT using logically grouped, geographically dispersed, XML document warehouses and Document Marts in a global enterprise setting. To deal with organizations' evolving decision-making needs, we also provide three design strategies for building and managing of such GxFACT in the context of modeling of further hierarchical dimensions and/or global document warehouses

[1]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[2]  D. P. Barnes,et al.  Behaviour decisions for co-operant mobile robots , 1991 .

[3]  Tharam S. Dillon,et al.  Object-Oriented Conceptual Modeling , 1993 .

[4]  Ramez Elmasri,et al.  Fundamentals of database systems (2nd ed.) , 1994 .

[5]  W. H. Inmon,et al.  Building the Operational Data Store , 1995 .

[6]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[7]  Paul Gray,et al.  Decision support in the data warehouse , 1997 .

[8]  Neilson Thomas Debevoise The data warehouse method: integrated data warehouse support environments , 1999 .

[9]  Timos K. Sellis,et al.  Dynamic Data Warehouse Design , 1999, DaWaK.

[10]  Qing Li,et al.  Star/Snow-Flake Schema Driven Object-Relational Data Warehouse - Design and Query Processing Strategies , 1999, DaWaK.

[11]  Mukesh K. Mohania,et al.  Data Warehouse Design and Maintenance through View Normalization , 1999, DEXA.

[12]  Ashish Gupta,et al.  Materialized views: techniques, implementations, and applications , 1999 .

[13]  Rainer Eckstein,et al.  XML Conceptual Modeling Using UML , 2000, ER.

[14]  José Samos,et al.  Understanding facts in a multidimensional object-oriented model , 2001, DOLAP '01.

[15]  Manuel Palomar,et al.  Designing Data Warehouses with OO Conceptual Models , 2001, Computer.

[16]  David Taniar,et al.  Object-relational star schemas , 2001 .

[17]  M. Hascoet,et al.  Xyleme, a dynamic warehouse for XML data of the Web , 2001, Proceedings 2001 International Database Engineering and Applications Symposium.

[18]  Tharam S. Dillon,et al.  Modeling and Transformation of Object-Oriented Conceptual Models into XML Schema , 2001, DEXA.

[19]  Paulraj Ponniah,et al.  Data warehousing fundamentals : a comprehensive guide for IT professionals , 2001 .

[20]  Boris Vrdoljak,et al.  Data warehouse design from XML sources , 2001, DOLAP '01.

[21]  Walid G. Aref,et al.  Digital government security infrastructure design challenges , 2001 .

[22]  A dynamic warehouse for XML Data of the Web , 2001, IEEE Data Eng. Bull..

[23]  Tharam S. Dillon,et al.  Mapping object relationships into XML Schema , 2001, OOPSLA 2001.

[24]  Jaroslav Pokorný XML Data Warehouse: Modelling and Querying , 2002, BalticDB&IS.

[25]  Il-Yeol Song,et al.  Multidimensional Modeling with UML Package Diagrams , 2002, ER.

[26]  Tharam S. Dillon,et al.  A semantic network-based design methodology for XML documents , 2002, TOIS.

[27]  Juan Trujillo,et al.  Handling Conceptual Multidimensional Models Using XML through DTDs , 2002, BNCOD.

[28]  Serge Abiteboul,et al.  The Xyleme project , 2002, Comput. Networks.

[29]  Sergio Luján-Mora,et al.  Extending the UML for Multidimensional Modeling , 2002, UML.

[30]  Theodore Johnson,et al.  Data warehousing , 2002 .

[31]  Tharam S. Dillon,et al.  XML Views: Part 1 , 2003, DEXA.

[32]  Tharam S. Dillon,et al.  T. Kapnoullas, A Virtual Logistics Network and an E-hub as a Competitive Approach for Small to Medium Size Companies , 2003, Human.Society@Internet 2003.

[33]  Peter Fankhauser,et al.  XML for Data Warehousing Chances and Challenges: (Extended Abstract) , 2003, DaWaK.

[34]  Tadeusz Morzy,et al.  Handbook on Data Management in Information Systems , 2003, International Handbooks on Information Systems.

[35]  Il-Yeol Song,et al.  Applying UML For Designing Multidimensional Databases And OLAP Applications , 2003, Advanced Topics in Database Research, Vol. 2.

[36]  Tharam S. Dillon,et al.  Schemata transformation of object-oriented conceptual models to XML , 2003, Comput. Syst. Sci. Eng..

[37]  Juan Trujillo,et al.  A UML Based Approach for Modeling ETL Processes in Data Warehouses , 2003, ER.

[38]  Tharam S. Dillon,et al.  Using Fuzzy Linguistic Representations to Provide Explanatory Semantics for Data Warehouses , 2003, IEEE Trans. Knowl. Data Eng..

[39]  J. Wenny Rahayu,et al.  Conceptual Design of XML Document Warehouses , 2004, DaWaK.

[40]  Ralph Kimball,et al.  The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data , 2004 .

[41]  Panos Vassiliadis,et al.  Advantages of UML for Multidimensional Modeling , 2004, ICEIS.

[42]  Panos Vassiliadis,et al.  Data Mapping Diagrams for Data Warehouse Design with UML , 2004, ER.

[43]  T.S. Dillon,et al.  Semantic modeling of e-solutions using a view formalism with conceptual & logical extensions , 2005, INDIN '05. 2005 3rd IEEE International Conference on Industrial Informatics, 2005..

[44]  J. Wenny Rahayu,et al.  Conceptual and Systematic Design Approach for XML Document Warehouses , 2005, Int. J. Data Warehous. Min..

[45]  E. Chang,et al.  A Layered View Model for Xml Repositories & Xml Data Warehouses , 2005 .

[46]  Tharam S. Dillon,et al.  Conceptual design of an XML-view driven, Global XML FACT repository for XML document warehouses , 2005, 16th International Workshop on Database and Expert Systems Applications (DEXA'05).

[47]  J. Wenny Rahayu,et al.  A Systematic Design Approach for XML-View Driven Web Document Warehouses , 2005, ICCSA.

[48]  Tharam S. Dillon,et al.  A Three-Layered XML View Model: A Practical Approach , 2005, ER.

[49]  Tharam S. Dillon,et al.  A Layered View Model for XML Repositories and XML Data Warehouses , 2005, The Fifth International Conference on Computer and Information Technology (CIT'05).