Fog Creek Software
Discussion Board




Data modeling best practices


What are the best print or web resources for examples of relational data models that have been used in real applications and can be adapted for new applications?

Data modeling newbie
Wednesday, July 23, 2003

http://www.thearling.com/

Li-fan Chen
Wednesday, July 23, 2003

Oops.. excuse me.. I thought you said data mining.. my eyes...

Li-fan Chen
Wednesday, July 23, 2003

http://www.agiledata.org/

Colin Evans
Wednesday, July 23, 2003

Seeing the table structures of other database applications will help you learn how to design a database structure for your own needs, but unless needs are close to identical (which happens rarely) you don't really "adapt" one to your needs.  (Anyway I never have.)  You may just identify conceptual similarities and make use of them, when appropriate.

Here's a link to a good white paper, "Understanding Relational Database Design" that you can download from the MSDN site:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q234208

There is a wealth of other information on data modeling on MSDN that you could search for.

Herbert Sitz
Wednesday, July 23, 2003

I concur about http://www.agiledata.org; excellent resource.

Two books I wouldn't be without:

Terry Halpern, Conceptual Schema & Relational Database 1995 Prentice Hall
ISBN 0 13 355702 2

Bit long in the tooth now, but an excellent approach to data modelling that, IMHO, explains not just how to describe entities, but also how to identify their existence in the first place. This is sadly lacking in many other books which tend to skate over this step.

Thomas Connolly & Carolyn Begg, Database Systems - A Practical Approach to Design, Implementation & Management
2002 Addison Wesley
ISBN 0 201 70857 4

A good, undergraduate introduction to databases, including warehouse and data mart models.

One book I'd avoid like the plague is UML for Database Design by Eric Naiburg & Robert Makssimchuk. I think I know a bit about both data modelling and UML and this book explained neither! Read Scott Ambler's papers on agiledata.org, I think they're much better.

David Roper
Wednesday, July 23, 2003

I could give you a ton of references on normalizing etc. But that was NOT your question.

Here is web site of examples.

I can't say they are the best...but there is lots....

http://www.databaseanswers.com/data_models/index.htm

Albert D. Kallal
Edmonton, Alberta Canada
kallal@msn.com
http://www.attcanada.net/~kallal.msn

Albert D. Kallal
Wednesday, July 23, 2003

*  Recent Topics

*  Fog Creek Home