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.
Asked
Active
Viewed 2.3k times
29
-
When I attempt to view one of those models I get the following warning: www.databaseanswers.org contains content from novikkoll.in, 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 http://www.databaseanswers.org/data_models/index.htm 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
-
http://databaseanswers.org is now down. I have switched the link in the question to point to a recent archive copy: https://web.archive.org/web/20191123175222/http://www.databaseanswers.org/data_models/ – icc97 Jun 20 '22 at 10:50
-
For what it's worth I like databaseanswers.org. Where as 'ready to use' is too much to ask, I definitely think it is a fairly detailed 'generic starting point' that you can customise or compare your database model too. – icc97 Jun 20 '22 at 10:55
2 Answers
36
David Hay's
- Enterprise Model Patterns. This is a beast of a book, but has some great patterns.
- Conventions of Thought. More stuff on MRP.
- A Meta-Data Map . Haven't read this one.
Len Silverston's
- Data Model Resource Book Vol. 1. Your main data model patterns.
- Data Model Resource Book Vol. 2. Case studies by industry.
- Data Model Resource Book Vol. 3. A deeper explanation of Vol 1.
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
Neil McGuigan
- 8,423
- 4
- 39
- 56
4
If it's more complex than the free data models you've mentioned, then I'd suggest it is a custom model for your requirements.
Anything complex would most likely be commercial, proprietary, or otherwise someone's IP.
For example, a data model for an MMORPG or a derivatives trading system.
What are you trying to do anyway?
Mihai Chelaru
- 109
- 4
gbn
- 69,809
- 8
- 163
- 243