Useful stocks of SQL data models?

Question

As a parallel to my question about Useful SQL Data Stocks , I wonder if anyone came across a library / webpage / wiki / etc. which holds stocks of SQL data models. For example, the problem of saving tables for login credentials is faced with countless developers. Do any of you know the data model that provides the best practices for this table? What about other use cases? I think of such things as inventory management, sales reports, application events (logging in, logging out, viewing a given page or item, etc.). I came across an excellent databaseanswers.org resource, but I wonder if there are any other resources that I should pay attention to.

As in my question about datasets, I am looking for things that can easily be included in the application, fulfill the common need that many developers have, and something that does not apply to any industry or business sector. Address books, login credentials tables, messaging, etc. Relate to all the criteria that I think of.

Any thoughts?

Answer 1

Have you seen the SO relational-database-design-patterns question?

EDIT : Being interested in this question, I looked for any books on this issue and found the following volumes:

Resource Data Model Book: Universal Data Model Library for All Enterprises: Volume 1

Data Model Resource Book: Library of Generic Data Models by Industry Type: Volume 2

Resource Data Model Book: Generic Data Modeling Vol 3

I have not read the series, so I cannot recommend them myself, but they look interesting.

Answer 2

Here is a list of professional standard scbemas ebXML: http://docs.oasis-open.org/ubl/os-UBL-2.0/xsd/maindoc/

They are not exactly “data models,” but messaging schemes, but they can help you model your data.

Avoid using "Standard data models" (for example, dbanswers), they are poor and cannot address even the most common scenarios.