Abstract
This paper presents an approach to support the design of ‘dynamic’ databases. The basis of our approach is formed by schemata of an extended entity-relationship model which are constructed in a modular way and can then be enriched by behavior specifications, functions, and view definitions. The goal is to derive the retrieval and update semantics from a given data schema as far as possible, such ...
Abstract
This paper presents an approach to support the design of ‘dynamic’ databases. The basis of our approach is formed by schemata of an extended entity-relationship model which are constructed in a modular way and can then be enriched by behavior specifications, functions, and view definitions. The goal is to derive the retrieval and update semantics from a given data schema as far as possible, such that we discover aspects in a not well-ordered design, inconsistencies, or behavior bottlenecks. These are eliminated in later steps using conventional design and implementation strategies, and database tuning measures. The conceptual database design optimizer of the database design toolbox RADD can be used to analyze applications of the resulting information system, such that alternative EER schemata with better behavior properties can be automatically inferred, and visualized to the database designer.
Altmetric