Database Design Knowledge-Based Approaches to Database Design

Database design is often described as an in-tuitive, even artistic, process. Many researchers, however, are currently working on applying tech-niques from artificial intelligence to provide ef-fective automated assistance for this task. This article presents a summary of the current state of the art for the benefit of future researchers and users of this technology. Thirteen examples of knowledge-based tools for database design are briefly described and then compared in terms of the source, content, and structure of their knowledge bases; the amount of support they provide to the human designer; the data models and phases of the design process they support; and the capabilities they expect of their users. The findings show that there has apparently been very little empirical verification of the effec-tiveness of these systems. In addition, most rely exclusively on knowledge provided by the developers themselves and have tittle ability to expand their knowledge based on experience. Although such systems ideally would be used by application specialists rather than database pro-fessionals, most of these systems expect the user to have some knowledge of database technology. Keywords:Knowledge-based software, database design, expert sytems ACM Categories: H.2.1., 1.2.