An Informal and Efficient Approach for Obtaining Semantic Constraints Using Sample Data and Natural Language Processing

The main objective of database modelling is the design of a database that is correct and can be processed efficiently by a database management system. The efficiency and correctness of a database depends among other things on knowledge about database semantics because semantic constraints are the prerequisite for normalization and restructuring operations. Acquisition of semantic constraints remains one of the bottlenecks in database design because for most database designers formal definition of semantic constraints is a very difficult task.

[1]  Stefano Ceri,et al.  Methodology and tools for data base design , 1983 .

[2]  Veda C. Storey,et al.  Reverse Engineering of Relational Databases: Extraction of an EER Model from a Relational Database , 1994, Data Knowl. Eng..

[3]  Gerald Gazdar,et al.  Natural Language Processing in PROLOG: An Introduction to Computational Linguistics , 1989 .

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

[5]  A Min Tjoa,et al.  Transformation of Requirement Specifications Expressed in Natural Language into an EER Model , 1993, ER.

[6]  Heikki Mannila,et al.  Design of Relational Databases , 1992 .

[7]  Edith Buchholz,et al.  Using Natural Language for Database Design , 1994, KRDB.

[8]  David C. Wilkins,et al.  Readings in Knowledge Acquisition and Learning: Automating the Construction and Improvement of Expert Systems , 1992 .

[9]  Marco Colombetti,et al.  NLDA: A Natural Language Reasoning System for the Analysis of Data Base Requirements , 1983, Methodology and Tools for Data Base Design.

[10]  Chris Mellish,et al.  Natural Language Processing in Pop-11: An Introduction to Computational Linguistics , 1989 .

[11]  Manfred Pinkal,et al.  Definite Noun Phrases and the Semantics of Discourse , 1986, COLING.

[12]  Christoph F. Eick.  From natural language requirements to good data base definitions — A data base design methodology , 1984, 1984 IEEE First International Conference on Data Engineering.

[13]  Peter P. Chen.  English Sentence Structure and Entity-Relationship Diagrams , 1983, Inf. Sci..