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.
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 Models?” Data Management Review 8:8. September 1998.
Simsion, Graeme C. Revised and updated by Graham C. Witt & Graeme C. Simsion. Data Modeling Essentials. Coriolis. 2000.
Reusable Data Warehouse Design Resources
Adamson, Christopher, and Michael Venerable. Data Warehouse Design Solutions. John Wiley &Sons. 1998
Connely, McNeill, and Mosimann. The Multi-Dimensional Manager, 24 Ways to Impact Your Bottom Line in 90 Days. Cognos. 1997
Kimball, Ralph. The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley & Sons. 2000.