Re: Reusable database design - Mailing list pgsql-general

From Ron St-Pierre
Subject Re: Reusable database design
Date
Msg-id 41BA23D4.9030508@syscor.com
Whole thread Raw
In response to Reusable database design  (Joachim Zobel <jzobel@heute-morgen.de>)
List pgsql-general
Joachim Zobel wrote:

>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
>
>
>
Check out your favourite bookstore for resources. Amazon also lists a
few books:
* 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


pgsql-general by date:

Previous
From: John Allgood
Date:
Subject: Postgres 7.4.6 x86_64 RPMS
Next
From: "Marc G. Fournier"
Date:
Subject: Servers live ... news at 11 ...