Joachim Zobel wrote:
Check out your favourite bookstore for resources. Amazon also lists a few books:Hi.
I can't be the first to think about this. There is a million online
shops out there, which all more or less have the same database design.
Has anybody thought about creating generic reusable/customizable designs
for such cases?
Thx, Joachim
* Data Model Patterns: Conventions of Thought by David C. Hay:
"Analyzes data structures common to many types of businesses in areas such as accounting, material
requirements planning, process manufacturing, contracts, laboratories, and documents, for analysts
who have learned the basics of data modeling (or entity/relationship modeling) but who need more
insight to prepare a model of a real business. Includes b&w diagrams, and a set of ready-to-use
models for typical applications in many industries. Annotation copyright Book News, Inc. Portland, Or." from Amazon.com
* The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All Enterprises by Len Silverston
* The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries by Len Silverston
* Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design by Terry Halpin
* The Data Modeling Handbook : A Best-Practice Approach to Building Quality Data Models by Michael C. Reingruber
* Data Modeler's Workbench: Tools and Techniques for Analysis and Design by Steve Hoberman
* Analysis Patterns : Reusable Object Models (Addison-Wesley Object Technology: Addison-Wesley Object Technology Series) by Martin Fowler
I'm sure that there are even more available. Ron
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html