有用的库存 SQL 数据模型吗?
与我关于有用的股票 SQL 数据集的问题类似,我想知道是否有人遇到过图书馆/网页/wiki/等等。包含库存 SQL 数据模型。例如,无数开发人员都面临着维护登录凭据表的问题。你们中有人知道提供此表最佳实践实现的数据模型吗?其他用例怎么样?我正在考虑诸如库存控制、销售报告、应用程序事件(登录、注销、查看给定页面或项目等)之类的事情。我在 databaseanswers.org 上发现了一个很棒的资源,但想知道是否还有其他资源我应该看看的资源。
与我关于数据集的问题一样,我正在寻找可以轻松合并到应用程序中的东西,满足许多开发人员的通用需求,以及不特定于单个行业或业务部门的东西。地址簿、登录凭证表、消息传递等都属于我正在考虑的标准。
有什么想法吗?
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 criteria I'm thinking about.
Any thoughts?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您是否看过SO问题relational-database-design-patterns?
编辑:
对这个问题感兴趣后,我查找了有关该主题的任何书籍,并找到了以下几卷:
数据模型资源书籍:适用于所有企业的通用数据模型库:第 1 卷
数据模型资源书籍:按行业类型划分的通用数据模型库:第 2 卷
数据模型资源手册:通用模式Data Modeling Vol 3
我还没有读过该系列,所以我自己不能推荐它们,但它们看起来很有趣。
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.
以下是ebXML的专业标准scbemas列表:
http://docs.oasis-open.org/ubl/ os-UBL-2.0/xsd/maindoc/
它们并不完全是“数据模型”,而是消息交换的模式,但可以帮助您对数据进行建模。
避免使用“标准数据模型”(如 dbanswers),它们很差,甚至无法解决最常见的场景。
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.