Abstract
Prototypes are valuable tools in Data Warehouse (DW) projects. DW prototypes can help end-users to get an accurate preview of a future DW system, along with its advantages and constraints. However, DW prototypes have considerably smaller development time windows when compared to complete DW projects. This puts additional pressure on the achievement of the expected prototypes’ high quality standards, especially at the highly time consuming multidimensional design: in it, a thin margin for harmful unreflected decisions exists. Some devised methods for automating DW multidimensional design can be used to accelerate this stage, yet they are more suitable to DW full projects rather than to prototypes, due to the effort, cost and expertise they require. This paper proposes the semi-automation of DW multidimensional designs using templates. We believe this approach better fits the development speed and cost constraints of DW prototyping since templates are pre-built highly adaptable and highly reusable solutions.
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
Look Before You Leap, http://www.intelligententerprise.com/010216/feat3_1.jhtml
Data Warehouse Prototyping: Reducing Risk, Securing Commitment and Improving Project Governance, http://www.wherescape.com/white-papers/white-papers.aspx
Huynh, T., Schiefer, J.: Prototyping Data Warehouse Systems. In: Kambayashi, Y., Winiwarter, W., Arikawa, M. (eds.) DaWaK 2001. LNCS, vol. 2114, pp. 195–207. Springer, Heidelberg (2001)
The Data Warehouse Budget, http://www.datawarehouse.inf.br/Papers/inmonbudget-1.pdf
Adelman, S., Dennis, S.: Capitalizing the DW (2005), http://www.dmreview.com/
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.: Goal-Oriented Requirement Analysis for Data Warehouse Design. In: DOLAP 2005, 8th International Workshop on Data Warehousing and OLAP, pp. 47–56. ACM Press, New York (2005)
Mazón, J., 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)
Song, I.Y., Khare, R., Bing, D.: SAMSTAR: A Semi-Automated Lexical Method for Generating Star Schemas from an Entity-Relationship Diagram. In: DOLAP 2007, 10th International Workshop on Data Warehousing and OLAP, pp. 9–16. ACM Press, New York (2007)
Abelló, A., Samos, J., Saltor, F.: YAM2 (Yet another multidimensional model): An extension of UML. In: International Symposium on Database Engineering & Applications. IEEE Computer Science, pp. 172–181. IEEE Computer Society, Washington (2002)
Luján-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. 265–276. Springer, Heidelberg (2002)
Romero, O., Abelló, A.: Automating Multidimensional Design from Ontologies. In: 10th International Workshop on Data Warehousing and OLAP, pp. 1–8. ACM Press, New York (2007)
Alhajj, R.: Extracting the Extended Entity-Relationship Model From a Legacy Relational Database. Information Systems 28, 597–618 (2003)
Jensen, M., 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)
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd edn. John Wiley and Sons, Inc., USA (2002)
Malinowski, E., Zimányi, E.: Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications. Springer Publishing Company, Heidelberg (2008)
Wherescape RED, http://www.wherescape.com/
Alkis Simitsis’s list of ETL tools, http://www.dbnet.ece.ntua.gr/~asimi/ETLTools.htm
Mazón, J., Pardillo, J., Trujillo, J.: A Model-Driven Goal-Oriented Requirement Engineering Approach for Data Warehouses. In: RIGIM 2007, 1st International Workshop on Requirements, Intentions and Goals in Conceptual Modeling, pp. 255–264. Springer, Heidelberg (2007)
Kimball, R., Caserta, J.: The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning,Conforming, and Delivering Data. Wiley Publishing, Inc., USA (2004)
Vetterli, T., Vaduva, A., Staudt, M.: Metadata Standards for Data Warehousing: Open Information Model vs. Common Warehouse Metamodel. ACM SIGMOD Record 29, 68–75 (2000)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Oliveira, R., Rodrigues, F., Martins, P., Moura, J.P. (2009). Dimensional Templates in Data Warehouses: Automating the Multidimensional Design of Data Warehouse Prototypes. In: Filipe, J., Cordeiro, J. (eds) Enterprise Information Systems. ICEIS 2009. Lecture Notes in Business Information Processing, vol 24. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-01347-8_16
Download citation
DOI: https://doi.org/10.1007/978-3-642-01347-8_16
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-01346-1
Online ISBN: 978-3-642-01347-8
eBook Packages: Computer ScienceComputer Science (R0)