Abstract
Considering during design, behavior and performance properties of transactions is very important for 'dynamic' databases where large amounts of data are updated frequently. This paper presents an approach to support the design of such databases. Basis of our approach are schemata of an extended entity-relationship model which are constructed in a modular way and can then be enriched by behavior ...
Abstract
Considering during design, behavior and performance properties of transactions is very important for 'dynamic' databases where large amounts of data are updated frequently. This paper presents an approach to support the design of such databases. Basis of our approach are 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 as far as possible the retrieval and update semantics from a given data schema, such that we gain aspects concerning design untidynesses, inconsistencies, or behavior bottlenecks. These are eliminated in later steps using conventional design and implementation strategies, and database tuning measures.
The components of the database design toolbox RADD can be used to derive and analyze applications of the resulting information system, such that alternative EER representations with better behavior properties can be automatically generated, and visualized to the database designer. The alternative representation can then be taken instead of the given schema or discussed with the designer, to optimize the given schema structurally, semantically, and operationally. This way, bottlenecks of the modeled system can be omitted using the conceptual view to the database, and a logical formalism for requirements specification and database tuning.
More literature (via CORE)