Integrated design patterns for database applications

Abstract Design patterns describe solutions for design problems that occur repeatedly in the development of software systems. Software system builders increasingly recognize the importance of exploiting design knowledge and successful experiences in the engineering of new systems. As a result, design patterns have started to gain popularity in capturing software design knowledge and software designs themselves. Currently, design patterns have addressed some of the object-oriented design limitations such as the difficulty in specifying reusable designs. Database applications have both structural and dynamic properties. However, design patterns for structural and dynamic properties are usually discussed separately without much integration. In this paper, we propose design patterns to provide solutions for some important common requirements in database applications. Most of these patterns address the structural and dynamic properties of database applications on an integrated basis. These patterns can be used in the design process as well as the design verification process.

[1]  David C. Hay,et al.  Data Model Patterns: Conventions of Thought , 1965 .

[2]  Tok Wang Ling,et al.  An improved third normal form for relational databases , 1981, TODS.

[3]  Rob Gillette,et al.  Physical Database Design for Sybase SQL Server , 1995 .

[4]  Giuseppe Menga,et al.  Designing concurrent and distributed control systems , 1996, CACM.

[5]  Andrew B. Whinston,et al.  Electronic markets for learning: education brokerages on the Internet , 1996, CACM.

[6]  Ralph Johnson,et al.  design patterns elements of reusable object oriented software , 2019 .

[7]  Nayeem Islam,et al.  An essential design pattern for fault-tolerant distributed state sharing , 1996, CACM.

[8]  James O. Coplien,et al.  Pattern languages of program design , 1995 .

[9]  Christopher J. Shaw.  Application and database design—putting it off , 1988, SGMD.

[10]  Peter P. Chen.  The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[11]  S. J. Mellor,et al.  Why Explore Object Mathods, Patterns, and Architectures? , 1997, IEEE Software.

[12]  David Maier,et al.  The Theory of Relational Databases , 1983 .

[13]  Tok Wang Ling,et al.  NF-NR: A practical normal form for nested relations , 1994, J. Syst. Integr..

[14]  Philip A. Bernstein,et al.  Synthesizing third normal form relations from functional dependencies , 1976, TODS.

[15]  Thomas Berlage,et al.  A selective undo mechanism for graphical user interfaces based on command objects , 1994, TCHI.

[16]  Tok Wang Ling,et al.  Logical database design with inclusion dependencies , 1992, [1992] Eighth International Conference on Data Engineering.

[17]  Dirk Riehle,et al.  Pattern Languages of Program Design 3 , 1997 .

[18]  Martin Fowler,et al.  Analysis patterns - reusable object models , 1996, Addison-Wesley series in object-oriented software engineering.

[19]  David Garlan,et al.  Architectural Styles, Design Patterns, And Objects , 1997, IEEE Softw..

[20]  Tok Wang Ling.  A Normal Form For Entity-Relationship Diagrams , 1985, ER.

[21]  Ralph E. Johnson,et al.  Guest Editor's Introduction: Why Explore Object Methods, Patterns, and Architectures? , 1997, IEEE Softw..

[22]  David Budgen,et al.  Software design , 2020, International computer science series.