Franklin

DB2 OLAP Server V8.1 : Using Advanced Functions.

Other records:
Author/Creator:
Redbooks, IBM.
Publication:
Durham : I B M, 2002.
Format/Description:
Book
1 online resource (544 pages)
Subjects:
IBM Database 2.
Database management.
OLAP technology.
Form/Genre:
Electronic books.
Contents:
Front cover
Contents
Figures
Tables
Examples
Notices
Trademarks
Preface
The team that wrote this redbook
Become a published author
Comments welcome
Part 1 Introduction
Chapter 1. DB2 OLAP Server V8.1 overview
1.1 Advanced analytical functions
1.1.1 Combining OLAP and relational databases: Hybrid Analysis
1.1.2 OLAP Miner
1.2 Advanced enterprise functions
1.3 Advanced administrative functions
1.3.1 Parallel calculation
1.3.2 Parallel data load
1.3.3 Parallel export
1.3.4 Administration Services
1.3.5 Security Migration Tool
1.3.6 Custom Defined Functions and Custom Defined Macros
1.3.7 API enhancements
1.3.8 Additional improvements and new functions
Chapter 2. DB2 OLAP Server components and case studies
2.1 DB2 OLAP Server components architecture
2.1.1 The basic DB2 OLAP Server installation
2.1.2 Expanding OLAP capabilities with Integration Server
2.1.3 Expanding with Enterprise Services
2.1.4 Expanding with Administration Services
2.1.5 Using Security Migration Tool
2.1.6 Using Analyzer
2.1.7 The big picture
2.2 Case studies and our test environment
2.2.1 E-banking case study
2.2.2 Online Investment case study
2.2.3 Our test environment setup
Part 2 Advanced analytical functions
Chapter 3. Hybrid Analysis
3.1 Hybrid Analysis overview
3.1.1 Terminology and definitions
3.2 When to use Hybrid Analysis
3.3 Hybrid Analysis architecture
3.4 Hybrid Analysis challenges
3.5 Implementation of Hybrid Analysis
3.5.1 Building Hybrid Analysis using Integration Server
3.5.2 Hybrid Analysis member transformation
3.5.3 Impact of Hybrid Analysis versus multidimensional
3.5.4 Hybrid Analysis in Application Manager
3.5.5 Hybrid Analysis and Administration Services.
3.6 Tips and tricks for tuning Hybrid OLAP applications
3.6.1 Defining HAMEMORYCACHESIZE
3.6.2 Defining HAMAXNUMCONNECTION
3.6.3 Defining HAMAXNUMSQLQUERY
3.6.4 Defining HAMAXQUERYROWS
3.6.5 Defining HAMAXQUERYTIME
3.6.6 Defining HARETRIEVENUMROW
3.6.7 Conclusions: Hybrid Analysis configuration settings
3.7 Queries in the Hybrid Analysis environment
3.7.1 Member caching for better query performance
3.8 Query performance
3.9 Hybrid Analysis and Drill-Through Reports
3.9.1 Characteristics of Drill-Through Reports
3.9.2 Characteristics of Hybrid Analysis
3.9.3 Drill-Through Reports versus Hybrid Analysis
3.10 Data modeling for Hybrid Analysis
3.11 Security configuration for Hybrid Analysis
3.11.1 Tracing Hybrid Analysis
Chapter 4. Mining your OLAP cube with OLAP Miner
4.1 OLAP Miner overview
4.2 Deviation detection in OLAP Miner
4.2.1 OLAP Miner performance
4.3 When to use OLAP Miner, and when not to use it
4.4 Mining and interpreting E-banking cube results
4.4.1 Scenario 1: PC-banking usage by branch
4.4.2 Scenario 2: Equity trade and Net-banking in branches
4.5 OLAP Miner setup and architecture
4.6 Running and monitoring OLAP Miner
4.6.1 Getting OLAP Miner to run, and stopping it
4.6.2 OLAP Miner client configuration
4.7 OLAP Miner results and logs
Part 3 Advanced functions of Enterprise Services
Chapter 5. Enterprise Services
5.1 Enterprise Services overview
5.1.1 Enterprise Services components
5.2 Enterprise Services configurations
5.2.1 TCP/IP Client Programs
5.2.2 HTTP client programs
5.2.3 EJB client programs
5.2.4 CORBA client programs
5.3 Enterprise Services deployment scenarios
5.3.1 Scalability overview
5.3.2 Clustering
5.3.3 Connection pooling
5.3.4 Workload balancing.
5.3.5 Server and application failure and failover
5.3.6 Enterprise Services: the whole picture
5.3.7 Guidelines for implementing a full cluster of OLAP servers
5.3.8 Copy DB2 OLAP applications and databases across servers
5.3.9 Synchronizing data across DB2 OLAP Servers in a cluster
5.3.10 Synchronizing security across all OLAP Servers in a cluster
5.4 Implementing Enterprise Services with TCP/IP
5.4.1 Installation tips for Enterprise Services: Windows and AIX
5.4.2 Setting up the domain storage
5.4.3 Starting Enterprise Services
5.4.4 Creating a domain
5.4.5 Defining users
5.4.6 Defining DB2 OLAP Server and Enterprise Services servers
5.4.7 Creating clusters
5.4.8 Creating connection pools
5.4.9 Using the sample programs
5.4.10 Additional tasks
Part 4 Advanced administrative functions
Chapter 6. Parallel calculation, data load, and export
6.1 Performing parallel calculation
6.1.1 Understanding parallel calculation
6.1.2 Parallel calculation architecture
6.1.3 Requirements
6.1.4 Enabling parallel calculation
6.1.5 Identifying concurrent tasks for parallel calculation
6.1.6 Running parallel calculation
6.1.7 Parallel calculation performance
6.1.8 Monitoring using the log
6.1.9 Estimating the size of a database calculation
6.2 Performing parallel load
6.2.1 Understanding the parallel load
6.2.2 Enabling parallel load
6.2.3 Running parallel data load
6.2.4 Monitoring using the log
6.2.5 Parallel load performance: Defining the right parameters
6.2.6 Tools to monitor parallel calculation and load
6.3 Performing parallel export
6.3.1 Running parallel export
6.3.2 Monitoring using the log
6.3.3 Parallel export performance
6.3.4 Exporting files larger than 2 GB
Chapter 7. Administration Services
7.1 Administration Services components.
7.2 New administrative capabilities
7.3 Administration Services configurations
7.4 Using Administration Services
7.4.1 Managing security
7.4.2 Managing DB2 OLAP Servers, applications, and databases
7.4.3 Managing logs
7.4.4 Managing scripts
7.4.5 Miscellaneous
7.5 Implementing Administration Services
7.5.1 Preparing for installation
7.5.2 Installing DB2 OLAP Server components
7.5.3 Installing Administration Services
7.5.4 Starting Administration Services
7.5.5 Setting up users
7.5.6 Backing up Administration Services users information
7.5.7 Creating views
Chapter 8. Additional enhancements
8.1 Direct I/O
8.1.1 Understanding the DB2 OLAP Server caches
8.1.2 The difference between buffered I/O and direct I/O
8.1.3 New features in DB2 OLAP Server version 8.1
8.1.4 Changing the I/O access mode (buffered I/O or direct I/O)
8.1.5 The cache memory locking option
8.1.6 Defining the DB2 OLAP Server caches when using direct I/O
8.2 Security Migration Tool
8.2.1 Before running the Security Migration Tool
8.2.2 Running the Security Migration Tool
8.3 Multiple OLAP agents on the same machine
8.3.1 Hints and tips
8.3.2 A sample configuration scenario
8.4 Custom Defined Functions
8.4.1 Software requirements
8.4.2 Performance considerations in the Windows environment
8.4.3 Creating a CDF
8.4.4 Using a CDF in the outline
8.4.5 Using a CDF in calculations
Part 5 Appendixes
Appendix A. DB2 OLAP Integration Server
A.1 Integration Server enhancements
A.2 Migration of earlier OLAP metadata catalogs
A.2.1 New configuration file for Integration Server
A.2.2 Multiple data sources in Integration Server
A.2.3 Drill through
A.2.4 XML export/import of models and metaoutlines
A.2.5 Intelligent help and increased usability.
Appendix B. Setting up DB2 OLAP Analyzer Analysis Server V8.1
B.1 Analyzer V8.1 overview
B.1.1 Supported platforms
B.1.2 Architectural overview
B.2 WebSphere Application Server setup
B.3 Setting up and configuring Analyzer Server V8.1
B.3.1 Configuring Analyzer
B.3.2 Uninstalling Analyzer V8.1
B.4 Using Analyzer V8.1
B.4.1 Analyzer Server console
B.4.2 Analyzer Administration Tool
Appendix C. Enterprise Services sample programs
C.1 Copy application/database using CopyOLAP
C.2 Sample runsamples.cmd script
Appendix D. Data modeling basics
D.1 ER data models
D.2 Multidimensional data models: star and snowflake
Related publications
IBM Redbooks
Other resources
Referenced Web sites
How to get IBM Redbooks
IBM Redbooks collections
Index
Back cover.
Notes:
Description based on publisher supplied metadata and other sources.
Local notes:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2021. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Other format:
Print version: Redbooks, IBM DB2 OLAP Server V8.1
ISBN:
9780738427096
OCLC:
560313409
Loading...
Location Notes Your Loan Policy
Description Status Barcode Your Loan Policy