DaWaK 2004: Data Warehousing and Knowledge Discovery pp 1-14 | Cite as
Conceptual Design of XML Document Warehouses
Abstract
EXtensible Markup Language (XML) has emerged as the dominant standard in describing and exchanging data among heterogeneous data sources. XML with its self-describing hierarchical structure and its associated XML Schema (XSD) provides the flexibility and the manipulative power needed to accommodate complex, disconnected, heterogeneous data. The issue of large volume of data appearing deserves investigating XML Document Warehouses. But due to XML’s non-scalar, set-based semi-structured nature, traditional data design models lack the ability to represent XML design level constructs in an abstract and implementation-independent form which are crucial for designing complex domains such as data marts and data warehouses, but also during their operational and maintenance phase. We utilize Object Oriented (OO) concepts to develop a conceptual model for XML Document Warehouses. In this paper we propose a conceptual design formalism to build meaningful XML Document Warehouses (XDW). Our focus includes; (1) conceptually design and build meaningful XML (warehouse) repository (xFACT) using OO concepts in integration with XML Schema constructs, (2) conceptually model and design virtual dimensions using XML conceptual views [10a] [10b] to satisfy warehouse end-user requirements and (3) use UML package diagrams to help logically group and build hierarchical conceptual views to enhance semantics and expressiveness of the XDW.
Preview
Unable to display preview. Download preview PDF.
References
- 1.Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model: A Conceptual Model for Data Warehouses. Int. Journal of Cooperative Information Systems (Invited Proceeding), 7-2-3 (1998)Google Scholar
- 2.Dillon, T.S., Tan, P.L.: Object-Oriented Conceptual Modeling. Prentice Hall, Australia (1993)Google Scholar
- 3.Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, 3rd edn. Addison-Wesley, Reading (2000)Google Scholar
- 4.Feng, L., Dillon, T., Chang, E.: A Semantic Network Based Design Methodology for XML Documents. ACM Trans. on Info. Sys. 20(4), 390–421 (2002)CrossRefGoogle Scholar
- 5.Fankhauser, P., Klement, T.: XML for Data Warehousing Changes & Challenges. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2003. LNCS, vol. 2737, pp. 1–3. Springer, Heidelberg (2003)CrossRefGoogle Scholar
- 6.Feng, L., Chang, E., Dillon, T.: Schemata Transformation of Object-Oriented Conceptual Models to XML. Int. Jou. of Com. Sys Sci & Eng. 18(1), 45–60 (2003)Google Scholar
- 7.Trujillo, J., Palomar, M., Gomez, J., Song, I.-Y.: Designing Data Warehouses with OO Conceptual Models. Computer (12), IEEE Computer Society, 66–75 (2001)Google Scholar
- 8.Lujan-Mora, S., Trujillo, J., Song, I.-Y.: Multidimensional Modeling with UML Package Diagrams. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds.) ER 2002. LNCS, vol. 2503, pp. 199–213. Springer, Heidelberg (2002)CrossRefGoogle Scholar
- 9.Lujan-Mora, S., Trujillo, J., Song, I.-Y.: Extending the UML for Multidimensional Modeling. In: Jézéquel, J.-M., Hussmann, H., Cook, S. (eds.) UML 2002. LNCS, vol. 2460, pp. 290–304. Springer, Heidelberg (2002)Google Scholar
- 10.Rahayu, J.W., Dillon, T.S., Mohammad, S., Taniar, D.: Object-Relational Star Schemas. In: Proc. of the 13th IASTED Int. Conf. Parallel and Distributed Comp. & Sys, PDCS 2001 (2001)Google Scholar
- 11.Rajugan, R., Chang Thram, E., Dillon, S., Feng, L.: XML Views: Part I. In: Mařík, V., Štěpánková, O., Retschitzegger, W. (eds.) DEXA 2003. LNCS, vol. 2736, pp. 148–159. Springer, Heidelberg (2003)CrossRefGoogle Scholar
- 12.Rajugan, R., Chang Thram, E., Dillon, S., Feng, L.: XML Views, Part II: Modeling Conceptual Views Using XMSemantic Nets (to be submitted)Google Scholar
- 13.Kimbal, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd edn. Wiley Computer Publishing, Chichester (2002)Google Scholar
- 14.OMG, Unified Modeling Language Specification (March 2003), Ver 1.5 formal/03-03-01, http://www.omg.org/technology/documents/formal/uml.htm
- 15.W3C Consortium, EXtensible Markup Languagees (2000), http://www.w3.org/XML/;
- 16.W3C Consortium, XML Query (XQuery) Requirements (November 2003), http://www.w3.org/TR/xqueryrequirements/
- 17.W3C Consortium, XML Schema May 2 (2001), http://www.w3c.org/XML/Schema;
- 18.Xyleme Project, Publications, http://www.xyleme.com/
- 19.OMG, Data Warehousing, CWMTM and MOFTM Resource Page http://www.omg.org/cwm/
- 20.Abelló, A., Samos, J., Saltor, F.: Understanding Facts in a Multidimensional Object-Oriented Model. In: 4th Int. Wrks.on DW and OLAP (DOLAP 2001), Atlanta, November 2001, pp. 32–39 (2001)Google Scholar
- 21.Rahayu, W.S., Chang, E.S., et al.: Aggregation versus Association in Object Modeling and Databases. In: ACS Conf. on IS, Australian Computer Society Inc., vol. 2, pp. 521–532.Google Scholar
- 22.Coad, P., Yourdon, E.: Object-oriented Analysis. Prentice-Hall, Englewood Cliffs (1991)Google Scholar
- 23.Zhang, J., Ling, T.W., Bruckner, R.M.: Building XML Data Warehouse Based on Frequent Patterns in User Queries. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2003. LNCS, vol. 2737, pp. 99–108. Springer, Heidelberg (2003)CrossRefGoogle Scholar
- 24.Pokorny, J.: XML Data Warehouse: Modelling and Querying, pp. 67–80. Kluwer Academic Publishers, The Netherlands (2002)Google Scholar
- 25.Xiaou, R., Dillon, T.S., Chang, E., Feng, L.: Modeling and Transformation of Object-Oriented Conceptual Models into XML Schema. In: Mayr, H.C., Lazanský, J., Quirchmayr, G., Vogel, P. (eds.) DEXA 2001. LNCS, vol. 2113, pp. 795–804. Springer, Heidelberg (2001)CrossRefGoogle Scholar