Relational Database Design Patterns | IEEE Conference Publication | IEEE Xplore

Relational Database Design Patterns


Abstract:

Design Patterns (DPs) recently took over software development by storm. Object oriented development, workflows and distributed computing are a few of the disciplines wher...Show More

Abstract:

Design Patterns (DPs) recently took over software development by storm. Object oriented development, workflows and distributed computing are a few of the disciplines where DPs made a significant difference in delivery speed and product quality. Unfortunately, databases had not yet attracted the attention of DP designers. This work benefits from the growing popularity of open source-data centric and semantic web applications, and uncovers 24 DPs related to databases. These DPs will give insight to any database architect on how common real world entities are being modeled.
Date of Conference: 03-05 December 2013
Date Added to IEEE Xplore: 06 March 2014
Electronic ISBN:978-0-7695-5096-1
Conference Location: Sydney, NSW, Australia

I. Introduction

All software development processes, and especially for data centric applications, start with the gathering and analysis of the user's requirements. Many techniques were proposed [1], [2], but all approaches are time and resource consuming and, therefore expensive. Moreover, software developers will not initiate this process unless the project is officially started. The time wasted through the long and iterative process of the gathering of business requirements could be better used. The idea behind this work originated from recent proliferation of open source applications. As many of these projects rely on a persistence engine, the idea is to gather and study the database design of the largest possible number of open source applications. Furthermore, the increasing popularity of design patterns (a design pattern is a common solution to a common problem found by different people) in many disciplines, and especially in software engineering, was a motivation to try to come up with Database Design Patterns or (DDP).

References

References is not available for this document.