OLAP Solutions: Building Multidimensional Information Systems, 2/e
- 出版商: Wiley
- 出版日期: 2002-04-18
- 售價: $1,500
- 貴賓價: 9.8 折 $1,470
- 語言: 英文
- 頁數: 696
- 裝訂: Paperback
- ISBN: 0471400300
- ISBN-13: 9780471400301
OLAP enables users to access information from multidimensional data
warehouses almost instantly, to view information in any way they like, and to
cleanly specify and carry out sophisticated calculations. Although many
commercial OLAP tools and products are now available, OLAP is still a difficult
and complex technology to master.
* Substantially updated with expanded coverage of implementation methods for data storage, access, and calculation; also, new chapters added to combine OLAP with data warehouse, mining, and decision support tools
* Teaches the best practices for building OLAP models that improve business and organizational decision-making, completely independent of commercial tools, using revised case studies
* Companion Web site provides updates on OLAP standards and tools, code examples, and links to valuable resources
Table of Contents
PART ONE: THE NEED FOR MULTIDIMENSIONAL TECHNOLOGY.
The Functional Requirements of OLAP Systems.
The Limitations of Spreadsheets and SQL.
Thinking Clearly in N Dimensions.
PART TWO: CORE TECHNOLOGY.
Introducton to the LC Model.
The Internal Structure of a Dimension.
Hypercubes or Semantic Spaces.
Physical Design of Applications.
PART THREE: APPLICATIONS.
Practical Steps for Designing and Implementing OLAP Models.
Introduction to the Foodcakes Application Example.
Purchasing and Currency Exchange.
Materials Inventory Analysis.
FCI's Sales and Marketing.
FCI's Activity-Based Manegement.
A Computational Example.
PART FOUR: FURTHER ISSUES.
Product Language Comparisons.
Appendix A: Formula Index.
Appendix B: Standards in the OLAP Marketplace.
Appendix C: LC Language Constructs.
Appendix D: Glossary.
Appendix E: The Relationship Between Dimensions and Variables.
Appendix F: Toward a Theoretically Grounded Model for OLAP and Its Conection to the Relational Model and Canonical Logic.
Appendix G: Codd's 18 Features.