Oracle Data Warehousing and Business Intelligence Solutions

Oracle Data Warehousing and Business Intelligence Solutions

  • ただいまウェブストアではご注文を受け付けておりません。 ⇒古書を探す
  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 386 p.
  • 言語 ENG
  • 商品コード 9780471919216
  • DDC分類 005.7565

Full Description


Up-to-date, comprehensive coverage of the Oracle database and business intelligence tools Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools.You'll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you'll get valuable tips and insight based on the authors' real-world experiences and their own implementations. Avoid many common pitfalls while learning best practices for:* Leveraging Oracle technologies to design, build, and manage data warehouses* Integrating specific database and business intelligence solutions from other vendors* Using the new suite of Oracle business intelligence tools to analyze data for marketing, sales, and more* Handling typical data warehouse performance challenges* Uncovering initiatives by your business community, security business sponsorship, project staffing, and managing risk

Table of Contents

Acknowledgments                                    xv
Introduction xvii
Part I Oracle Business Intelligence Defined 1 (90)
Oracle Business Intelligence 3 (24)
Business Intelligence and Transactional 4 (5)
Applications
Daily Business Intelligence 5 (1)
Balanced Scorecard 6 (2)
Enterprise Planning and Budgeting 8 (1)
Activity-Based Management 9 (1)
Oracle Integration Components Enabling 9 (3)
Business Intelligence
Data Hubs 10 (1)
Business Activity Monitoring 10 (1)
BPEL Process Manager 11 (1)
Enterprise Messaging Service 11 (1)
Custom Data Warehouse Solutions 12 (12)
The Role of the Oracle Database 14 (1)
Oracle Warehouse Builder 15 (1)
Oracle Business Intelligence Standard 16 (2)
Edition
Oracle Business Intelligence Enterprise 18 (2)
Edition
BI (XML) Publisher 20 (1)
Oracle Portal 20 (1)
Spreadsheet Add-ins 21 (2)
Building Custom Business Intelligence 23 (1)
Applications
Emerging Trends 24 (3)
Oracle's Transactional Business Intelligence 27 (26)
Transactional Business Intelligence 28 (2)
Business Terminology 28 (2)
Oracle's Daily Business Intelligence 30 (15)
How DBI Works 33 (1)
Varieties of DBI 34 (11)
Balanced Scorecards 45 (4)
Oracle Balanced Scorecard Structure 46 (2)
OBSC Architecture 48 (1)
Creating an Oracle Balanced Scorecard 48 (1)
Data Hubs 49 (3)
The Oracle Customer Data Hub 49 (2)
How Data Hubs Work 51 (1)
Other Oracle Data Hubs 51 (1)
Is Transactional Business Intelligence 52 (1)
Enough?
Introduction to Oracle Data Warehousing 53 (22)
Oracle Data Warehousing Basics 54 (16)
Oracle Database Analysis and Schema 55 (9)
Considerations
Managing an Oracle-based Data Warehouse 64 (6)
Where to Start? 70 (5)
Oracle/PeopleSoft EPM 71 (2)
Oracle/Siebel Business Analytics 73 (1)
Applications
Choosing Completely Custom 74 (1)
Choosing a Platform 75 (16)
Scaling Up Platforms Versus Scaling Out 76 (8)
Hardware Platforms 77 (3)
Cost Considerations 80 (1)
Availability Considerations 80 (3)
Manageability Considerations 83 (1)
Sizing the Platform 84 (6)
Information Needed for Warehouse 85 (1)
Hardware Sizing
Benchmarking 86 (3)
Sizing Hardware for Business 89 (1)
Intelligence Tools
Your Strategy 90 (1)
Part II Custom-Built Data Warehousing 91 (184)
Solutions
Designing for Usability 93 (34)
Approaches for Design 94 (32)
Key Design Considerations 94 (4)
Features for Design --- Enhancing 98 (8)
Performance
Business Scenario 106 (2)
Normalized Design 108 (2)
Dimensional Design 110 (3)
Hybrid Design 113 (3)
Online Analytical Processing Design 116 (4)
Other Considerations 120 (6)
Selecting the Best Approach 126 (1)
Business Intelligence Tools 127 (48)
Oracle Portal and Portal Products 128 (8)
Using Oracle Portal 129 (3)
Building and Deploying Oracle Portal 132 (4)
and Portlets
Reporting 136 (6)
BI/XML Publisher 137 (3)
Oracle Reports 140 (1)
Oracle BI Reporting Workbench (Actuate) 141 (1)
Ad hoc Query and Analysis 142 (23)
Business Intelligence Enterprise Edition 143 (10)
Discoverer and Business Intelligence 153 (9)
Standard Edition
Oracle Spreadsheet Add-ins 162 (3)
Building Business Intelligence 165 (4)
Applications
JDeveloper and BI Beans 166 (1)
Data Miner 166 (3)
Other Tools 169 (6)
Data Loading 175 (20)
Oracle Database Data Loading Features 176 (5)
Embedded ETL in the Oracle Database 177 (1)
SQL*Loader 178 (1)
Change Data Capture 179 (1)
Transportable Tablespaces 180 (1)
Data Pump 180 (1)
Oracle Warehouse Builder 181 (11)
OWB Packaging 181 (1)
Typical Steps when using OWB 182 (2)
ETL Design in OWB 184 (5)
OWB and Dimensional Models 189 (2)
The OWB Process Editor 191 (1)
Balancing Data Loading Choices 192 (3)
Managing the Oracle Data Warehouse 195 (32)
Oracle Enterprise Manager Grid Control 196 (28)
Database Performance Monitoring 200 (2)
Database Administration 202 (16)
Database Maintenance 218 (5)
Database Topology 223 (1)
Management and Management Options 224 (3)
Data Warehouse Performance Tuning and 227 (48)
Monitoring
Understanding Performance Challenges 228 (10)
Who Is Responsible? 228 (3)
Causes of Poor Performance 231 (7)
Successful Approaches to Performance 238 (19)
Tuning
Critical Tasks for Performance Tuning 239 (5)
Lifecycle
Hardware Configuration 244 (3)
Software Configuration 247 (9)
Database Application Design 256 (1)
Business Scenario: Tuning Our Sample 257 (16)
Solution
Where To Start 257 (1)
Enterprise Manager Advisory Framework 258 (15)
Approaches for Success 273 (2)
Part III Best Practices 275 (90)
Scoping the Effort and an Approach for 277 (30)
Success
Uncovering Key Business Initiatives 278 (4)
Where to Start 278 (2)
Information Sources 280 (2)
What is Important 282 (1)
Accountability and Securing Business 282 (2)
Sponsorship
Establish a Steering Committee 283 (1)
Project Review Board 283 (1)
Endorsing a Methodology 284 (9)
Choices of Methodologies 284 (1)
A Business-focused Approach 285 (8)
Staffing the Project 293 (8)
Organization Structure 293 (6)
End-User Experience 299 (2)
Engaging the Business: Education and 301 (1)
Training
Managing Risk 301 (4)
Communication --- Managing Expectations 301 (1)
Contingency Allocation 302 (1)
Financial Risk 303 (1)
Technology Risk 304 (1)
No Place to Shortcut 305 (2)
Understanding Business Needs 307 (22)
How Bad Deployment Choices Impact the 308 (6)
Business
Independent Data Marts 308 (2)
Limited and Inflexible Reporting 310 (1)
Sources of Information Limited to 311 (1)
Internal Data
Limited Data History 311 (1)
Lack of Current High-Quality Data 312 (1)
Limited Growth Flexibility 313 (1)
Project Drivers and Business Types 314 (12)
Financial Companies 314 (2)
Healthcare 316 (2)
Manufacturing 318 (1)
Media and Entertainment 319 (1)
Retail 319 (1)
Telecommunications 320 (1)
Other Business Types: Transportation 321 (1)
and Utilities
Educational Institutions 321 (2)
Government Agencies 323 (3)
Developing Scope and Gaining Business 326 (3)
Support
Justifying Projects and Claiming Success 329 (36)
Concept to Project 330 (1)
Business Constraints 330 (1)
Where to Start Justification 330 (1)
Measuring Value 331 (25)
Common Metrics to Measure 332 (17)
Common Budgeting Techniques 349 (7)
Total Cost of Ownership 356 (4)
Modeling Total Cost of Ownership 357 (3)
Return on Investment 360 (3)
Modeling Return on Investment 360 (3)
Claiming Success 363 (2)
Index 365