Abstract
The complexity of data warehouse models based on the entity-relationship-model was one of the biggest driving forces behind multidimensional modelling. Designed models should be easily understood by a business expert and easily analyzed by the final user. Nevertheless, the evolution of the dimensional paradigm has showed that the business world is complex and it is necessary to introduce new concepts to the models to allow a greater level of representation. These include bridge tables, heterogeneous dimensions and factless fact tables (Kimball, Ross 2002). As a result, the designed model lacks the desired simplicity and does not yet guarantee the representation of all the semantics of the domain. This paper explores an alternative design of data warehouses that allows the creation of a model that reflects in a greater proportion the semantic of the business world and that can be exploited by the final user through different analysis tools. The alternative, based on XBRL Dimensional Taxonomies (XDT), is shown through a comparison with a dimensional model and the level of semantic representation. We explore all the limitations and ease of use derived from this standard reporting language, eXtensible Business Reporting Language (XBRL). The objective is to show a dimensional and a XDT design and stressing out the semantic richness of each approach. In order to do so, the article will explore briefly the background of a dimensional understanding of a problem domain in the second section. Then it will show dimensional XBRL as a more semantically approach to model a dimensional reality in the third section. To show this, the fourth section contains an example that will be applied in a real case study.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Bauer, A.; Günzel, H. (2001): Data-Warehouse-Systeme. Architektur, Entwicklung, Anwendung, 2. Edition. dpunkt Verlag, Heidelberg.
Bulos, D. (June 1996): A New Dimension, in: Database Programming & Design, Vol. 9, No. 6, pp. 33–38.
Chamoni, P. (1998): Ausgewählte Verfahren des Data Mining. In: Chamoni, P.; Gluchowski, P. (ed.): Analytische Informationssysteme. Data Warehouse, On-Line Analytical Processing, Data Mining, Springer, Berlin [u. a.],, pp. 355–373.
Chamoni, P.; Gluchowski, P. (Ed) (1999):Analytische Informationssysteme. Data Warehouse, On-Line Analytical Processing, Data Mining, 2nd edition. Springer, Berlin [et al.].
Codd, E. F. (June 1970): A Relational Model for Large Shared Data Banks, in: Communications of the ACM, Volume 13, Nr. 6, pp. 377–387.
Devlin, B. (1997): Data Warehouse — from Architecture to Implementation. Addison Wesley, Reading (Mass.) [et al.].
Fenn, J.; Linden, A. (2005): Gartner’s Hype Cycle Special Report for 2005, Gartner Inc, http://www.gartner.com/resources/130100/130115/gartners_hype_c.pdf, downloaded on 2006-07-19.
Gabriel, R.; Gluchowski, P.(1998): Grafische Notationen für die semantische Modellierung multidimensionaler Datenstrukturen in Management Support Systemen, in: Wirtschaftsinformatik, Nr. 40, pp. 493–502.
Gluchowski, P. (1997): Data Warehouse. In: Informatik-Spektrum 20. Jahrgang, Heft 1, pp. 48–49.
Hernández-Ros, I., Wallis H. (2006): XBRL Dimensions 1.0 Candidate Recommendation, dated 2006-04-26, XBRL International, http://www.xbrl.org/Specification/XDTCR3-2006-04-26.rtf, downloaded on 2006-07-19.
Holthuis, J. (1999): Der Aufbau von Data Warehouse-Systemen-Konzeption, Datenmodellierung, Vorgehen, 2. Auflage, DUV, Wiesbaden.
Inmon, W. H. (2002): Building the Data Warehouse, 3rd edition. Wiley, New York [et al.].
Kimball, R.; Ross, M. (2002): The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd edition, John Wiley & Sons, Inc.
Lehner, W. (2003): Datenbanktechnologie für Data-Warehouse-Systeme. Konzepte und Methoden. dpunkt Verlag, Heidelberg.
Lusti, M. (2002): Data Warehousing und Data Mining. Eine Einführung in entscheidungsorientierte Systeme. 2. Edition. Springer Verlag, Berlin [et al.].
Nußdorfer, R. (1998): Neue Anforderung an die Datenmodellierung. E/R-Modellierung im Jungbrunnen, in: Datenbank Focus, Heft 10, pp. 16–19.
Poe, V.; Klauer, P.; Brobst, S. (1998): Building a data warehouse for decision support, 2nd edition, Upper Saddle River.
Raden, N. (1996): Star Schema 101. White Paper, Archer Decision Sciences Inc., Santa Barbara CA 1996, http://members.aol.com/nraden/str101.htm, downloaded on 2006-08-28.
Schlenker, U. (1998): Datenmodellierung für das Data Warehouse-Vergleich und Bewertung konzeptioneller und logischer Methoden, Juni, http://www.ub.unikonstanz.de/v13/volltexte/1999/187/pdf/187_1.pdf, downloaded 2006-07-07.
Schinzer, H.-D.; Bange, C. (1999): Werkzeuge zum Aufbau analytischer Informationssysteme, in: Chamoni, P.; Gluchowski, P. (Hrsg.): Analytische Informationssysteme-Data Warehouse, On-Line Analytical Processing, Data Mining, 2nd edition. Springer, Berlin, pp. 45–74.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2007 Deutscher Universitäts-Verlag | GWV Fachverlage GmbH, Wiesbaden
About this chapter
Cite this chapter
Felden, C. (2007). Multidimensional XBRL. In: New Dimensions of Business Reporting and XBRL. DUV. https://doi.org/10.1007/978-3-8350-9633-2_9
Download citation
DOI: https://doi.org/10.1007/978-3-8350-9633-2_9
Publisher Name: DUV
Print ISBN: 978-3-8350-0835-9
Online ISBN: 978-3-8350-9633-2
eBook Packages: Business and EconomicsBusiness and Management (R0)