Abstract
Various expert systems have been developed that attempt to automate the database design process. Although these systems may have a high degree of expertise in the design task, their lack of knowledge about the application domain that the database serves reduces their value as design aids. They often have to ask questions that appear unnecessary or trivial, thus losing credibility as experts and increasing the effort required of the user. A Commonsense Business Reasoner, based on the entity-relationship model, has been developed to augment a particular database design expert system for business applications. The Commonsense Business Reasoner is described in terms of the entities, relationships, and attributes that are needed to incorporate commonsense knowledge into the existing system.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
Bouzeghoub, M., “Using Expert Systems in Schema Design”, in Loucopoulos, P. and Zicari, R. (Eds.), Conceptual Modeling, Databases, and Case, Wiley, 1992, pp.465–487.
Dahlgren, K., Naive Semantics for Natural Language Understanding, Boston MA: Kluwer Academic Publishers, 1988.
Ein-Dor, P., “Representing Commonsense Knowledge: A Survey”, Working Paper No. 864/85, Israel Institute of Business Research, Tel Avi University, June 1985.
Goldstein, R.C. and Storey, V.C., “Commonsense Reasoning in Database Design”, Proceedings of the 10th International Conference on the Entity-Relationship Approach, San Francisco, California, 23–25 October 1991, pp.77–91.
Loucopoulos, P. and Theodoulidis, B., “CASE — Methods and Support Tools”, in Loucopoulos, P. and Zicari, R. (Eds.), Conceptual Modeling, Databases, and Case, Wiley, 1992, pp.373–388.
Lord, C. and Dahlgren, K., “Representation of Business and Financial Knowledge in the NewSelector System”, Working Paper, IBM L.A. Scientific Center, Jan. 1990.
Reiner, D., “Database Design Tools”, in Batini, C., Ceri, S., and Navathe, S.B., Conceptual Database Design: An Entity-Relationship Approach, Benjamin/Cummings Publishing Company, Inc. 1992.
Standard Industrial Classification Manual, Prentice Hall Information Services, 1988.
Storey, V.C., View Creation: An Expert System for Database Design, Ph.D. dissertation, Faculty of Commerce and Business Administration, University of British Columbia, Vancouver, Canada, ICIT Press, Washington, D.C., 1988.
Storey, V.C. and Goldstein, R.C., “Knowledge-Based Approaches to Database Design”, Management Information Systems Quarterly, Vol.17, No.1, March 1993, pp.25–46.
Storey, V.C. and Goldstein, R.C., “A Methodology for the Creation of User Views During Database Design”, ACM Transactions On Database Systems, Vol.13, No.3, September, 1988, pp.305–338.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Storey, V.C., Goldstein, R.C., Chiang, R.H.L., Dey, D. (1994). A commonsense reasoning facility based on the entity-relationship model. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds) Entity-Relationship Approach — ER '93. ER 1993. Lecture Notes in Computer Science, vol 823. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0024369
Download citation
DOI: https://doi.org/10.1007/BFb0024369
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58217-5
Online ISBN: 978-3-540-48575-9
eBook Packages: Springer Book Archive