DESIGN PATTERNS ACROSS SOFTWARE ENGINEERING AND RELATIONAL DATABASES

Specification and design in relational databases largely use a domain-specific design approach (e.g., Entity-Relational Model) different from that used in software engineering. In software engineering, the use of UML (Unified Modeling Language) models, design patterns, and the Unified Process are the primary design and development methodology, especially in modern object-oriented software engineering. The application of generic software engineering design patterns to databases allows issues in logical design and in implementation of databases to be more easily connected with similar concerns in software engineering. It can leverage previous experience with software design, make knowledge from database discipline more immediately relevant with software engineering. In this research, we apply the generic software engineering design patterns to the design and implementation of relational databases