Programming expert systems in OPS5: an introduction to rule-based programming
Programming expert systems in OPS5: an introduction to rule-based programming
A guide to expert systems
A tool to support competitive argumentation
Journal of Management Information Systems - Special Issue: Decision Support and Knowledge-Based Systems
A methodology for creating user views in database design
ACM Transactions on Database Systems (TODS)
An expert system for conceptual schema design: a machine learning approach
International Journal of Man-Machine Studies
A knowledge-based approach to relational database design
Data & Knowledge Engineering
Fundamentals of database systems
Fundamentals of database systems
A Generalized Expert System for Database Design
IEEE Transactions on Software Engineering
Definition libraries for conceptual modelling
Data & Knowledge Engineering
The CHRIS consultant: a tool for database design and rapid prototyping
Information Systems
A method for database requirements collection
Journal of Management Information Systems
A form-based approach for database analysis and design
Communications of the ACM
Empirical verification of effectiveness for a knowledge-based system
International Journal of Man-Machine Studies
Case-based reasoning
An expert system with case-based reasoning for database schema design
Decision Support Systems
Analysis patterns: reusable objects models
Analysis patterns: reusable objects models
Object models (2nd ed.): strategies, patterns, and applications
Object models (2nd ed.): strategies, patterns, and applications
Database design with common sense business reasoning and learning
ACM Transactions on Database Systems (TODS)
Effective distribution of object-oriented applications
Communications of the ACM
Database modeling and design (3rd ed.)
Database modeling and design (3rd ed.)
An ontology-based expert system for database design
Data & Knowledge Engineering - Special issue on ER '97
Knowledge-based systems as database design tools: a comparative study
Journal of Database Management
An ontological analysis of the relationship construct in conceptual modeling
ACM Transactions on Database Systems (TODS)
International Journal of Human-Computer Studies
Inside Case-Based Reasoning
Contemporary Application-Domain Taxonomies
IEEE Software
An Expert Database Design System Based on Analysis of Forms
IEEE Transactions on Software Engineering
An Expert System for Conceptual Data Modelling
Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
Database design tools: an expert system approach
VLDB '85 Proceedings of the 11th international conference on Very Large Data Bases - Volume 11
IEEE Transactions on Software Engineering
Situational maturity models as instrumental artifacts for organizational design
Proceedings of the 4th International Conference on Design Science Research in Information Systems and Technology
Semi-automatic conceptual data modeling using entity and relationship instance repositories
ER'11 Proceedings of the 30th international conference on Conceptual modeling
Hi-index | 0.00 |
The majority of the reported research and development efforts on automated techniques and tools for conceptual database design have focused on design from first principles. Very few have used case-based reasoning, where cases of conceptual 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 database 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 design 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 measure user preference, an experiment was designed and conducted. Findings 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.