Title :
A case-based reasoning approach to relational database schema design
Author :
Paek, Yong-Kee ; Seo, Jungyun ; Kim, Gil-Chang
Author_Institution :
Dept. of Comput. Sci., Korea Adv. Inst. of Sci. & Technol., Seoul, South Korea
Abstract :
We describe a design expert system for database schema based upon case-based reasoning. The proposed system relies on a hybrid case-base that consists of a domain dependent case-base (DDCB) and a domain independent case-base (DICB). With user requirements, the system searches a DDCB for a similar case. If there is one, the system uses it to design a database schema with minimum user interaction. When there is no similar case, the system uses cases in DICB to make a new schema in 3rd normal form with more user interaction. Whenever a new schema is designed, it is added to the DDCB. A DDCB is hierarchically organized to help the system reduce search space. For this approach, we propose a relational conceptual graph to represent user design specifications and each case in the case-bases
Keywords :
case-based reasoning; graph theory; intelligent design assistants; relational databases; systems analysis; case-based reasoning approach; design expert system; domain dependent case-base; domain independent case-base; hybrid case-base; relational conceptual graph; relational database schema design; search space; user design specifications; user interaction; Artificial intelligence; Computer science; Data analysis; Data mining; Data models; Expert systems; Humans; Natural languages; Process design; Relational databases;
Conference_Titel :
EUROMICRO 94. System Architecture and Integration. Proceedings of the 20th EUROMICRO Conference.
Conference_Location :
Liverpool
Print_ISBN :
0-8186-6430-4
DOI :
10.1109/EURMIC.1994.390360
