Automating the Choice of Decision Support System Architecture

  • Estella Annoni
  • Franck Ravat
  • Olivier Teste
  • Gilles Zurfluh
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4080)


Due to the wide-spread use of decision support systems (DSS), methods are required by software companies. Several concepts and methods have been suggested for decision-making. The development of DSS is still complex due to the variety of architectures, the number and the type of modules which compose them.

Therefore, This paper present our method of DSS development, which is based on an architecture of 1 to 4 levels, focusing on the choice of an adapted architecture (composed of data warehouses and data marts). Our method is based on a mixed approach integrating the assessment of existing sources and user requirements. These are taken into account from the early step of DSS engineering, e.g. from the analysis step, so DSS architecture choice integrates them.


Decision Support System User Requirement Business Group Data Warehouse Architecture Choice 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., Paraboschi, S.: Designing data marts for data warehouses. ACM Trans. Softw. Eng. Methodol. 10(4), 452–483 (2001)CrossRefGoogle Scholar
  2. 2.
    Trujillo, J., Palomar, M., Gomez, J., Song, I.Y.: Designing data warehouses with OO conceptual models. Computer 34(12), 66–75 (2001)CrossRefGoogle Scholar
  3. 3.
    Sen, A., Sinha, A.P.: A comparison of data warehousing methodologies. Commun. ACM 48(3), 79–84 (2005)CrossRefMathSciNetGoogle Scholar
  4. 4.
    Luján-Mora, S., Trujillo, J.: A comprehensive method for data warehouse design. In: DMDW (2003)Google Scholar
  5. 5.
    Golfarelli, M., Rizzi, S., Saltarelli, E.: Wand: A case tool for workload-based design of a data mart. In: SEBD, pp. 422–426 (2002)Google Scholar
  6. 6.
    Kimball, R.: The data warehouse toolkit: practical techniques for building dimensional data warehouses. John Wiley & Sons, Inc., New York (1996)Google Scholar
  7. 7.
    Cabibbo, L., Torlone, R.: A Logical Approach to Multidimensional Databases. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 155–162. Springer, Heidelberg (1998)CrossRefGoogle Scholar
  8. 8.
    Golfarelli, M., Rizzi, S.: Methodological framework for data warehouse design. In: Proceedings of DOLAP 1998, ACM First International Workshop on Data Warehousing and OLAP, Bethesda, Maryland, USA, November 7, 1998, pp. 3–9. ACM, New York (1998)CrossRefGoogle Scholar
  9. 9.
    Kimball, R., Reeves, L., Thornthwaite, W., Ross, M., Thornwaite, W.: The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing. John Wiley & Sons, Inc., New York (1998)Google Scholar
  10. 10.
    Akoka, J., Comyn-Wattiau, I., Prat, N.: From uml to rolap multidimensional databases using a pivot model. Technical report (2001)Google Scholar
  11. 11.
    Cavero, J.M., Costilla, C., Marcos, E., Piattini, M.G., Sánchez, A.: A multidimensional data warehouse development methodology, 188–201 (2003)Google Scholar
  12. 12.
    Bruckner, R., List, B., Schiefer, J.: Developping requirements for data warehouse systems with use cases. In: AMCIS (1999)Google Scholar
  13. 13.
    Roques, P.: UML in Practice - The Art of Modeling Software Systems Demonstrated Through Worked Examples and Solutions. John Wiley & Sons, Inc., New York (2003)Google Scholar
  14. 14.
    Annoni, E., Ravat, F., Teste, O., Zurfluh, G.: Les systèmes d’informations décisionnels: une approche d’analyse et de conception à base de patrons. revue RSTI série ISI, Méthodes Avancées de Développement des SI 10(6) (2005)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Estella Annoni
    • 1
  • Franck Ravat
    • 1
  • Olivier Teste
    • 1
  • Gilles Zurfluh
    • 1
  1. 1.IRIT-SIG (UMR 5505) InstituteUniversity of Paul SabatierToulouse

Personalised recommendations