Other Reusable Data Model and Data Warehouse Design Resources

Hopefully, it is evident that reusing data models and data warehouse designs is extremely valuable. There are many other sources for reusable data model and data warehouse design constructs. In order to design systems more quickly and with higher quality, it only makes sense to use whatever sources of models are available—for example, models from vendors, models available on Web sites, models available within application packages, models available within the enterprise itself, models available from people’s past experiences, and models available from other publications. The following publications, while not exhaustive, provide some practical sources for reusable data models and data warehouse designs.

Reusable Data Model Resources

Barker, Richard. CASE*Method™ Entity Relationship Modeling. Addison-Wesley. 1989 (Note: this book focuses mostly on CASE*Method and data modeling conventions; however, it contains some useful data model constructs and ideas.)

Fowler, Martin. Analysis Patterns: Reusable Object Models. Addison-Wesley. 1997. (Note: Though this book is an object-oriented patterns book, many of these patterns apply to data modeling.)

Hay, David C. Data Model Patterns: Conventions of Thought. Dorset House. 1996.

Reingruber, Michael C., and William W. Gregory. The Data Modeling Handbook: A Best-Practice Approach to Building Quality Data Models.

Silverston, Len. “Is Your Organization Too Unique to Use Universal Data ...

Get The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.