Abstract
The main methodologies for the data warehouse design are based on two approaches which are opposite and alternative each other. The one, based on the data-driven approach, aims to produce a conceptual schema mainly through a reengineering process of the data sources, while minimizing the involvement of end users. The other is based on the requirement-driven approach and aims to produce a conceptual schema only on the basis of requirements expressed by end users. As each of these approaches has valuable advantages, it is emerged the necessity to adopt a hybrid methodology which combines the best features of the two approaches. We introduce a conceptual model that is based on a graph-oriented representation of the data sources. The core of the proposed hybrid methodology is constituted by an automatic process of reengineering of data sources that produces the conceptual schema using a set of requirement-derived constraints.
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
Ballard, C., Herreman, D., Schau, D., Bell, R., Kim, E., Valencic, A: Data Modeling Techniques for Data Warehousing. IBM Redbooks (1998)
Kimball, R.: The Data Warehouse Lifecycle Toolkit, 2nd edn. Practical Techniques for Building Data Warehouse and Business Intelligence Systems. John Wiley & Sons, Chichester (2008)
Romero, O., Abelló, A.: A Survey of Multidimensional Modeling Methodologies. International Journal of Data Warehousing and Mining 5(2), 1–23 (2009)
Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model: a Conceptual Model for Data Warehouses. International Journal of Cooperative Information Systems 7, 215–247 (1998)
dell’Aquila, C., Di Tria, F., Lefons, E., Tangorra, F.: Dimensional Fact Model Extension via Predicate Calculus. In: 24th International Symposium on Computer and Information Sciences, Cyprus, pp. 211–217 (2009)
dell’Aquila, C., Di Tria, F., Lefons, E., Tangorra, F.: Logic Programming for Data Warehouse Conceptual Schema Validation. In: Bach Pedersen, T., Mohania, M.K., Tjoa, A.M. (eds.) DAWAK 2010. LNCS, vol. 6263, pp. 1–12. Springer, Heidelberg (2010)
Mazón, J.N., Trujillo, J., Serrano, M., Piattini, M.: Designing Data Warehouses: from Business Requirement Analysis to Multidimensional Modeling. In: Cox, K., Dubois, E., Pigneur, Y., Bleistein, S.J., Verner, J., Davis, A.M., Wieringa, R. (eds.) Requirements Engineering for Business Need and IT Alignment. Wales Press, University of New South (2005)
Rahm, E., Bernstein, P.: A Survey of Approaches to Automatic Schema Matching. The International Journal on Very Large Data Bases 10(4), 334–350 (2001)
Atzeni, P., Cappellari, P., Torlone, R., Bernstein, P., Gianforme, G.: Model-Independent Schema Translation. The International Journal on Very Large Data Bases 17(6), 1347–1370 (2008)
Romero, O., Abelló, A.: Automating Multidimensional Design from Ontologies. In: Proceedings of the ACM 10th International Workshop on Data Warehousing and OLAP, Lisbon, Portugal, pp. 1–8 (November 9, 2007)
Spyns, P., Meersman, R., Jarrar, M.: Data Modelling versus Ontology Engineering. ACM SIGMOD Record 31(4), 12–17 (2002)
Romero, O., Abelló, A.: Multidimensional Design by Examples. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2006. LNCS, vol. 4081, pp. 85–94. Springer, Heidelberg (2006)
Carmè, A., Mazón, J.-N., Rizzi, S.: A model-driven heuristic approach for detecting multidimensional facts in relational data sources. In: Bach Pedersen, T., Mohania, M.K., Tjoa, A.M. (eds.) DAWAK 2010. LNCS, vol. 6263, pp. 13–24. Springer, Heidelberg (2010)
Golfarelli, M., Rizzi, S.: A Methodological Framework for Data Warehouse Design. In: 1st ACM International Workshop on Data Warehousing and OLAP, Washington D.C., USA, pp. 3–9 (1998)
Giorgini, P., Rizzi, S., Garzetti, M.: GRAnD: A Goal-oriented Approach to Requirement Analysis. Decision Support Systems 45(1), 4–21 (2008)
Mazón, J.N., Trujillo, J., Lechtenborger, J.: Reconciling Requirement-driven Data Warehouses with Data Sources via Multidimensional Normal Forms. Data Knowl. Eng. 63(3), 725–751 (2007)
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
Di Tria, F., Lefons, E., Tangorra, F. (2011). GrHyMM: A Graph-Oriented Hybrid Multidimensional Model. In: De Troyer, O., Bauzer Medeiros, C., Billen, R., Hallot, P., Simitsis, A., Van Mingroot, H. (eds) Advances in Conceptual Modeling. Recent Developments and New Directions. ER 2011. Lecture Notes in Computer Science, vol 6999. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-24574-9_12
Download citation
DOI: https://doi.org/10.1007/978-3-642-24574-9_12
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-24573-2
Online ISBN: 978-3-642-24574-9
eBook Packages: Computer ScienceComputer Science (R0)