Flylib.com
Oracle9iR2 Data Warehousing
Oracle9iR2 Data Warehousing
ISBN: 1555582877
EAN: 2147483647
Year: 2005
Pages: 91
Authors:
Lilian Hobbs
,
Susan Hillson MS in CIS Boston University
,
Shilpa Lawande
BUY ON AMAZON
Table of Contents
Back Cover
Oracle 9iR2 Data Warehousing
Foreword
Preface
Chapter 1: Data Warehousing
What is a data warehouse?
A historical perspective
Oracle 9i
Building a data warehouse poses many challenges
The future of data warehousing
Chapter 2: Designing a Warehouse
Other design considerations
Implementing the design
Testing the design
The schema for Easy Shopping Inc.
Chapter 3: Data Warehouse Features
Indexing
Data partitioning
Data compression
Query optimization techniques
Automatic memory management
SQL functions
Parallelism
Summary
Chapter 4: Summary Management
Creating a materialized view
Refresh
EXPLAIN_MVIEW utility
Dimensions
Query rewrite
Summary Advisor
Summary
Chapter 5: Loading Data into the Warehouse
Extracting data from the operational systems
Transforming the data into a common representation
Loading the warehouse
Transformations inside the Oracle Server
Postload operations
Using tools for the ETL process
Summary
Chapter 6: Oracle Warehousing Tools
Oracle Warehouse Builder
Oracle Discoverer
Chapter 7: Managing the Warehouse
Managing using Oracle Enterprise Manager
Backup and recovery
Disaster recovery
Reorganizing the warehouse
Refreshing the warehouse
Gathering optimizer statistics
Parallel management tasks
Tuning the warehouse
Maintaining security
Monitoring space use
Other management issues
Summary
Chapter 8: Data Warehousing and the Web
Oracle 9i Application Server
Oracle 9i Reports
The data warehouse and e-business intelligence
Chapter 9: Oracle 9i OLAP and Data Mining
Oracle Data Mining
Summary
Appendix
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_H
index_I
index_J
index_K
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
List of Figures
List of Tables
Oracle9iR2 Data Warehousing
ISBN: 1555582877
EAN: 2147483647
Year: 2005
Pages: 91
Authors:
Lilian Hobbs
,
Susan Hillson MS in CIS Boston University
,
Shilpa Lawande
BUY ON AMAZON
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Why Project Risk Management?
Managing Project Constraints and Documenting Risks
Quantifying and Analyzing Activity Risks
Managing Activity Risks
Conclusion
VBScript Programmers Reference
Variables and Procedures
Error Handling and Debugging
Super-Charged Client-Side Scripting
Appendix I VBScript Features not in VBA
Appendix J VBA Features not in VBScript
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 280 Surge Arresters
Article 344 Rigid Metal Conduit Type RMC
Article 388 Surface Nonmetallic Raceways
Article 408: Switchboards and Panelboards
Annex C. Conduit and Tubing Fill Tables for Conductors and Fixture Wires of the Same Size
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
Hardware Overview
Configuring Accounting
TFTP
Architectural Overview
IPS Management Using ASDM
What is Lean Six Sigma
Key #1: Delight Your Customers with Speed and Quality
Key #2: Improve Your Processes
Beyond the Basics: The Five Laws of Lean Six Sigma
When Companies Start Using Lean Six Sigma
Making Improvements That Last: An Illustrated Guide to DMAIC and the Lean Six Sigma Toolkit
The Oracle Hackers Handbook: Hacking and Defending Oracle
Overview of the Oracle RDBMS
The Oracle Network Architecture
Triggers
Indirect Privilege Escalation
Appendix A Default Usernames and Passwords
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies