The use of a knowledge-based system in conceptual data modeling

Based on a study of the data modeling process of novice designers, and the errors they commit, a knowledge-based system (KBS) was designed and developed. It was found that the performance of novice designers was significantly better when they utilized the KBS instead of a system with no knowledge base. Two versions of the KBS--one with a guidance interface that advised the designer on appropriate design choices and another with a restrictive interface that restricted the design choices available to the designer--were developed. The restrictive interface was rated as being significantly easier to use than the guidance interface.

[1]  L. Richard Ye,et al.  The Impact of Explanation Facilities in User Acceptance of Expert System Advice , 1995, MIS Q..

[2]  Dinesh Batra,et al.  CODASYS: a consulting tool for novice database designers , 2002, DATB.

[3]  Igor Hawryszkiewycz.  A Computer-Aid for E-R Modeling , 1985, ER.

[4]  William A. Wallace,et al.  Intelligent Interface Design: An Empirical Assessment of Knowledge Presentation in Expert Systems , 1990, MIS Q..

[5]  Eric J. Johnson,et al.  The adaptive decision maker , 1993 .

[6]  Donald L. Day,et al.  User responses to constraints in computerized design tools (extended abstract) , 1996, SOEN.

[7]  Douglas B. Bock,et al.  Accuracy in Modeling with Extended Entity Relationship and Object Oriented Data Models , 1993 .

[8]  Mark S. Silver,et al.  Systems that support decision makers: description and analysis , 1991 .

[9]  Izak Benbasat,et al.  The Use of Explanations in Knowledge-Based Systems: Cognitive Perspective and a Process-Tracing Analysis , 2000, J. Manag. Inf. Syst..

[10]  Noam Tractinsky.  Effects of DSS restrictiveness on decision-making under time pressure , 1993 .

[11]  Joobin Choobineh,et al.  Knowledge-Based Systems as Database Design Tools: A Comparative Study , 1999, J. Database Manag..

[12]  Izak Benbasat,et al.  Evaluating the Impact of DSS, Cognitive Effort, and Incentives on Strategy Selection , 1999, Inf. Syst. Res..

[13]  William C. Hill.  How some advice fails , 1989, CHI '89.

[14]  E. F. Codd,et al.  A relational model of data for large shared data banks , 1970, CACM.

[15]  Il-Yeol Song,et al.  Binary relationship imposition rules on ternary relationships in ER modeling , 1993, CIKM '93.

[16]  Izak Benbasat,et al.  Information Technology Competence of Business Managers: A Definition and Research Model , 2001, J. Manag. Inf. Syst..

[17]  Bijan Fazlollahi,et al.  The Effectiveness of Decisional Guidance: An Empirical Evaluation , 2001, Decis. Sci..

[18]  Brian L. Dos Santos,et al.  A Study of User Interface Aids for Model-Oriented Decision Support Systems , 1988 .

[19]  Mark S. Silver,et al.  Decision Support Systems: Directed and Nondirected Change , 1990, Inf. Syst. Res..

[20]  Brian E. Mennecke,et al.  Restrictive Group Support Systems as a Source of Process Structure for High and Low Procedural Order Groups , 1993 .

[21]  Heikki Topi,et al.  Modern Database Management , 1999 .

[22]  Radhika Santhanam,et al.  A survey of knowledge-based systems research in decision sciences (1980–1995) , 1998, J. Oper. Res. Soc..

[23]  James Martin,et al.  Client/Server Databases: Enterprise Computing , 1995 .

[24]  Peter P. Chen.  The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[25]  Dinesh Batra,et al.  Novice errors in conceptual database design , 1994 .

[26]  Peter P. Chen.  Proceedings of the Fourth International Conference on Entity-Relationship Approach , 1985 .

[27]  Christopher Billings,et al.  Rapid Application Development with Oracle Desiger , 1996 .

[28]  Fred D. Davis.  Perceived Usefulness, Perceived Ease of Use, and User Acceptance of Information Technology , 1989, MIS Q..

[29]  Veda Catherine Storey.  View Creation: An Expert System for Database Design , 1988 .

[30]  Sandeep Purao.  APSARA: a tool to automate system design via intelligent pattern retrieval and synthesis , 1998, DATB.

[31]  Jacob Cohen.  A Coefficient of Agreement for Nominal Scales , 1960 .

[32]  Shamkant B. Navathe,et al.  Conceptual Database Design: An Entity-Relationship Approach , 1991 .

[33]  Ilze Zigurs,et al.  Decisional guidance and end-user display choices , 1999 .

[34]  Julie Tower,et al.  Rapid Application Development with Oracle Designer/2000 , 1996 .

[35]  Dinesh Batra,et al.  A conceptual database design approach based on rules and heuristics , 1994 .

[36]  August-Wilhelm Scheer.  Enterprise-Wide Data Modelling: Information Systems in Industry , 1990 .

[37]  Jay F. Nunamaker,et al.  An Expert Database Design System Based on Analysis of Forms , 1988, IEEE Trans. Software Eng..

[38]  Laku Chidambaram.  Knowledge transfer in conceptual modeling by end users , 1999 .

[39]  John F. Rockart,et al.  The management of end user computing , 1983, CACM.

[40]  Bipin C. Desai.  Introduction to Database Systems , 1990 .

[41]  Veda C. Storey,et al.  Improving database design through the analysis of relationships , 1999, TODS.

[42]  Howard B. Lee,et al.  Foundations of Behavioral Research , 1973 .

[43]  Veda C. Storey,et al.  Knowledge-Based Approaches to Database Design , 1993, MIS Q..

[44]  Bill C. Hardgrave,et al.  Comparing Object-Oriented and Extended-Entity-Relationship Data Models , 1995 .

[45]  Barbara A. Schuldt.  Database challenges for the new millennium , 2000 .

[46]  Ben Shneiderman,et al.  Designing the User Interface: Strategies for Effective Human-Computer Interaction , 1998 .

[47]  Rodolfo Alfredo Bertone,et al.  Modern database management VI Edition. Jeffrey A. Hoffer, Mary B. Prescott, Fred R. McFadden Prentice Hall, Upper Saddle River, NJ, 2002 , 2003 .

[48]  John M. Carroll,et al.  Interface design issues for advice-giving expert systems , 1987, CACM.

[49]  Timothy Paul Cronan,et al.  On the Test-Retest Reliability of Perceived Usefulness and Perceived Ease of Use Scales , 1993 .

[50]  Fred D. Davis,et al.  User Acceptance of Computer Technology: A Comparison of Two Theoretical Models , 1989 .

[51]  Ronald L. Thompson,et al.  Information Technology and Management , 1996 .

[52]  August-Wilhelm Scheer,et al.  Enterprise-Wide Data Modelling , 1989 .

[53]  Carol V. Brown,et al.  The management of end-user computing: status and directions , 1993, CSUR.

[54]  Peter A. Todd,et al.  Perceived Usefulness, Ease of Use, and Usage of Information Technology: A Replication , 1992, MIS Q..

[55]  Dana Edberg,et al.  User-Developed Applications: An Empirical Study of Application Quality and Developer Productivity , 1996, J. Manag. Inf. Syst..

[56]  Izak Benbasat,et al.  An experimental study of the human/computer interface , 1981, CACM.

[57]  T. J. Teorey,et al.  A logical design methodology for relational databases using the extended entity-relationship model , 1986, CSUR.

[58]  Robert P. Bostrom,et al.  Comparing representations with relational and EER models , 1990, Commun. ACM.