Ahlem Nabli, Ahlem Soussi, Jamel Feki, Hanêne Ben Abdallah, Faïez Gargouri


The Data Warehouse design involves the definition of structures that enable an efficient access to information. The designer builds a multidimensional structure taking into account the users requirements. In fact, it is a highly complex engineering task that calls for a methodological support. This paper lays the grounds for an automatic, stepwise approach for the generation of data warehouse and data mart schemes. For this, it first proposes a standard format for OLAP requirement acquisition. Secondly, it defines an algorithm that transforms automatically the OLAP requirements into data marts modelled either as star or constellation schemes. Thirdly, it overviews our mapping rules between the data sources and the data marts schemes.


  1. Abell' A., Samios J., Saltor F., 2001. Understandding Analysis Dimensions in a Multidimensional ObjectOriented Model. DMDW 01, Interlaken, Switzerland, June 4.
  2. Boehnlein, M., Ulbrich-vom Ende, A., 1999. Deriving the Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information System. DOLAP'99, USA.
  3. Bonifati A., Cattaneo F., Ceri S., Fuggetta A., Paraboschi S., 2001. Designing Data Marts for Data Warehouses. ACM Transactions on Software Engineering Methodology.
  4. Cabibbo, LTorlone, R., 1998. A logical Approch to Multidimensional Databases. EDBT'98, Spain.
  5. Feki J., 2004. Vers une conception automatisée des entrepôts de données : Modélisation des besoins OLAP et génération de schémas multidimensionnels. 8th MCSEAI, 9-12 Mai, Souse-Tunisie.
  6. Golfarelli M., Rizzi S., 1999. Designing the Data Warehouse : Key Steps and Crucial Issues. Journal of Computer Science and Information Manegement, vol. 2, n°3, p. 1-14.
  7. Golfarelli, M., Maio, D., Rizzi, S.,1998. Conceptual Design of Data Warehouses from E/R Schemes. HICSS'98, IEEE, Hawaii.
  8. Hahn K., Sapia C., Blaschka M., 2000. Automatically Generating OLAP Schemes from Conceptual Graphical Models. DOLAP'00, USA.
  9. Hüsemann B., Lechtenbörger J., Vossen G., 2000. Conceptual Data Warehouse Design. DMDW'00, Sweden.
  10. Kimball, R., 1996. The Datawarehouse Toolkit. John Wiley & Son, Inc.
  11. Lehner W., 1998. Modeling Large Scale OLAP Scenarios. 6th International Conference on Extending Database Technology (EDBT'98), Valence (Espagne), 23-27 Mars.
  12. Marotta A., Ruggia R., 2002. Data Warehouse Design: A schema-transformation approach. SCCC'2002. Chile.
  13. Moody D., Kortnik M., 2000. From Enterprise Models to Dimensionals Models: A Methodology for Data Warehouse and Data Mart Design. DMDW'00, Sweden.
  14. Nabli A., Feki J., Gargouri F., 2005. Automatic Construction of Multidimensional Schema from OLAP Requirements. AICCSA'05, 3-6 January, Cairo, Egypt.
  15. Peralta V., Marotta A., Ruggia R., 2003. Towards the Automation of Data Warehouse Design. Technical Report. Universidad de la República, Uruguay.
  16. Phipps C., Davis K., 2002. Automating data warehouse conceptual schema design and evaluation. DMDW'02, Canada,
  17. Tryfona N., Busborg F., and Christiansen J. G. B., 1999. StarER: A Conceptual Model for Data Warehouse Design. Proceedings of the ACM DOLAP99 Workshop, Missouri, November 2-6.

Paper Citation

in Harvard Style

Nabli A., Soussi A., Feki J., Ben Abdallah H. and Gargouri F. (2005). TOWARDS AN AUTOMATIC DATA MART DESIGN . In Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-19-8, pages 226-231. DOI: 10.5220/0002520702260231

in Bibtex Style

author={Ahlem Nabli and Ahlem Soussi and Jamel Feki and Hanêne Ben Abdallah and Faïez Gargouri},
booktitle={Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,},

in EndNote Style

JO - Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,
SN - 972-8865-19-8
AU - Nabli A.
AU - Soussi A.
AU - Feki J.
AU - Ben Abdallah H.
AU - Gargouri F.
PY - 2005
SP - 226
EP - 231
DO - 10.5220/0002520702260231