Book description
The only book to cover and compare Oracle's online analytic processing products
With the acquisition of Hyperion Systems in 2007, Oracle finds itself owning the two most capable OLAP products on the market--Essbase and the OLAP Option to the Oracle Database. Written by the most knowledgeable experts on both Essbase and Oracle OLAP, this Oracle Press guide explains how these products are similar and how they differ. Oracle Essbase & Oracle OLAP will help you architect the Oracle OLAP product that is most appropriate for your application, and build, tune, and maintain OLAP solutions.
Table of contents
- Cover Page
- Oracle Essbase & Oracle OLAP
- Copyright Page
- Contents
- Foreword
- Acknowledgments
- Introduction
- 1 Introduction to OLAP
-
2 OLAP Concepts and History
- Common OLAP Themes
-
The History of Oracle OLAP
- Why a Multidimensional Database?
- 1960s to 1985—Glory Days of Mainframe Express
- 1985 to 1990—A New C-Based Engine
- 1990 to 1996—Express Goes GUI
- 1995 to 1997—Oracle Buys and Markets Express
- 1998 to 2001—Integrating Express into the Oracle Database
- 2002 to 2003—Oracle9i OLAP
- 2004 to 2006—Oracle OLAP 10g
- 2007 to 2009—Oracle OLAP 11g
- 2009 and Beyond
- The History of Essbase
- Conclusion
-
3 Design and Overall Methodology
-
General Design Principles
- Design Is an Iterative Process
- User Requirements Drive Design
- What’s Left Out Is as Important as What Goes In
- Dimension Types Offer Convenience
- Data Types Improve Data Quality
- Different Uses Require Different Views of the Data
- User Access and Security Needs Planning
- Allow Areas for Training and Testing
- Designing an Oracle OLAP Analytic Workspace
- Designing an Essbase Database
- OLAP Architectures
- Conclusion
-
General Design Principles
- 4 Building an Oracle OLAP Analytic Workspace
- 5 Building Your Essbase Database
- 6 Reporting from an OLAP Application
- 7 Leveraging OLAP in Your Organization
- 8 Keeping It Running
- 9 Real-World Examples
- Glossary
- Index
Product information
- Title: Oracle Essbase & Oracle OLAP
- Author(s):
- Release date: December 2009
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071627382
You might also like
book
Pro Oracle Spatial for Oracle Database 11g
Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Database's built-in …
book
Oracle Business Intelligence 11g Developers Guide
Master Oracle Business Intelligence 11 g Reports and Dashboards Deliver meaningful business information to users anytime, …
book
Oracle Essbase 9 Implementation Guide
Develop high-performance multidimensional analytic OLAP solutions with Oracle Essbase 9 with this book and eBook About …
book
Oracle Database 12c The Complete Reference
Master the Cutting-Edge Features of Oracle Database 12c Maintain a scalable, highly available enterprise platform and …