Automating the Conceptual Modeling of Data Warehouse in Information System ERP Type
DOI:
https://doi.org/10.14738/tmlai.54.3330Keywords:
ERP, data warehouse, OLAP, MDA, reducing, Genetic Algorithm, Multiple Corresponding Analysis.Abstract
An information system type ERP (enterpriseresources planning) aims to control the information flow and ensure the integrity of unique repository. However, the strategic level of thisorganization is looking to note a knowledge for vocation to decide and forecast. This feasible with the introduction of the business intelligence, which allowing storing historical data and organized in storage space: datawarehouse (DWH), reduced to data mart (DM) that are an extract of the DWH adopted to a specific use, it is modelled for OLAP (on line analytical processing) analyses.
This article is part of a critical study, about the three Data Warehouse design approaches, in order to make the best approach adaptable to an ERP database. On the order hand, to study the proposals of the automation of the phases of the design of the warehouse.
References
(1) Atigui F., Ravat F., Teste O., Zurfluh G., Démarche dirigée par les modèles pour la conception d'entrepôts de données multidimensionnelles. 26éme Journées des Bases de données Avancées BDA, Toulouse, 2010.
(2) Bonifati A., Cattaneo F., Ceri S., Fuggetta A., et Paraboschi S. « Designing Data Marts for Data Warehouse », ACM Transactions on Software Engineering and Methodology, vol. 10(4), p. 452-483. Octobre 2001
(3) Davenport, Thomas H. « Putting the enterprise into the enterprise system ». Harvard business review 76 (4). 1998
(4) Feki J., Hachaichi Y. Du relationnel au multidimensionnel : Conception de magasins de données. Sfax, janvier 2007.
(5) Giorgini P., Rizzi S. et Garzetti M., Goal-oriented
requirement analysis for data warehouse design. ACM International Workshop on Data Warehousing and OLAP (DOLAP’05), p. 47-56. Bremen, Novembre 4-5, 2005.
(6) HÜSEMANN B., LECHTENBÖRGER J. et VOSSEN G., Conceptual data warehouse modeling. 2nd international Workshop on Design and Management of Data Warehouse (DMDW’00), p. 6.1 – 6.11, Vol. 28, Suède, June, 2000.
(7) KIMBALL R. The Data Warehouse Toolkit : Practical Techniques for Building Dimensional Data Warehouses. New York, 374 p, 1996
(8) Lequeux. 1999. Manager avec les ERP. Editions d'Organisation.
(9) Pang C., Taylor, K., Zhang, X. et Cameron, M. Generating Multidimensional Schemata from Relational Aggregation Queries. pp. 584–589, 2004.
(10) Phipps, C., Davis K., Automating data warehouse conceptual schema design and evaluation. 4th International Workshop on Design and Management of Data Warehouse (DMDW’02), p. 23-32, Canada. May 272002.
(11) Pinet. F, et Schneider. M., A Unified Object Constraint Model for Designing and Implementing Multidimensional Systems. Journal on Data Semantics XIII, pp. 37-71, 2009
(12) Prat N., J. Akoka, I. Comyn-Wattiau. “A UML-based data warehouse design method”, Decision Support System, Vol.42(3), p. 1449-1473, 2006.
(13) Ravat F. Modèles et outils pour la conception et la manipulation de systèmes d'aide à la décision. Université des Sciences Sociales, Toulouse, décembre 2007.
(14) Ravat F., Teste O., Tournier R., G. Zurfluh. « Querying Multidimensional Data bases ». 11th East-European Conferance on Advances in Databases and Information Systems (ADBIS’07) p.298-313, Varna, septembre 2007.
(15) Reix, Robert, Bernard Fallery, Michel Kalika, et Frantz Rowe. Systèmes d’information et management des organisations. 6e édition. Paris. 2011
(16) Romero. O, et Abelló. A. 2010. Automatic validation of requirements to support multidimensional design. Data & Knowledge Engineering. Pp. 917-942, Septembre 2010.
(17) Semeh B., NAOUALI S., Reducing the multidimensionality of OLAP cubes with Genetic Algorithms and Multiple Correspondence Analysis. The International Conference on Advanced Wireless, Information, and Communication Technologies (AWICT 2015). Pp 452 – 459. 2015
(18) Soussi A., Feki, J., Gargouri. F. Approche semi-automatisée de conception de schémas multidimensionnels valides, Journée Entrepôts de Données et l’Analyse en ligne (EDA’05), Revue des Nouvelles Technologies de l’Information, RNTI-B-1, Cépadues, P71-90. Juin 2005.
