A Method, a Formalism and Tools for Database Design - Three Years of Experimental Practice.

@inproceedings{DBLP:conf/er/TardieuPNH79,
  author    = {H. Tardieu and
               D. Pascot and
               Dominique Nanci and
               H. Heckroth},
  editor    = {Peter P. Chen},
  title     = {A Method, a Formalism and Tools for Database Design - Three Years
               of Experimental Practice},
  booktitle = {Entity-Relationship Approach to Systems Analysis and Design.
                Proc. 1st International Conference on the Entity-Relationship
               Approach},
  publisher = {North-Holland},
  year      = {1979},
  isbn      = {0-444-85487-8},
  pages     = {353-378},
  ee        = {db/conf/er/TardieuPNH79.html},
  crossref  = {DBLP:conf/er/79},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

This paper is intended to present three years of experimental practice using a data base design method.

This method uses a 3 model ANSI SPARC like approach.

The formalism used for the conceptual and external models is the individual formalism as formerly presented at Freudenstadt IFIP TC2 conference. The formalism used for the internal model is a subset of the CODASYL DBTG proposal.

The starting point of this method is the analysis of the perceived real world expressed in terms of an organization description, already computerized applications and planned computerized applications. The ultimate goal is the DDL schema of the chosen DBMS.

This method is supported by several tools interfaced with a data dictionnary which is a representation of the different models at the various steps of the method.

This method has been taught and used in several projects in the French government as well as in private companies.

A first evaluation is presented and proposals for future developments in the method are made.

ACM SIGMOD Anthology

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the CD and click on the path of your mount point:
  /Anthology/An2-1 or /cdrom

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the DVD and click on the path of your mount point:
  /Anthology/aDVD1 or /dvd

References

[TARDIEU H., HECKENROTH H., NANCI D.]

...

[TARDIEU H., NANCI D., HECKENROTH H., ISSADI A.]

...

[NANCI Dominique]

...

[TARDIEU Hubert, NANCI Dominique, PASCOT Daniel]

...

[MOULIN, RANDON, SPACCAPIETRA, TARDIEU, TEBOUL]

P. Moulin, J. Randon, M. Teboul, S. Savoysky, Stefano Spaccapietra, H. Tardieu: Conceptual Model as a Data Base Design Tool. IFIP Working Conference on Modelling in Data Base Management Systems 1976: 221-238 BibTeX

[TARDIEU, DEHENEFFE, HAINAUT]

...

[TARDIEU, PASCOT]

...

[LE MOIGNE Jean Louis a]

...

[LE MOIGNE Jean Louis b]

...

[LE MOIGNE Jean Louis c]

...

[LE MOIGNE Jean Louis d]

...

[LE MOIGNE Jean Louis e]

Maurice Landry, Jean-Louis Le Moigne: Towards a Theory of Organizational Information System-A General System Perspective. IFIP Congress 1977: 801-805 BibTeX

[LE MOIGNE Jean Louis f]

...

[LE MOIGNE Jean Louis g]

...

[LOSSA Serge]

...

[PASCOT Daniel]

...

[ANSI/SPARC]

...

[CHEN Peter P.S.]

Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX

[MERISE]

...

[NIJSSEN G.M.]

G. M. Nijssen: A Gross Architecture for the Next Generation Database Management System. IFIP Working Conference on Modelling in Data Base Management Systems 1976: 1-24 BibTeX

[TSICHRITZIS D.C., KLUG A.]

Dennis Tsichritzis, Anthony C. Klug: The ANSI/X3/SPARC DBMS Framework Report of the Study Group on Dabatase Management Systems. Inf. Syst. 3(3): 173-191(1978) BibTeX

[CARDENAS A.F.]

Alfonso F. Cardenas: Evaluation and Selection of File Organization - A Model and System. Commun. ACM 16(9): 540-548(1973) BibTeX

[NAKAMURA, YOSHIDA, KONDO]

...

[MIJARES, PEEBLES]

Ignacio Mijares, Richard Peebles: A Methodology for the Design of Logical Data Base Structures. IFIP Working Conference on Modelling in Data Base Management Systems 1976: 25-48 BibTeX

[BABAD J.M.]

Jair M. Babad: A Record and File Partitioning Model. Commun. ACM 20(1): 22-31(1977) BibTeX

[MILMAN Y.]

Y. Milman: An Approach to Optimal Design of Storage Parameters in Databases. Commun. ACM 20(5): 347-350(1977) BibTeX

[TEOREY, SUNDAR]

Toby J. Teorey, K. Sundar Das: Application of an Analytical Model to Evaluate Storage Structures. SIGMOD Conference 1976: 9-19 BibTeX

Referenced by

1. Arnold Rochfeld: MERISE, an Information System Design and Development Methodology, Tutorial. ER 1986: 489-528
2. Henri Briand, Henri Habrias, J.-F. Hue, Y. Simon: Expert System for Translating an E-R Diagram into Databases. ER 1985: 199-206
3. Yves Tabourier: Further Development of the Occurrences Structure Concept: The EROS Approach. ER 1983: 565-583
4. Yves Tabourier, Dominique Nanci: The Occurrence Structure Concept: An Approach to Structural Integrity Constraints in the Entity-Relationship Model, with Application to Realationship Decomposition and Metamodel Achievement. ER 1981: 73-108
5. Peter P. Chen: Recent Literature on the Entity-Relationship Approach. ER 1979: 3-12