Should rule-based reasoning be enhanced by case-based reasoning for conceptual database design? A theory and an experiment

Journal of Computer Information Systems

Volumn 46, Issue 2, 2005, Pages 69-71

  Choobineh, Joobin ^a   Lo, Amber W ^b  

^a TEXAS A AND M UNIVERSITY   (United States)

^b KNOWLEDGE BASED SYSTEMS INC   (United States)

Author keywords

Case Base Reasoning; Database design; Rule based Reasoning

Indexed keywords

CASE-BASE REASONINGS; CASEBASED REASONINGS (CBR); CONCEPTUAL DATABASE DESIGN; DATABASE DESIGN; DEGREE OF EFFECTIVENESS; PROCEDURAL KNOWLEDGE; REASONING PARADIGM; RULE BASED REASONING;

DATABASE SYSTEMS; EXPERT SYSTEMS;

DESIGN;

EID: 33644506146     PISSN: 08874417     EISSN: None     Source Type: Journal    
DOI: None     Document Type: Article

References (47)

1. Antony, S. and D. Batra. "CODASYS: A Consulting Tool for Novice Database Designers," Working Paper, Texas Tech University, 2002.
2. Bouzeghoub, M. "Using Expert Systems in Schema Design." In Loucopoulos, P.I and R. Zicari (Eds.). Conceptual Modeling: Databases and CASE. New York: Wiley, 1992.
3. Bouzeghoub, M. and G. Gardarin. "Database Design Tools: An Expert System Approach," Proceedings of VLDB 1985, Stokholm, August 21-23, 1985, pp. 82-95.
4. Braegger, R.P., A.M. Dudler, J. Rebsame, and C.A. Zehnder. "Gambit: An Interactive Database Design Tool for Data Structures, Integrity Constriants and Transactions," IEEE Transactions on Software Engineering, SE-11:7, July 1985, pp. 574-583.
5. Cauvet, C., C. Proix, and C. Rolland. "Information Systems Design: An Expert System Approach." In Meersman, R.A., Z. Shi, and C.-H. Kung (Eds.). Artificial Intelligence in Databases and Information Systems (DS-3). New York: North-Holland, 1990.
6. Chen & Associates, Inc. ER-Modeler, Version 1.50. Los Angeles, Chen & Associates, Inc., 1988.
7. Choobineh, J. and A. Lo. "CABSYDD: CAse-Based SYstem for Database Design," Journal of Management Information Systems, 21:3, Winter 2004/2005, pp. 289-314.
8. Choobineh, J., M.V. Mannino, J.F. Nunamaker, and B.R. Konsynski. "An Expert Database Design System Based on Analysis of Forms," IEEE Transactions on Software Engineering, 14:2, February 1988, pp. 242-253.
9. Choobineh, J., M.V. Mannino, and V.P. Teseng. "A Form-based Approach for Database Analysis and Design," Communications of the ACM, 35:2, February 1992, pp. 108-120.
10. Choobineh, J. and S. Venkatraman. "A Methodology and Tool for Derivation of Functional Dependencies from Business Forms," Information Systems, 17:3, 1992, pp. 269-282.
11. Demirkan, H. "Integration of Reasoning Systems in Architectural Modeling Activities," Automation in Construction, 7, 1998, pp. 229-236.
12. DiBattista, G., H. Kangassalo, and R. Tamassia. "Definition Libraries for Conceptual Modeling," Data & Knowledge Engineering, 4, 1989, pp. 245-260.
13. Dogac, A., B. Yuruten, and S. Spaccapietra. "A Generalized Expert System for Database Design," IEEE Transactions on Software Engineering, 15:4, April 1989, pp. 479-491.
14. th ed. Addison-Wesley, 2003.
15. Falkenberg, E.D., H. VanKempen, and N. Mimpen. "Knowledge-based Information Analysis Support." In Meersman, R.A., Z. Shi, and C.-H. Kung (Eds.). Artificial Intelligence in Databases and Information Systems (DS3). New York: North-Holland, 1990.
16. Golding, A.R. and P.S. Rosenbloom. "Improving Accuracy by Combining Ruile-based and Case-based Reasoning," Artificial Intelligence, 87, 1996, pp. 215-254.
17. Kadiyala, R., R. Krovi, and B. Rajagopalan. "The Design of a Knowledge Based Component to Support Information-Reengineering," Journal of Computer Information Systems, 37:2,1996-1997, pp. 44-53.
18. th ed. Harcourt College Publishers, 2000.
19. Kolodner, J.L. Case-based Reasoning. San Mateo, CA: Morgan Kaufmann, 1993.
20. Kolodner, J.L. "Improving Human Decision Making through Case-based Decision Aiding," AI Magazine, 12:2, 1991, pp. 52-68.
21. Kolodner, J.L. and C.K. Riesbeck. "Case-based Reasoning," Tutorial of the Eighth National Conference on Artificial Intelligence, Boston, MA, July 1990.
22. Lo, W.A. and J. Choobineh. "Knowledge-based Systems as Database Design Tools: A Comparative Study," Journal of Database Management, 10:3, 1999, pp. 26-40.
23. Marlin, C., M. Sqalli, E. Rissland, H. Munoz-Avila, and D. Aha. "Case-based Reasoning Integrations," AI Magazine, Spring 2002, pp. 69-86.
24. Martz Jr., W.B. and M.M. Shepherd. "Getting More out of Organizational Memory: Comparative Comments and Output Medium," Journal of Computer Information Systems, 41:4,2001, pp. 90-94.
25. Obretenov, D., Z. Angelov, J. Mihaylov, P. Dishlieva, and N. Kirova. "A Knowledge-based Approach to Relational Database Design," Data and Knowledge Engineering, 3:3,1988, pp. 173-180.
26. Pack, Y.-K., J. Seo, and G.-C. Kim. "An Expert System with Case-based Reasoning for Database Schema Design," Decision Support Systems, 18, 1996, pp. 83-95.
27. Pal, K. and J.A. Campbell. "An Application of Rule-based and Case-based Reasoning within a Single Legal Knowledge-based System," Database for Advances in Information Systems, 28:4, Fall 1997, pp. 48-63.
28. Pal, K. and O. Palmer. "A Decision Support System for Business Acquisitions," Decision Support System, 27, 2000, pp. 411-429.
29. Riesbeck, C.K. and R.C. Schank. Inside Case-based Reasoning. Hillsdale, NJ: Lawrence Erlbaum, 1989.
30. Ryan, S.D. and V.R. Prybutok. "Factors Affecting the Adoption of Knowledge Management Technologies: A Discriminative Approach," Journal of Computer Information Systems, 41:4, 2001, pp. 31-37.
31. Shim, S.J. "Exploring the Benefits of Expert Systems Use in Organizations," Journal of Computer Information Systems, 39:3, 1997, pp. 77-80.
32. Sinha, A.P. and J.H. May. "Providing Design Assistance: A Case-based Approach," Information Systems Research, 7:3, September 1996, pp. 363-387.
33. Smith, H.G., F.V. Burstein, A. Sowunmi, and R. Sharma. "Organizational Memory Information Systems: A Case-based Approach to Decision Support." In Kersten, G., Z. Mikolajuk, M. Rais, and A. Yeh (Eds.). Decision Support Systems for Sustainable Development. New York: Kluwer Academic, 1999.
34. Storey, V.C. "Relational Database Design Based on the Entity-relationship Model," Data & Knowledge Engineering, 7:1, 1991, pp. 47-83.
35. Storey, V.C., R. Chiang, R. Goldstein, D. Dey, and S. Sundaresan. "Database Design with Common Sense Business Reasoning and Learning," ACM Transactions on Database Systems, 22:4, 1997, pp. 471-512.
36. Storey, V.C. and R.C. Goldstein. "A Methodology for Creating User Views in Database Design," ACM Transactions on Database Systems, 13:8, September 1988, pp. 305-388.
37. Tauzovich, B. "An Expert System for Conceptual Data Modeling." In Lochovsky, F.H. (Ed.). Entity Relationship Approach to Database Design and Querying. New York: Elsevier Science Publishers B.V. (North Holland), 1990.
38. Teorey, T.J. Database Modeling and Design: The Entity-relationship Approach. San Mateo, CA: Morgan Kaufmann, 1990.
39. Trochim, W.M.K. The Research Method Knowledge Base. Atomic Dog Publishing, 2001.
40. Tseng, V.P. and M.V. Mannino. "A Method for Database Requirements Collection," Journal of Management Information Systems, 6:2, 1989, pp. 51-75.
41. Tucherman, L., M.A. Casanova, and A.L. Furtado. "The CHRIS Consultant - A Tool for Database Design and Rapid Prototyping," Information Systems, 15:2, 1990, pp. 187-195.
42. Vinze, A.S. "Empirical Verification of Effectiveness for a Knowledge-based System," International Journal of Man-Machine Studies, 37, 1992, pp. 309-334.
43. Wand, Y. and R. Weber. "Research Commentary: Information Systems and Conceptual Modeling - A Research Agenda," Information Systems Research, 13:4, December 2002, pp. 363-376.
44. Waterman, D.A. A Guide to Expert Systems. Reading, MA: Addison-Wesley, 1986.
45. Xia, Q. and M. Rao. "Knowledge Architecture and System Design for Intelligent Operation Support Systems," Expert Systems with Applications, 17, 1999, pp.1 115-127.
46. Yasdi, R. and W. Ziarko. "An Expert System for Conceptual Schema Design: A Machine Learning Approach," International Journal on Man-Machine Studies, 29:4, 1988, pp. 351-376.
47. Zhou, H.H. "EduMaster: Automated Knowledge Engineering and Acquisition," Journal of Computer Information Systems, 33:3, 1993, pp. 73-76.