An entity-relationship-based methodology for distributed database design: An integrated approach towards combined logical and distribution designs

0
94

Authors: Hong -Mei Chen Garcia, Olivia Liu R. Sheng

Tags: 1992, conceptual modeling

This paper presents an integrated, general methodology (SEER-DTS Methodology) for relational homogeneous distributed database (DDB) design. The SEER-DTS methodology employs two ER-based data models: SEER (Synthesized Extended Entity-Relationship model) for static data modeling and DTS (Distributed Transaction Scheme) for dynamic data modeling. Rules are provided to transform the application semantics represented by SEER and DTS into “performance-oriented” logical and fragmentation design schemata. The formal treatment of distributed transaction information by DTS leads to an integrated requirement/distribution analysis and conceptual design as well as allows for a combined logical and fragmentation design. This simplifies the DDB designer’s tasks and thus increases their effectiveness and productivity. The SEER-DTS methodology has been subjected to validation through a real-world case study and a laboratory experiment. Moreover, a computer-aided DDB design tool (Auto-DDB) which automates the SEER-DTS methodology has been prototyped.

Read the full paper here: https://link.springer.com/chapter/10.1007/3-540-56023-8_12