如何理解AdventureWorks2008 DB的业务
我试图理解 AdventureWorks 数据库，因为网络和书籍上的大多数好例子通常都是以它作为示例数据库来解释的。
我发现了一些链接，例如
- http://msdn.microsoft .com/en-us/library/ms124825(v=sql.100).aspx
- http://merc.tv/img/fig/AdventureWorks2008_Conceptual.pdf
- http:// Merc.tv/img/fig/AdventureWorks2008.gif
但我发现它们不足以完全解释业务。 我也尝试练习一些查询，以便对它的业务有更多的了解。但看了70张桌子，我发现自己对其业务还没有了解。
您能帮我点个赞吗，这样我就可以了解更多详细信息。
编辑
我从来没有读过northwind数据库。为了更好地掌握 AdventureWorks2008，理解它是否重要？
I am trying to understand AdventureWorks Database as most of the good examples on web and books are usually explained taking it as a sample database.
I found few links like
- http://msdn.microsoft.com/en-us/library/ms124825(v=sql.100).aspx
- http://merc.tv/img/fig/AdventureWorks2008_Conceptual.pdf
- http://merc.tv/img/fig/AdventureWorks2008.gif
But I found them insufficient for explaining the business completely.
I tried to practice some queries as well so that I could get more knowledge about its business. But looking at 70 tables, I finds myself no were in the understanding of its Business.
Can you help me giving some good likes where I can get more details about it.
EDIT
I never read northwind database. Is it important to understand it to get a good grasp on AdventureWorks2008
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
从你所做的事情来看，我认为你是否完全了解AW业务并不重要。如果您能更好地利用时间来了解所需的查询以及相关的 2-3 个表，而不是整个数据库。
即使 MSTS 认证书籍取自 AW DB，但了解数据库不是认证的一部分。如果您对书中的具体问题有疑问，我建议您发布您正在做的事情以及您想要实现的结果。
Looking into what you are doing, I think it is not important for you to fully understand the AW business. If would be a better use of your time to understand the queries that are required and just the 2-3 tables in question rather than the entire database.
Even thought the MSTS certification book pulls from the AW DB, understanding that database is not part of the certification. If you have trouble with specific questions from your book, I would suggest you post what you are doing and what result you are trying to achieve.
我可以继续解释AW的业务，但是会消耗很多时间，因为我不能完全给出业务理解。你只会理解我在这里描述的那些事情。我目前正在阅读这本书——Ralph Kimball 所著的《Microsoft Datawarehouse Toolkit》。这是一本能让您详细了解AW业务的最佳书籍。
业务需求来自于各种各样的人。从销售人员到技术人员等。因此，我建议您阅读本书的前 3 章，因为它可以简化业务学习。
如果阅读不可行，我将向您展示另一种方法：
AdventureWorks (AW) 是一家虚构的自行车及其配件制造商和销售商（Table Production.ProductCategory）。
这些模式对于理解他们的业务、销售、员工数据和产品信息有很大帮助。
AW数据库涉及的模式有：HumanResources、Person、Production、Purchasing、Sales。
表名在很大程度上是不言自明的。对每个表进行简单的查询将为您提供大量有关数据的信息。
您可以浏览此链接，其中简要概述了 AW 中使用的模式
https://technet.microsoft.com/en- us/library/ms124894(v=sql.100).aspx
将自己想象为面试官，然后提出要向 AW 的官员/经理询问的问题。相信我，如果你是新手，会有很多陷阱。例如，如果您向业务部门提出这样的问题：“您希望数据仓库中有什么？”错误的。这是你要弄清楚的工作。
探索一切顺利。
I can go on explaining the business of AW but it will consume a lot of time as I cannot completely give the business understanding. You will only understand those things that I will describe here. I am currently going through this book- The Microsoft Datawarehouse Toolkit by Ralph Kimball. This is the best book that will give you a detailed understanding of AW business.
The business requirements ranges from a variety of people. From sales to technical people and others. So I suggest you read the first 3 chapters of this book as it simplifies learning the business.
If reading is not feasible I will show you another approach:
AdventureWorks (AW) is an imaginary manufacturer and seller of bicycles and its accessories (Table Production.ProductCategory).
The schemas help a lot in understanding their business, sales, employee data and product info.
The schemas involved in AW database are: HumanResources, Person, Production, Purchasing, Sales.
The table names are self-explanatory to a great extent. A simple query against each table will give you a fair amount of information about data.
You can go through this link that gives a brief overview of schemas used in AW
https://technet.microsoft.com/en-us/library/ms124894(v=sql.100).aspx
Think of yourself an interviewer and then frame questions that you will be asking the officers/managers of AW. Trust me there are lot of pitfalls if you are a newbie. Like, if you ask the question to business: "What do you want in your datawarehouse?" WRONG. This is your job to figure out.
All the best with exploration.
我在下面找到了这个链接，如果您根据您感兴趣的示例数据库点击该链接，它会解释它的全部内容：
https://msdn.microsoft.com/en-us/library/ms124501(v=sql.100).aspx
我有还发现了此 ETL（但无法找到其他数据库）：
http:/ /msftdbprodsamples.codeplex.com/wikipage?title=%20AdventureWorksLTDiagram&referringTitle=AWSchemaDiag
我还找到了这些练习：
http://sqlzoo.net/wiki/AdventureWorks
I have found this link below which if you follow the link depending on which sample database you are interested, it explains what it is all about:
https://msdn.microsoft.com/en-us/library/ms124501(v=sql.100).aspx
I have also fouund this ETL (but could not find for other databases):
http://msftdbprodsamples.codeplex.com/wikipage?title=%20AdventureWorksLTDiagram&referringTitle=AWSchemaDiag
I have also found these exercises:
http://sqlzoo.net/wiki/AdventureWorks