On Pattern-Based Database Design and Implementation

Patterns describe common solutions to recurring problems. This paper presents a pattern-based approach of improving database design and automating generation of statements that are written in a database language. During the logical design of a database, a database designer has to find domain-independent database design patterns that are applicable in the database. The selected patterns are used in order to generate code during implementation of the database. For example, this approach can be used in order to generate implementations of integrity constraints and updatable views. We present a pattern-based and template-based code generator that is created specifically for the development of databases.