A semantic data model as the basis for an automated database design tool

Abstract The Automated Database Design system (ADD) obtains a requirements specification from a user and translates this into a prototype relation scheme and network schema. The requirements are formulated as a Semantic Database Model[1] and the user-interface designed to permit specification by computer-naive users. This paper describes the ADD system, discusses the usefulness of data models as the basis for an automated database design tool and offers some suggestions for enhancing their suitability to such an application.

[1]  Robert C. Gammill,et al.  An interactive system for aiding management decision making , 1899, AFIPS '77.

[2]  Stewart N. T. Shen,et al.  Solving linear programming problems stated in English by computer , 1973, ACM Annual Conference.

[3]  Marvin Minsky,et al.  Semantic Information Processing , 1968 .

[4]  Terry Winograd,et al.  Understanding natural language , 1974 .

[5]  R. Gerritsen.  A preliminary system for the design of DBTG data structures , 1975, CACM.

[6]  N. Roussopoulos,et al.  Tools for designing conceptual schemata of databases , 1979 .

[7]  Michael Hammer.  Self-adaptive automatic data base design , 1977, AFIPS '77.

[8]  Sonia Berman.  The semantic database model as a basis for an automated database design tool , 1983 .

[9]  Dennis McLeod,et al.  Database description with SDM: a semantic database model , 1981, TODS.

[10]  Peter P. Chen.  The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[11]  William M. Taggart,et al.  A Survey of Information Requirements Analysis Techniques , 1977, CSUR.

[12]  Bert F. Green,et al.  Baseball: an automatic question-answerer , 1899, IRE-AIEE-ACM '61 (Western).

[13]  JACOB PALME.  A human‐computer interface for non‐computer specialists , 1979, Softw. Pract. Exp..

[14]  Philip A. Bernstein,et al.  Synthesizing third normal form relations from functional dependencies , 1976, TODS.

[15]  E. F. Codd,et al.  Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[16]  George U. Hubbard.  Computer-assisted logical database design , 1979 .

[17]  C. P. Wang,et al.  Segment Synthesis in Logical Data Base Design , 1975, IBM J. Res. Dev..

[18]  Daniel G. Bobrow,et al.  Natural Language Input for a Computer Problem Solving System , 1964 .

[19]  Diane C. P. Smith,et al.  Database abstractions: aggregation and generalization , 1977, TODS.

[20]  Frank Wm. Tompa.  Choosing an Efficient Internal Schema , 1976, VLDB.

[21]  Michael Hammer.  Self-adaptive automatic database design , 1899 .