This Article 
 Bibliographic References 
 Add to: 
A Generalized Expert System for Database Design
April 1989 (vol. 15 no. 4)
pp. 479-491

Generalized Expert System for Database Design (GESDD) is a compound expert system made up of two parts: (1) an expert system for generating methodologies for database design, called ESGM; and (2) an expert system for database design, called ESDD. ESGM provides a tool for the database design expert to specify different design methodologies or to modify existing ones. The database designer uses ESDD in conjunction with one of these methodologies to design a database starting from the requirement specification phase and producing a logical schema in one of the well-known data models, namely, the hierarchical data model, the network data model, or the relational data model. The system is evolutive in the sense that an existing methodology can be modified or a novel methodology can be added to the existing ones. GESDD is a menu-driven system and it is coded in Prolog.

[1] A. Albano and R. Orsini, "A prototyping approach to database applications development,"IEEE Database Eng., Dec. 1984.
[2] A. Albano, L. Cardelli, and R. Orsini, "Galileo: A Strongly Typed, Interactive Conceptual Language,"ACM Trans. Database Systems, Vol. 10, No. 2, June 1985, pp. 230-260.
[3] J. L. Alty and M. J. Coombs,Expert Systems Concepts and Examples. NCC Publications, 1984.
[4] C. Batini and M. Lenzerini, "A methodology for data schema integration in the entity relationship model,"IEEE Trans. Software Eng., vol. SE-10, no. 6, Nov. 1984.
[5] C. Batini and S. Ceri, "Database design: Tools and environments," Panel Session,Proc. ACM-SIGMOD 1985 Int. Conf. Management of Data, Austin, TX, May 1985.
[6] M. Bouzeghoub, G. Gardarin, and E. Metais, "Database design tools: An expert system approach," inProc. 11th Conf. Very Large Databases, Stockholm, Aug. 1985.
[7] R. P. Braegger, A. M. Dudler, J. Rebsamen, and C. A. Zehnder, "GAMBIT: An interactive database design tool for data structures, integrity constraints, and transactions,"IEEE Trans. Software Eng., vol. SE-11, no. 7, July 1985.
[8] H. Briand, H. Habrias, J. F. Hue, and Y. Simon, "Expert system for translating an entity-relationship diagram into databases," inProc. Fourth Int. Conf. ER-Approach, Chicago, IL, 1985.
[9] R. R. Brown and T. L. Ramey, "Introduction to ERA information modeling," Hughes Aircraft Co., CA, 1979.
[10] T. Burns,et al., "Reference model for DBMS standardization,"ACM SIGMOD Rec., vol. 15, No. 1, Mar. 1986.
[11] S. Ceri and G. Gottlob, "Normalization of the relations and Prolog,"Commun. ACM, vol. 29, no. 6, pp. 524-544, 1986.
[12] P. P. Chen, "The Entity-Relationship Model -- Towards a Unified View of Data,"ACM Trans. Database Syst., Vol. 1, No. 1, Mar. 1976, pp. 9-36.
[13] P. P. Chen, "The entity-relationship approach to logical database design,"Q.E.D. Monograph Series Database Management, 1978.
[14] J. Choobineh, M. V. Manino, J. F. Nunamaker, and B. R. Konsynski, "An expert database design system based on analysis of forms,"IEEE Trans. Software Eng., vol. SE 14, no. 2, Feb. 1988.
[15] V. De Antonellis and A. Di Leva, "DATAID-1: A database design methodology,"Inform. Syst., vol. 10, no. 2, 1985.
[16] A. Dogac, P. Chen, and N. Erol, "The design and implementation of an integrity subsystem for relational DBMS RAP," inProc. Fourth Int. Conf. ER Approach, Chicago, 1985.
[17] A. Dogac and E. A. Ozkarahan, "A generalized DBMS implementation on a database machine," inProc. ACM-SIGMOD Int. Conf. Management of Data, May 1980.
[18] M. Hammer and D. J. McLead, "Database description with SDM: a semantic database model,"ACM Trans. Database Syst., pp. 351-386, Sept. 1981.
[19] P. Harmon and D. King,Expert Systems. New York: Wiley, 1985.
[20] W. Kent, "Choice in practical data design," inProc. 8th Conf. Very Large Data Bases, Mexico City, Sept. 1982.
[21] R. King and D. McLeod, "A database design methodology and tool for information systems,"ACM Trans. Office Inform. Syst., vol. 3, no. 1, Jan. 1985.
[22] L. Mark, "Self describing database systems: Formalization and realization," Dep. Comput. Sci., Univ. Maryland, Tech. Rep. TR- 1484, 1985.
[23] L. Mark and D. Rombach, "A meta information base for software engineering," Dep. Comput. Sci., Univ. Maryland, Tech. Rep. TR- 1765, July 1987.
[24] L. Mark and N. Roussopoulos, "Integration of data, schema and metaschema in the context of self-documenting data models," inEntity Relationship Approach to Software Engineering, C. Davis, S. Jajodia, P. Ng, and R. Yeh, Eds. Amsterdam, The Netherlands: North-Holland, 1983.
[25] L. Mark and N. Roussopoulos, "Meta-data management,"Computer, vol. 19, no. 12, Dec. 1986.
[26] J. Mylopouloset al., "Information system design at the conceptual level--The TAXIS project,"IEEE Database Eng., Dec. 1984.
[27] N. Roussopoulos and R. T. Yeh, "An adaptable methodology for database design,"Computer, May 1984.
[28] D. Reineret al., "The database design and evaluation workbench (DDEW) project in CCA,"IEEE Database Eng., Dec. 1984.
[29] B. Sundgren, "Database design in theory and practice towards an integrated methodology," inProc. 4th Conf. Very Large Data Bases, West Berlin, Sept. 1978.
[30] E. D. Wig, "PSL/PSA primer," Department of Computational Sci., Univ. Saskatcwan, Canada, Working Paper, Nov. 1978.

Index Terms:
database design; Generalized Expert System for Database Design; ESGM; requirement specification phase; logical schema; hierarchical data model; network data model; relational data model; GESDD; menu-driven system; database management systems; expert systems; software tools.
A. Dogac, B. Yuruten, S. Spaccapietra, "A Generalized Expert System for Database Design," IEEE Transactions on Software Engineering, vol. 15, no. 4, pp. 479-491, April 1989, doi:10.1109/32.16607
Usage of this product signifies your acceptance of the Terms of Use.