Zusammenfassung
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 ...
Zusammenfassung
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.
Within the framework of the project RADD (Rapid Application and Database Development) experience was gathered with the informal modelling of database structures.
In this paper we show an approach for the acquisition of semantic constraints which is informal, easy to understand and efficient. This method uses natural language input, sample data and a discussion of sample relations to find out semantic constraints of a database.
Altmetric