为什么在线完整数据库模式样本如此之少?
对我来说,数据库模式示例有点奇怪,我认为大多数项目都需要为其设计数据库。 但是当我尝试在线查找示例时,它确实很少见(例如库存管理、学校管理、人力资源管理的完整数据库模式)。 我知道每个数据库设计都取决于项目需求,但我认为没有太大不同。
我只是想知道为什么很少有人把它当作其他源代码放在网上。
有人可以指出我在哪里可以得到它或有任何建议吗?
提前致谢
It is a bit strange to me about database schemas sample which I think most of the projects will need to design a database for it. but when I try to find sample online, it is really rare (eg. full database schema for Inventory Management, School Management, HumanResource management). I know that each database design is depends on the project requirement, but I don't think it is much different.
I just wonder why there is so few people kick it online as other source code.
Could anyone pointing me out where to get it or any advice?
Thanks in advance
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
这必须是数据库架构上的 ueber-list。 这是亚马逊上的有趣的阅读列表。 我可以推荐伦·西尔弗斯顿的书。 他们会帮助你开始。
This must be the ueber-list on database schemas. And here's an interesting reading list on Amazon. I can recommend the Len Silverston books. They will get you started.
我想说,有很多数据库模式。
SQL Server 7/2000 附带“pubs”和“Northwind”,您仍然可以从 CodePlex 下载它们。
SQL Server 2005 附带 AdventureWorks,它非常广泛并且有各种版本(OLTP、OLAP、Light) - 也可以从 CodePlex 获得。
许多博主都有用于博客和截屏视频的示例数据库,例如 Rob Bagby 有一个供学校使用的数据库数据和他博客上的一家酿酒厂的数据。
Codeplex 上还有其他几个(旨在最终摆脱使用臭名昭著的 Northwind 数据库进行演示)。
马克
There are plenty of database schemas out there, I'd say.
SQL Server 7/2000 schipped with "pubs" and "Northwind" which you can still download from CodePlex.
SQL Server 2005 shipped with AdventureWorks, which is quite extensive and available in various versions (OLTP, OLAP, Light) - also available from CodePlex.
Many bloggers have sample databases they use for their blogs and their screencasts, e.g. Rob Bagby has one for school data and one for a winery on his blog.
There are several more (aimed at finally getting rid of using the notorious Northwind database for demos) on Codeplex.
Marc
为什么不查看开源项目的模式以及使用它们的代码呢? 对于 CMS 模式,有 Wordpress、Drupal 和无数其他模式;对于 CRM 模式,有 SugarCRM 等。
Why not look at open source projects for schemas along with the code that use them? For CMS schemas, there're Wordpress, Drupal and a zillion others, for CRM schemas, SugarCRM etc.