Abstract
In the past, several approaches have been devised to semi- automate the multidimensional design (MDD) of Data Warehouse (DW) projects. Such approaches highly contribute to more expertise- independent and deterministic MDD results. Among them, only the Dimensional Templates Approach (DTA) focuses on solving the critical resource containment problems of DW prototypes.
Originally, the DTA allows solely the generation of basic MDDs. In this paper, we depict an extension to address complex MDD issues. These include (i) date/time hierarchies, (ii) many-to-many relationships, (iii) hierarchically structured data and (iv) coverage facts. The proposed enhancements, including a rebuilt generation algorithm, allow more accurate and broadening results than the original DTA. Throughout the paper, references are made to a real case study to which the improved DTA has been applied using two developed prototype tools.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. John Wiley & Sons, Inc., New York (2002)
Adelman, S., Dennis, S.: Capitalising the DW. White Paper, DMReview (2005)
Jensen, M.R., Holmgren, T., Pedersen, T.B.: Discovering Multidimensional Structure in Relational Data. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2004. LNCS, vol. 3181, pp. 138–148. Springer, Heidelberg (2004)
Song, I.Y., Khare, R., Dai, B.: SAMSTAR: a semi-automated lexical method for generating star schemas from an entity-relationship diagram. In: ACM 10th Intern. Workshop on Data Warehousing and OLAP, pp. 9–16. ACM, New York (2007)
Romero, O., Abelló, A.: Automating Multidimensional Design from Ontologies. In: ACM 10th Intern. Workshop on Data Warehousing and OLAP, pp. 1–8. ACM, New York (2007)
Phipps, C., Davis, K.C.: Automating Data Warehouse Conceptual Schema Design and Evaluation. In: 4th International Workshop on Design and Management of Data Warehouses, DMDW 2002, pp. 23–32. CEUR (2002)
Winter, R., Strauch, B.: A Method for Demand-Driven Information Requirements Analysis in Data Warehousing Projects. In: 36th Hawaii International Conference on System Sciences, HICSS 2003, pp. 1359–1365. IEEE Computer Society, Los Alamitos (2002)
Prat, N., Akoka, J., Comyn-Wattiau, I.: A UML-based Data Warehouse Design Method. Journal of Decision Support Systems 42(3), 1449–1473 (2006)
Vrdoljak, B., Banek, M., Rizzi, S.: Designing Web Warehouses from XML Schemas. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2003. LNCS, vol. 2737, pp. 89–98. Springer, Heidelberg (2003)
Giorgini, P., Rizzi, S., Garzetti, M.: GRAnD: A Goal-Oriented Approach to Requirement Analysis in Data Warehouses. Decision Support Systems 45, 18 (2008)
Mazón, J.-N., Trujillo, J.: A Model Driven Modernization Approach for Automatically Deriving Multidimensional Models in Data Warehouses. In: Parent, C., Schewe, K.-D., Storey, V.C., Thalheim, B. (eds.) ER 2007. LNCS, vol. 4801, pp. 56–71. Springer, Heidelberg (2007)
Oliveira, R., Rodrigues, F., Martins, P., Moura, J.P.: Dimensional Templates in Data Warehouses: Automating the Multidimensional Design of Data Warehouse Prototypes. In: Filipe, J., Cordeiro, J. (eds.) Enterprise Information Systems. LNBIP, vol. 24, pp. 184–195. Springer, Heidelberg (2009)
Romero, O., Abelló, A.: A Survey of Multidimensional Modeling Methodologies. International Journal of Data Warehousing & Mining 5, 1–23 (2009)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Oliveira, R., Rodrigues, F., Martins, P., Moura, J.P. (2011). Extending the Dimensional Templates Approach to Integrate Complex Multidimensional Design Concepts. In: Cuzzocrea, A., Dayal, U. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2011. Lecture Notes in Computer Science, vol 6862. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-23544-3_3
Download citation
DOI: https://doi.org/10.1007/978-3-642-23544-3_3
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-23543-6
Online ISBN: 978-3-642-23544-3
eBook Packages: Computer ScienceComputer Science (R0)