Overview
A practical guide to successful data warehouse analysis,build,and roll-out.Your Expert Guide to Building and Launching Your Data Warehouse Data warehousing — large-scale data storage and analysis — is among the most important areas of enterprise computing today. Master data warehousing with the book officially authorized by Oracle Corporation,the leading provider of data warehousing solutions to Fortune 1000 companies.
Written by a solid team of Oracle and data warehousing experts — Oracle8 Data Warehousing is your tactical guide to every important facet of data warehousing with Oracle8. Whether you are a database administrator,an information technology manager,or a data warehouse team member,you'll find this book loaded with valuable advice on planning,building,rolling out,and maintaining your data warehouse for optimal performance.
This book will help you to:
- Understand the Oracle Express Server data warehousing solution.
- Investigate the physical components of a data warehouse including table size,expansion,disk stripping,and table partitioning
- Build an effective warehousing team and gain real-world insight into the business rationale that secures essential management buy-in
- Optimize the Oracle8 server for decision support.
- Make critical technical decisions such as choosing RAID technology,running the cost-based optimizer,as well as using read-only table space and warehouse refresh mechanisms
- Convert a legacy database system into an Oracle datawarehouse.
- Gain a complete overview of data extraction,transformation,and loading into the Oracle8 repository
- Learn the basics of ROLAP,MOLAP,and OLAP
From general concepts to Oracle8's specific warehousing capabilities,Oracle8 Data Warehousing is all you need.