Database CASE tool architecture: Principles for flexible design strategies

  • J. -L. Hainaut
  • M. Cadelli
  • B. Decuyper
  • O. Marchand
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 593)


The paper describes the architectural principles of a database CASE tool that allows more flexible design strategies than those of traditional tools that propose oversimplistic draw- and generate approaches. Providing this flexibility is based on four basic principles, namely a unique generic specification model that allows the definition of a large variety of specific design products, transformational functions as major database design tools, a toolbox architecture, allowing a maximal independence between functions, and multiple model definition through parametrization of the unique generic model. These architectural characteristics themselves derive from two fundamental paradigms, namely the process- product-requirements approach to model design behaviours, and the transformational approach to system design.


design modeling system design database design transformational approach CASE tools 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    Batini, C., Lenzerini, M., Moscarini, M., View integration, in Methodology and tools for data base design, Ceri, S., (Ed.)North-Holland, 1983Google Scholar
  2. [2]
    Dubois, E., Van Lamsweerde, A., Making Specification Processes, in Proc. of the 4th Intern. Workshop on Software Specification and Design, Monterrey (CA), April, 3–4, 1987, pp. 169–177Google Scholar
  3. [3]
    Giraudin, J-P., Delobel, C., Dardailler, P., Eléments de construction d'un système expert pour la modélisation progressive d'une base de données, in Proc. of Journées Bases de Données Avancées, Mars, 1985Google Scholar
  4. [4]
    Hainaut, J-L., Theoretical and practical tools for data base design, in Proc. of Very Large Databases, pp. 216–224, September, 1981Google Scholar
  5. [S]
    Hainaut, J.-L., A Generic Entity-Relationship Model, in Proc. of the IFIP WG 8.1 Conf. on Information System Concepts: an in-depth analysis, North-Holland, 1989.Google Scholar
  6. [6]
    Hainaut, J-L, Database Reverse Engineering, Models, Techniques and Strategies, in Proc. of the 10th Conf. on Entity-Relationship Approach, San Mateo, 1991Google Scholar
  7. [7]
    Hainaut, J-L., Entity-generating Schema Transformation for Entity-Relationship Models, in Proc. of the 10th Conf. on Entity-Relationship Approach, San Mateo, 1991Google Scholar
  8. [8]
    Johnson W. L., Cohen, D., Feather, M., Kogan, D., Myers, J., Yue, K., Balzer, R., The Knowledge-Based Spesification Assistant, Final Report, UCS/Information Sciences Institute, Marina del Tey, 19 Sept. 1988Google Scholar
  9. [9]
    Kobayashi, I., Losslessness and Semantic Correctness of Database Schema Transformation: another look of Schema Equivalence, in Information Systems, Vol. 11, No 1, pp. 41–59, January, 1986Google Scholar
  10. [10]
    Krieg-Brückner, B., Algebraic Specification and Functionals for Transformational Program and Meta Program Development, in Proc. of the TAPSOFT Conf. LNCS 352, Springer-Verlag, 1989Google Scholar
  11. [11]
    Kozaczynsky, Lilien, An extended Entity-Relationship (E2R) database specification and its automatic verification and transformation, in Proc. of Entity-Relationship Approach, 1987Google Scholar
  12. [12]
    Partsch, H., Steinbrüggen, R., Program Transformation Systems, Computing Surveys, Vol. 15, No. 3, 1983Google Scholar
  13. [13]
    Reiner, D., Brown, G., Friedell, M., Lehman, J., McKee, R., Rheingans, P., Rosenthal, A., A Database Designer's Worbench, in Proc. of Entity-Relationship Approach, 1986Google Scholar
  14. [14]
    Rosenthal, A., Reiner, D., Theoretically sound transformations for practical database design, in Proc. of Entity-Relationship Approach, 1988Google Scholar
  15. [15]
    Teorey, T. J., Database design, Prentice-Hall, 1989Google Scholar
  16. [16]
    Tardieu, H., Rochfeld, Coletti, La méthode Merise, Les Editions d'Organisation, 1983Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1992

Authors and Affiliations

  • J. -L. Hainaut
    • 1
  • M. Cadelli
    • 1
  • B. Decuyper
    • 1
  • O. Marchand
    • 1
  1. 1.Institut d'InformatiqueUniversity of NamurNamurBelgium

Personalised recommendations