MODELING DIMENSIONS IN THE XDW MODEL - A LVM-Driven Approach

R. Rajugan, Elizabeth Chang, Tharam S. Dillon

Abstract

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. 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 our previous work, we proposed a Layered View Model (LVM) driven, conceptual modeling framework for the design and development of an XML Document Warehouse (XDW) model with emphasis on conceptual and logical semantics. There, we presented a view-driven framework to conceptually model and deploy meaningful XML FACT repositories in the XDW model. Here, in this paper, we look at the hierarchical dimensions and their theoretical semantics used to design, specify and define dimensions over an XML FACT repository in the XDW model. One of the unique properties of this LVM-driven approach is that the dimensions are considered as first-class citizens of the XDW conceptual model. Also, here, to illustrate our concepts, we use a real-world case study example; a logically grouped, geographically dispersed, XDW model in the context of a global logistics and cold-storage company.

References

  1. Abelló, A, Samos, J & Saltor, F 2001, 'Understanding facts in a multidimensional object-oriented model', 4th Int. Workshop on DW and OLAP (DOLAP 7801).
  2. Chang, E, et al., T 2003, 'A Virtual Logistics Network and an e-Hub as a Competitive Approach for Small to Medium Size Companies', 2nd Human.Society@Internet Conf., Korea, pp. 265-71.
  3. Dillon, TS & Tan, PL 1993, Object-Oriented Conceptual Modeling, Prentice Hall, Australia.
  4. ECM-AIIM 2005, The ECM Association, AIIM, http://www.aiim.org.
  5. Elmasri, R & Navathe, S 2004, Fundamentals of database systems, 4th edn, Pearson/Addison Wesley, New York.
  6. Fankhauser, P & Klement, T 2003, 'XML for Data Warehousing Changes & Challenges', DaWaK 2003, Springer, Prague, pp. 1-3.
  7. Feng, L & Dillon, TS 2003, 'Using Fuzzy Linguistic Representations to Provide Explanatory Semantics for Data Warehouses', IEEE Trans. on Knowledge and Data Engineering (TOKDE), vol. 15(1), pp. 86-102
  8. Giovinazzo, WA 2000, Object-oriented data warehouse design : building a star schema, Prentice Hall PTR, Prentice-Hall Int., Upper Saddle River, N.J. London.
  9. Golfarelli, M, Rizzi, S & Vrdoljak, B 2001, 'Data warehouse design from XML sources', Proc. of the 4th ACM Int. workshop on Data warehousing and OLAP, ACM Press, Atlanta, Georgia, USA, pp. 40 - 7.
  10. Gopalkrishnan, V, Li, Q & Karlapalem, K 1999, 'Star/Snow-flake Schema Driven Object-Relational Data Warehouse Design and Query Processing Strategies', (DaWaK 7899), Springer, Florence Italy.
  11. Gray, P & Watson, HJ 1998, Decision Support in The Data Warehouse, Prentice Hall PTR, USA.
  12. Gupta, A, Mumick, IS & (eds) 1999, Materialized views: techniques, implementations, and applications, eds A Gupta & IS Mumick, MIT Press.
  13. Humphries, M, Hawkins, MW & Dy, MC 1999, Data Warehousing: Architecture & Implementation, Prentice Hall PTR, USA.
  14. Inmon, WH, Imhoff, C & Battas, G 1996, Building the operational data store, John Wiley & Sons, NY, USA.
  15. ITEC 2002, iPower Logistics (http://www.logistics.cbs.curtin.edu.au/), viewed 2005.
  16. Jeong, E & Hsu, C-N 2001, 'Introduction of Integrated View for XML Data with Heterogenous DTDs', Proc. of the 10th Int. Conf. on Information and Knowledge Management (CIKM 7801), ACM, US, pp. 151-8.
  17. Kimball, R & Caserta, J 2004, The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data, Wiley, Hoboken, NJ.
  18. Kimball, R & Ross, M 2002, The data warehouse toolkit : the complete guide to dimensional modeling, 2nd edn, Wiley, New York.
  19. Lucie-Xyleme 2001, 'Xyleme: A Dynamic Warehouse for XML Data of the Web', IDEAS 7801, eds ME Adiba, C Collet & BC Desai, IEEE Computer Society 2001, Grenoble, France, pp. 3-7.
  20. Luján-Mora, S & Trujillo, J 2004, 'A Data Warehouse Engineering Process', Third ADVIS 7804, SpringerVerlag GmbH, Izmir, Turkey, p. 14.
  21. Lujan-Mora, S, Trujillo, J & Song, I-Y 2002a, 'Extending the UML for Multidimensional Modeling', Fifth Int. Conf. on the Unified Modeling Language and its applications (UML 7802), Springer-Verlag London, UK, Dresden, Germany, pp. 290-304.
  22. Lujan-Mora, et al., 2002b, 'Multidimensional Modeling with UML Package Diagrams', Proc. of the 21st Int. Conf. on Conceptual Modeling (ER 7802), SpringerVerlag UK, pp. 199-213.
  23. Luján-Mora, et al., 2004, 'Advantages of UML for Multidimensional Modeling', Proc. of the 6th Int. Conf. on ICEIS 7804, Porto, Portugal, April.
  24. Luján-Mora, S, Vassiliadis, P & Trujillo, J 2004, 'Data Mapping Diagrams for Data Warehouse Design with UML', 23rd Int. Conf. on Conceptual Modeling (ER 7804), vol. 3288, Shanghai, China, p. 191.
  25. Medina, E, et al., J 2002, 'Handling Conceptual Multidimensional Models Using XML through DTDs', Proc. of the 19th British National Conf. on Databases: Advances in Dbs, vol. 2405, Springer, pp. 66 - 9.
  26. Mohammed, S 2001, 'Object-Relational Data Warehouse', Master by Coursework (Major Thesis) thesis, La Trobe University, Melbourne, Australia.
  27. Mohania, MK, Karlapalem, K & Kambayashi, Y 1999, 'Data Warehouse Design and Maintenance through View Normalization', 10th Int. DEXA 7899, vol. 1677, Springer, Florence, Italy, pp. 747-50.
  28. Nassis, V, Dillon, TS, R.Rajugan & Rahayu, W 2006, 'An XML Document Warehouse Model', The 11th Int. Conf. on Database Systems for Advanced Applications (DASFAA 7806), Springer, Singapore, pp. 513-29.
  29. Nassis, V, Dillon, TS, Rahayu, W & R.Rajugan 2006, 'Goal-Oriented Requirement Engineering for XML Document Warehouses', in J Darmont & O Boussaid (eds), Processing and Managing Complex Data for Decision Support, Idea Group Publishing, pp. 28-62.
  30. Nassis, V, R.Rajugan, Dillon, TS & Rahayu, JW 2005a, 'A Requirement Engineering Approach for Designing XML-View Driven, XML Document Warehouses', COMPSAC 7805, IEEE CS, Scotland, pp. 388-95.
  31. Nassis, V, R.Rajugan, Dillon, TS & Rahayu, W 2005b, 'Conceptual and Systematic Design Approach for XML Document Warehouses', Int. Journal of Data Warehousing and Mining, vol. 1(3), no. 3, pp. 63-87
  32. Nunamaker, JF, Chen, JM & Purdin, TDM 1991, 'System Development in Information Systems Research', Journal of Mgmt. of IS, vol. 7(3), pp. 89-106
  33. OMG-CWM 2001, The Common Warehouse Metamodel (http://www.omg.org/technology/cwm/), OMG, 2005.
  34. OMG-MDA 2003, The Architecture of Choice for a Changing World®, MDA Guide Version 1.0.1 (http://www.omg.org/mda/), OMG, 2005.
  35. OMG-MOF™ 2003, Meta-Object Facility (MOF™), 1.4 (http://www.omg.org/technology/documents/modeling _spec_catalog.htm#MOF), OMG, 2005.
  36. Pokorn'y, J 2002, 'XML Data Warehouse: Modelling and Querying', Proc. of the Baltic Conf. (BalticDB-IS 7802).
  37. R.Rajugan 2006, 'A Layered View Model for XML with Conceptual and Logical Extension, and its Applications', PhD thesis, University of Technology, Sydney (UTS), Australia, Sydney.
  38. R.Rajugan, Chang, E & Dillon, TS 2005, 'Conceptual Design of an XML-View Driven, Global XML FACT Repository for XML Document Warehouses', 1st Int. Workshop on Data Management in Global Data Repositories (GRep 7805), held in conjunction DEXA 7805, IEEE CS, Copenhagen, Denmark, pp. 1139 - 44.
  39. R.Rajugan, Chang, E, Dillon, TS & Feng, L 2005, 'A Three-Layered XML View Model: A Practical Approach', 24th Int. Conf. on Conceptual Modeling (ER 7805), Springer-Verlag, Austria, pp. 79-95.
  40. R.Rajugan, et al., 2006, 'Modeling Views in the Layered View Model for XML Using UML', Int. Journal of Web Information Systems (IJWIS), Troubador Publisher Ltd., vol. 2(2), pp. 95-117, June 2006.
  41. Rahayu, W, Dillon, TS, Mohammed, S & Taniar, D 2001, 'Object-Relational Star Schemas', 13th IASTED Int. PDCS 7801, IASTED, LA, USA.
  42. Theodoratos, D & Sellis, T 1999, 'Dynamic Data Warehouse Design', 1st DaWak 7899, Springer, Italy, pp. 1-10.
  43. Trujillo, J, et al., 2003, 'Applying UML For Designing Multidimensional Databases And OLAP Applications. 13-3678, Advanced Topics in Database Research, Idea Group Publication, vol. 2, pp. 13-36
  44. Trujillo, J, Palomar, M, Gomez, J & Song, I-Y 2001, 'Designing Data Warehouses with OO Conceptual Models', IEEE Computer Society, "Computer", December, 2001, pp. 66-75.
  45. W3C-XML 2004, Extensible Markup Language (XML) 1.0, (http://www.w3.org/XML/), The World Wide Web Consortium (W3C).
  46. Xyleme 2001, Xyleme Project (http://www.xyleme.com/).
Download


Paper Citation


in Harvard Style

Rajugan R., Chang E. and S. Dillon T. (2007). MODELING DIMENSIONS IN THE XDW MODEL - A LVM-Driven Approach . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 60-70. DOI: 10.5220/0002372700600070


in Bibtex Style

@conference{iceis07,
author={R. Rajugan and Elizabeth Chang and Tharam S. Dillon},
title={MODELING DIMENSIONS IN THE XDW MODEL - A LVM-Driven Approach},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={60-70},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002372700600070},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - MODELING DIMENSIONS IN THE XDW MODEL - A LVM-Driven Approach
SN - 978-972-8865-88-7
AU - Rajugan R.
AU - Chang E.
AU - S. Dillon T.
PY - 2007
SP - 60
EP - 70
DO - 10.5220/0002372700600070