Naive Semantics to Support Automated Database Design

Research devoted to developing knowledge-based tools for database design has demonstrated that it is possible to encode a great deal of process knowledge about database design in a (knowledge-based) computer program. However, experience with these tools shows that the contribution of an expert human designer extends beyond his or her knowledge of database design techniques. The paper discusses the application of an approach, called Naive Semantics (NS), to simulate the contributions made to a design based on the designer's general knowledge. Naive semantics involves the use of an extensible store of generally understood knowledge about the world. The paper describes the types of information that could be included in a Naive Semantics knowledge base and how that knowledge might be applied to increase the effectiveness of automated database design systems. Results of various implementations of ontologies based on Naive Semantics are discussed.

[1]  Silvano Mussi,et al.  A Method for Putting Common Sense into an Expert Systems , 1993, IEEE Trans. Knowl. Data Eng..

[2]  Paul Beynon-Davies,et al.  Expert systems for database design: A comparative review , 1992, Artificial Intelligence Review.

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

[4]  Gottfried Vossen,et al.  A Survey of Database Design Transformations Based on the Entity-Relationship Model , 1995, Data Knowl. Eng..

[5]  Edward P. Stabler,et al.  Knowledge Representation for Commonsense Reasoning with Text , 1989, CL.

[6]  Erik Sandewall Towards a Worldwide Knowledge base extended abstract , 1996 .

[7]  Erik Sandewall Towards a World-Wide Knowledge Base , 1996, ISMIS.

[8]  Shahrul Azman Mohd. Noah,et al.  An Evaluation of Two Approaches to Exploiting Real-World Knowledge by Intelligent Database Design Models , 1998, ER.

[9]  Veda C. Storey,et al.  An Ontology for Database Design Automation , 1997, ER.

[10]  Michael Lloyd-Williams,et al.  Exploiting Domain Knowledge During the Automated Design of Object-Oriented Databases , 1997, ER.

[11]  Veda C. Storey,et al.  A Commonsense Reasoning Facility Based on the Entity-Relationship Model , 1993, ER.

[12]  Veda C. Storey,et al.  A Methodology for Learning Across Application Domains for Database Design Systems , 2002, IEEE Trans. Knowl. Data Eng..

[13]  Veda C. Storey,et al.  An Ontology-Based Expert System for Database Design , 1998, Data Knowl. Eng..

[14]  Kathleen Dahlgren,et al.  A linguistic ontology , 1995, Int. J. Hum. Comput. Stud..

[15]  Douglas B. Lenat,et al.  CYC: a large-scale investment in knowledge infrastructure , 1995, CACM.

[16]  Thomas R. Gruber,et al.  A translation approach to portable ontology specifications , 1993, Knowl. Acquis..

[17]  Veda C. Storey,et al.  Database design with common sense business reasoning and learning , 1997, TODS.

[18]  Veda C. Storey,et al.  Commonsense Reasoning in Database Design , 1991, ER.

[19]  Veda C. Storey,et al.  A methodology for creating user views in database design , 1988, TODS.

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

[21]  Sonia Bergamaschi,et al.  On taxonomic reasoning in conceptual design , 1992, TODS.

[22]  Sudha Ram Deriving functional dependencies from the entity-relationship model , 1995, CACM.

[23]  H. Putnam IS SEMANTICS POSSIBLE , 1970 .

[24]  Timothy W. Finin,et al.  Enabling Technology for Knowledge Sharing , 1991, AI Mag..

[25]  Stuart E. Madnick,et al.  Working Paper Alfred P. Sloan School of Management Database Systems in a Dynamic Environment Database Systems in a Dynamic Environment Received Context Interchange: Overcoming the Challenges of Large-scale Interoperable Database Systems in a Dynamic Environment* , 2022 .

[26]  Kathleen Dahlgren,et al.  Naive semantics for natural language understanding , 1988 .

[27]  Veda C. Storey,et al.  Common Sense Reasoning in Automated Database Design: An Empirical Test , 2002, J. Database Manag..