MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook
暫譯: Microsoft SQL Server 2008 R2 分析服務 MDX 食譜

Tomislav Piasevoli

  • 出版商: Packt Publishing
  • 出版日期: 2011-07-25
  • 售價: $2,110
  • 貴賓價: 9.5$2,005
  • 語言: 英文
  • 頁數: 480
  • 裝訂: Paperback
  • ISBN: 1849681309
  • ISBN-13: 9781849681308
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

商品描述

MDX-related books often dedicate a significant part of their content to explaining the concepts of multidimensional cubes, the MDX language and its functions, and other specifics related to working with Analysis Services. And that's perfectly fine, there should be books like that, the tutorials that teach the concepts. However, that also means that when it comes to examples, there's usually not enough space to provide all the details about them and their variations, otherwise the book would become huge or oftentimes lose its focus. The result of that is that making a step further from the provided calculations and queries might not be an easy task for an average reader. The other problem with tutorials is that the solution to a particular problem might be scattered throughout the book, which is where the cookbook style of books like this one come into play. Similar to data warehouses where we consolidate many tables of the relational database into a few and then organize those dimension tables in a topic-based star schema, in cookbooks we aggregate the information about a particular problem in form of one or more recipes and present that topic-based knowledge in full detail. Both the relational databases and the data warehouses have their purpose; it's not uncommon to see them together in one place. The same is true about books and their approaches. What we also know is that there are far too few data warehouses than relational databases. Again, the same is with MDX-related cookbooks in respect to MDX tutorials, particularly those dealing with advanced topics. As a writer, I hope you recognize my intention and the value this book could bring you. As a reader, we rarely have enough time to start reading a book, not to mention f nish it. This is another advantage of the cookbook format. You can browse through the contents and look for the solution to a particular problem. As the recipes are relatively short and organized in chapters, that task won't take much of your time. All the information will be in one place. In addition to that, you'll see which recipes are related to that one, so that you can learn even more.

商品描述(中文翻譯)

MDX 相關的書籍通常會將相當一部分內容用於解釋多維立方體的概念、MDX 語言及其功能,以及與使用 Analysis Services 相關的其他細節。這樣的書籍是非常必要的,因為它們提供了教學概念的教程。然而,這也意味著在舉例時,通常沒有足夠的空間來提供所有細節及其變化,否則書籍會變得龐大,或常常失去焦點。這樣的結果是,對於一般讀者來說,從提供的計算和查詢中進一步深入可能不是一件容易的事。教程的另一個問題是,針對特定問題的解決方案可能散佈在整本書中,這就是像這本書這樣的食譜風格書籍發揮作用的地方。類似於數據倉庫,我們將關聯數據庫中的許多表整合成幾個,然後將這些維度表組織成基於主題的星型架構,在食譜書中,我們將有關特定問題的信息以一個或多個食譜的形式聚合,並詳細呈現該主題的知識。關聯數據庫和數據倉庫各有其用途;在同一地方看到它們並不罕見。書籍及其方法也是如此。我們還知道,數據倉庫的數量遠少於關聯數據庫。同樣,MDX 相關的食譜書在 MDX 教程方面也相對較少,特別是那些涉及高級主題的書籍。作為一名作者,我希望你能理解我的意圖以及這本書能為你帶來的價值。作為讀者,我們很少有足夠的時間開始閱讀一本書,更不用說完成它了。這是食譜格式的另一個優勢。你可以瀏覽內容,尋找特定問題的解決方案。由於食譜相對簡短且按章節組織,這項任務不會佔用你太多時間。所有信息都會集中在一個地方。此外,你還會看到哪些食譜與該食譜相關,這樣你可以學到更多。