CABSYDD: Case-Based System for Database Design.

0
123

Authors: Joobin Choobineh

Tags: 2004, AMBER W. LO, conceptual modeling

The majority of the reported researcb and development efforts on auto- mated techniques and tools for conceptual database design have focused on design from tlrst principles. Very few have used case-based reasoning, where eases of con- ceptual design are stored, indexed, and used for future designs. Furthermore, there is a general lack of reported research on validating and verifying such systems. In this paper, we describe our approach in using case-based reasoning for conceptual data- base design. To test and demonstrate the feasibility of our approach and its theoretical foundation, two prototype systems were constructed. In the absence of existing matching conceptual design constructs, the first system uses first principles of conceptual de- sign to assist a human designer in arriving at a design for a new problem. In contrast, the second system uses constructs from previously stored design cases. The two are tightly integrated. A novel approach in structuring the case base was developed. Unique aspects of the case-base architecture and its learning mechanism are described. In order to mea.sure user preference, an experitnent was designed and conducted. Find- ings indicate that reuse of schemata not only is preferred by the users over the design from the first principles, but also results in fewer errors.

Read the full paper here: https://www.jmis-web.org/issues