Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Where can I find ready-to-use database models ?

I don't need a database with data in it, but only schemas (UML diagrams). Perhaps something like the data models at this link, but much more complex and real world.

share|improve this question
When I attempt to view one of those models I get the following warning: contains content from, a site known to distribute malware. Your computer might catch a virus if you visit this site... – onedaywhen Feb 14 '12 at 11:50
link works, I relay don't know where is the problem at your computer. I am using Ubuntu and Firefox. – tasmaniski Feb 14 '12 at 11:56
Your link works for me but clicking on the links to one of the models (e.g. Customers at a Bank) brings up the warning. I'm using Windows 7 and Chrome. – onedaywhen Feb 14 '12 at 13:31
FWIW - Of the examples of models I've seen at my impression has always been that they are very simplistic and not representative of good real world data models. – Joel Brown Feb 14 '12 at 14:00
Yes, Because of that I ask for much more complex example .. in real world of course :) – tasmaniski Feb 14 '12 at 14:35
up vote 11 down vote accepted

David Hay's

Len Silverston's

Michael Blaha's Patterns of Data Modeling. This one has some interesting temporal, graph, and tree models.

Martin Fowler's Analysis Patterns. This one skims some of the other patterns, but gives accounting a solid treatment.

They are all well-rated, and I have read all but one, and they are all very good. Several of them are available on safaribooksonline.

Also, OASIS's Universal Business Language, schemas

share|improve this answer
very good answer, unfortunately, does not answer the specific question, Thanks! But what to do, I accept answer like that :D – tasmaniski Sep 13 '12 at 14:59
well, Hay's models are available but I think he charges $10,000 for them! – Neil McGuigan Oct 23 '12 at 0:49
Tried to get Hay's "Enterprise Model Patterns" as an ebook but couldn't get it anywhere. How does it compare to his other books "Data Model Patterns: A Metadata Map" & "Data Model Patterns: Conventions of Thought", which are available as ebooks? – Mike81 Feb 7 '14 at 23:28
@Mike81 I'd say it's the most thorough of the three. It's available on which has a free 10-day trial. – Neil McGuigan Feb 7 '14 at 23:31
  • If it's more complex than the free data models you've mentioned, then I'd suggest it is a custom model for your requirement.

  • Anything complex would most likely be commercial, propriety or otherwise someone's IP
    For example, a datamodel for an MMORPG or a derivatives trading system

What are you trying to do anyway?

share|improve this answer
Just to find good practice that I can use in my database. I need some set of social-network DB and movies DB. I am tired of theory books, so I need to see how things work in practice. If you know some not free stuff, it would be OK ... – tasmaniski Feb 14 '12 at 11:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.