Overview
Plan and build a robust data warehousing and analysis solution. Officially authorized by Oracle Corporation,this resource explains how to create a single integrated source of corporate business information.Create a Single Integrated Source of Corporate Business Information Take full advantage of all the new Oracle8i tools and functionality to build a robust data warehousing system. Officially authorized by Oracle Corporation,Oracle8i Data Warehousing explains how to leverage Oracle's powerful family of technologies to build a reliable,scalable data warehousing and business intelligence infrastructure. You'll get full details on developing a plan,putting together a team,implementing your data warehouse,writing queries,and giving end-users direct access to their data. The book also explains how to use Oracle's integrated query analysis and reporting software,including Oracle Discoverer and the Oracle Data Mining Suite.
- Plan,implement,and manage a data warehouse project
- Build star schemas and design data marts
- Set up a data warehouse using Oracle8i as its repository
- Extract,transform,and load data using the Oracle Warehouse Builder
- Index your data warehouse for optimal access
- Manage storage and handle backup,recovery,tuning,and security
- Enable data warehouse querying and analysis with Oracle Discoverer and Oracle Express
- Convert a legacy database system into an Oracle8i data warehouse
- Implement data webhousing to enable access via an intranet or the Internet