As a parallel to my question about Useful stock SQL datasets, I wonder if anyone has come across a library/web page/wiki/etc. that contains stock SQL data models. For example, the problem of maintaining table(s) for login credentials is faced by countless developers. Are any of you aware of a data model that provides a best-practices implementation of this table? What about other use cases? I'm thinking about things like inventory control, sales reporting, application events (login, logout, viewing a given page or item, etc.). I came across a great resource at databaseanswers.org, but wonder if there are any other resources I should take a look at.
As with my question on data sets, I'm looking for things that can readily incorporated into an application, fulfill a generic need that many developers have, and something that is not specific to a single industry or business sector. Address books, login credential tables, messaging, etc. all fall into the criteri开发者_开发百科a I'm thinking about.
Any thoughts?
Have you seen the SO question relational-database-design-patterns?
EDIT: Having got interested in this question I had a look for any books on the subject and found the following volumes:
The Data Model Resource Book: A Library of Universal Data Models for All Enterprises: Vol 1
The Data Model Resource Book: A Library of Universal Data Models by Industry Types: Vol 2
The Data Model Resource Book: Universal Patterns for Data Modeling Vol 3
I've not read the series, so I can't recommend them myself, but they look interesting.
Here is a list of professional standard scbemas of ebXML: http://docs.oasis-open.org/ubl/os-UBL-2.0/xsd/maindoc/
They are not exactly "Data models" but schemas for message exchanging, but can help you model your data.
Avoid use "Standard data models" (like the dbanswers), they are poor, and can't address even the most common scenarios.
精彩评论