Universal Patterns for Data Modeling: A Structural Theme {1}

by Arlyn R
Authors Len Silverston and Paul Agnew (2009) of “What are Universal Patterns for Data Modeling?” explain how patterns can enhance data models. The authors equate Universal Patterns for Data Modeling to the schematics of a suspension bridge. Although bridge exteriors may differ, the majority of suspension bridges interior construction patterns are designed the same. Silverston and Agnew describe a data modeling pattern “as a template that can serve as a guide for developing data models.” The authors also briefly explain universal data models and how they are reusable data models for common business rules. So instead of re-inventing the wheel, database designers can reuse models that are fundamental to an industry. In contrast, “Universal Patterns in Data Modeling provide the underlying structural themes so that the modelers can reuse these to build any model (Silverston, Agnew).” Therefore, Universal Patterns can be applied to any data model and improve upon a generic Universal Data Model. Silverston and Agnew find that Universal Patterns benefit organizations by constructing upon a universal data model that has proven essential to its industry while utilizing resources towards the specifics of its business. read more...