View online
Other Language Versions
Note: Other language versions may not be as current as the English edition.
More options
Others who downloaded this publication also downloaded ...
Abstract
OLAP has evolved into a mainstream information technology and it is a major component of Business Intelligence solutions across all industries today.
The increasing demands for analyzing large amounts of data and empowering a growing number of employees throughout the enterprise to make informed business decisions are pushing the limits of OLAP solutions. Although leading OLAP products, such as DB2 OLAP Server, provide for high levels of platform scalability, it is the design of the models that ultimately determine how well the system is performing and how easy it is to adjust them to fit new business requirements.
This IBM Redbooks publication will provide valuable insight into successful design approaches for building OLAP solutions based on DB2 OLAP Server. It will help architects, data modelers, and implementers of Business Intelligence solutions to understand and avoid design and implementation issues.
Table of contents
Chapter 1. Introducing OLAP
1.1 Best practice begins with good theory
1.2 The role of theory in OLAP practice
1.3 Position dependence versus position independence
1.4 A different data model at a very fundamental level
1.5 The issue of data redundancy
1.6 DB2 OLAP multidimensional databases are matrices
1.7 The data block and index explained
1.8 Other multidimensional design guidelines
1.9 Summary
Chapter 2. OLAP model development checklist
2.1 Introduction
2.2 The OLAP checklist
Chapter 3. Project management for OLAP
3.1 Importance of project management for OLAP
3.2 OLAP project issues
3.3 Implementing an OLAP project
3.4 Acceptance testing
Chapter 4. Tuning, good design practices, and useful tips
4.1 Prototyping an outline
4.2 Database tuning introduction
4.3 Basic matrix database concepts
4.4 Tuning the outline
4.5 Considerations on database calculation
4.6 Performance tuning: the buffers
4.7 Data compression
4.8 Using SET MSG ONLY
4.9 Intelligent calculation
4.10 Miscellaneous issues
4.11 Final comment
Chapter 5. Interviews and experiences
5.1 Introduction
5.2 Interview results
Appendix A. OLAP datamart design approaches
Appendix B. Integration Server implementation guidelines
Appendix C. Case study: example of end-to-end approach
Appendix D. Considerations for getting the best OLAP delivery
Appendix E. Web log incorporation
Appendix F. OLAP model development short checklist