An Expert System for Semantic and Relational Database Design

Mokrane Bouzeghoub
1989 International Conference on Advanced Information Systems Engineering  
Database design has become an art that requires a high level of competence. The database design process is characterized by a certain indetermination in the way of choosing data structures and constraints. Several different schemas may describe the same reality. The design process is also characterized by an intuitive and empirical methodology; consequently, the quality of the schema obtained is heavily dependent on the database administrator's experience and insight in the database design. The
more » ... development of increasingly sophisticated and efficient relational Data Base Management Systems has emphasized the need for increasingly complex information systems. It is therefore no longer possible to envision database design carried out without a computer aid. The expert system approach, described in this paper, is more adapted to the difficult problem of database modeling. It integrates algorithms, heuristics and practical know-how, and proposes an interactive methodology which is based on abstraction levels, user friendly interfaces and a modular knowledge base. This approach was fIrst implemented by a prototype which was followed by a commercial product named SECSI (Systeme Expert en Conception de Systemes d'information).
dblp:conf/caise/Bouzeghoub89 fatcat:zwgkf432m5hvxmogojzwh7qb2q