Re: Database Design Patterns?

Hi,
the first book mentioned is in my opinion excellent. Its more about "Business Concept Patterns" than "Database Design Patterns" It is the best description of business concepts I have ever read and I think that the author shows that ER modelling is a great method (in my opinion the best) to visualize concepts. It is also fundamental ... the concepts/patterns of business partner/party, addresses, products, assets or organization units are fundamental in business systems. After detailed reading of the book you will be able to make an ER diagram about anything, and if it's in the domain of business software you will learn to see some pattern everywhere in such systems.

I know that many of the group participants don't like ER modelling but after reading this book to me it was clear that ER modelling is a best start to undestand something new. The level of abstractions between ER modelling and the RM are totally different ... the first is for conceptual overview and analysis and the later for logical design and/or deeper analysis. ER method is just a graphical method as other graphical method engineers use in the older disciplines (construction, mechanical and electrical engineering) before doing the calculations.

The books uses Oracle ER method which was the first ER method I really found usable in opposite to the original Chen method. There are very few graphical elements which are used and the attributes stay inside the entity sets. The entities are graphically represented like sets.

Greetings,
Drago

"Bruce C. Baker" <bcbakerXX_at_cox.net> wrote in message news:fvfQh.59992$mJ1.18472_at_newsfe22.lga...
>
> "aj" <ronald_at_mcdonalds.com> wrote in message
> news:1312o8q8p0fqf5_at_news.supernews.com...
>> I'm sure some (maybe many) of the folks in the group are familiar
>> w/ the Gamma/Helm/Johnson/Vlissides Design Patterns book (often
>> call Gang of Four or GoF).
>>
>> My question: Is there any such thing for databases? I don't mean
>> simple normalization, but higher-level stuff.
>>
>> Anyone have pointers to any books, papers, ideas, etc??
>>
>> TIA
>>
>> aj
>
> Something like:
>
> http://www.amazon.com/Data-Model-Patterns-Conventions-Thought/dp/0932633293/ref=sr_1_2/002-9796382-3848833?ie=UTF8&s=books&qid=1175552873&sr=1-2
>
> Or more recently:
>
> http://www.amazon.com/Data-Model-Patterns-Metadata-Management/dp/0120887983/ref=sr_1_1/002-9796382-3848833?ie=UTF8&s=books&qid=1175552873&sr=1-1
>
Received on Tue Apr 03 2007 - 06:50:33 CEST