Oracle9iR2 Data Warehousing
Chapter 1: Data Warehousing
- Figure 1.1: Enterprise data warehouse with dependent data marts.
Chapter 2: Designing a Warehouse
- Figure 2.1: Dimensional modeling.
- Figure 2.2: Normalized versus dimensional normal form.
- Figure 2.3: Dimensional model for Easy Shopping Inc.
- Figure 2.4: Oracle Database Configuration Assistant—naming the database.
- Figure 2.5: Oracle Database Configuration Assistant—initialization parameters.
- Figure 2.6: Oracle Database Configuration Assistant—file location variables.
- Figure 2.7: Oracle Database Configuration Assistant—database features.
- Figure 2.8: Oracle Database Configuration Assistant—database storage.
- Figure 2.9: Oracle Enterprise Manager—create a user.
- Figure 2.10: Oracle Enterprise Manager Console—schemas.
- Figure 2.11: Oracle Enterprise Manager Console—tablespaces.
- Figure 2.12: Oracle Enterprise Manager Console—dimension.
- Figure 2.13: Oracle Enterprise Manager Console—Table Wizard.
- Figure 2.14: Oracle Enterprise Manager Console—table columns.
- Figure 2.15: Oracle Enterprise Manager Console—constraints.
- Figure 2.16: Table Wizard—specifying the primary key.
- Figure 2.17: Oracle Enterprise Manager—null constraint.
- Figure 2.18: Oracle Enterprise Manager—foreign key.
- Figure 2.19: Oracle Enterprise Manager—check constraints.
- Figure 2.20: Oracle Enterprise Manager—viewing constraints.
- Figure 2.21: Table Wizard— final screen.
- Figure 2.22: Oracle Enterprise Manager—indexes.
- Figure 2.23: Partitioning.
- Figure 2.24: Table Wizard—partitioning screen.
- Figure 2.25: Table Wizard—partitioning criteria.
- Figure 2.26: Oracle Enterprise Manager—object security.
Chapter 3: Data Warehouse Features
- Figure 3.1: Creating a bitmap index in Oracle Enterprise Manager.
- Figure 3.2: Range partitioning.
- Figure 3.3: Hash partitioning.
- Figure 3.4: List partitioning.
- Figure 3.5: Range-hash composite partitioning.
- Figure 3.6: Global index.
- Figure 3.7: Prefixed local index.
- Figure 3.8: Nonprefixed local index.
- Figure 3.9: PARTITION BY clause.
- Figure 3.10: Parallel query.
Chapter 4: Summary Management
- Figure 4.1: Creating a materialized view in Oracle Enterprise Manager.
- Figure 4.2: Refreshing a materialized view in Oracle Enterprise Manager.
- Figure 4.3: Refreshing a materialized view in Oracle Enterprise Manager—Options.
- Figure 4.4: Partition change tracking.
- Figure 4.5: EXPLAIN_MVIEW in Oracle Enterprise Manager
- Figure 4.6: Bubble diagram for the geography dimension.
- Figure 4.7: Bubble diagram for the time dimension.
- Figure 4.8: A normalized dimension.
- Figure 4.9: Summary Advisor Wizard—loading the workload.
- Figure 4.10: Summary Advisor Wizard—filters.
- Figure 4.11: Summary Advisor Wizard—recommendation graph.
- Figure 4.12: Summary Advisor Wizard—view/modify recommendations.
- Figure 4.13: Summary Advisor Wizard—implement recommendations.
- Figure 4.14: Summary Advisor report.
Chapter 5: Loading Data into the Warehouse
- Figure 5.1: The ETL process.
- Figure 5.2: Change data capture publish/ subscribe architecture.
- Figure 5.3: Querying change data.
- Figure 5.4: The use of surrogate keys in the warehouse.
- Figure 5.5: The Load Wizard.
- Figure 5.6: Accessing the Load Wizard.
- Figure 5.7: The control file.
- Figure 5.8: SQL*Loader modes of operation.
- Figure 5.9: SQL*Loader advanced options.
- Figure 5.10: Scheduling the load.
- Figure 5.11: Monitoring jobs from the OEM console.
- Figure 5.12: SQL*Loader parallel direct path load.
- Figure 5.13: External table.
- Figure 5.14: Transportable tablespaces.
- Figure 5.15: Multitable insert.
- Figure 5.16: Data is moved from a staging table into the fact table.
- Figure 5.17: Viewing a table's partitions using enterprise manager.
- Figure 5.18: Exchange partition.
- Figure 5.19: Using Oracle Enterprise Manager to look for stale materialized views.
- Figure 5.20: Refresh options.
- Figure 5.21: Explain materialized view.
- Figure 5.22: Analyzing the materialized view after refresh.
Chapter 6: Oracle Warehousing Tools
- Figure 6.1: Warehouse Builder—steps to setup.
- Figure 6.2: Warehouse Builder—creating a module.
- Figure 6.3: Warehouse Builder—type of data source.
- Figure 6.4: Warehouse Builder—data source defined.
- Figure 6.5: Warehouse Builder—two modules created.
- Figure 6.6: Warehouse Builder—import a table.
- Figure 6.7: Warehouse Builder—manually define a table.
- Figure 6.8: Warehouse Builder—Warehouse Module Editor.
- Figure 6.9: Warehouse Builder—dimension hierarchy.
- Figure 6.10: Warehouse Builder—fact table creation.
- Figure 6.11: Warehouse Builder—Fact Table Editor.
- Figure 6.12: Supplied functions for transformations.
- Figure 6.13: Mapping Editor.
- Figure 6.14: Mapping Editor with joins.
- Figure 6.15: Product key lookup.
- Figure 6.16: Filtering source data.
- Figure 6.17: Validating the design.
- Figure 6.18: Validation progress.
- Figure 6.19: Implementing the design.
- Figure 6.20: Code generated by Oracle Warehouse Builder.
- Figure 6.21: Configuring the physical design.
- Figure 6.22: Bitmapped index recommendations.
- Figure 6.23: Discoverer Viewer—executing our query.
- Figure 6.24: Discoverer Viewer—category sales by month report.
- Figure 6.25: Discoverer Viewer—presentations options (screen 1).
- Figure 6.26: Discoverer Viewer—presentations options (screen 2).
- Figure 6.27: Discoverer Viewer—presentations options (screen 3).
- Figure 6.28: Discoverer Administrator—create an EUL.
- Figure 6.29: Discoverer Administrator—task list.
- Figure 6.30: Discoverer Administrator—select the schema.
- Figure 6.31: Discoverer Administrator—select the tables and views.
- Figure 6.32: Discoverer Administrator—automatic joins.
- Figure 6.33: Administrator—naming the business area.
- Figure 6.34: Discoverer Administrator—setting up the business area.
- Figure 6.35: Discoverer Administrator—change the item details.
- Figure 6.36: Discoverer Administrator—define a join.
- Figure 6.37: Discoverer Administrator—creating a calculated item.
- Figure 6.38: Discoverer Administrator—defining a hierarchy.
- Figure 6.39: Discoverer Administrator—item class.
- Figure 6.40: Discoverer Administrator—creating a summary.
- Figure 6.41: Discoverer Administrator—refreshing the summary.
- Figure 6.42: Discoverer Administrator—Summary Wizard.
- Figure 6.43: Administrator—granting access to the business area.
- Figure 6.44: Discoverer Administrator—business area.
- Figure 6.45: Discoverer Plus—list of databases for connection.
- Figure 6.46: Discoverer Plus—using a workbook.
- Figure 6.47: Discoverer Plus—selecting data to be displayed.
- Figure 6.48: Discoverer Plus—table layout.
- Figure 6.49: Discoverer Plus—format headings.
- Figure 6.50: Discoverer Plus—sorting the data.
- Figure 6.51: Discoverer Plus—defining totals.
- Figure 6.52: Discoverer Plus—report.
- Figure 6.53: Discoverer Plus—customize the report.
- Figure 6.54: Discoverer Plus—SQL Inspector.
- Figure 6.55: Discoverer Plus—drilling up/down the data.
- Figure 6.56: Discoverer Plus—report at the month level.
- Figure 6.57: Discoverer Plus—Graph Wizard.
- Figure 6.58: Discoverer Plus—graph of monthly sales.
- Figure 6.59: Discoverer Plus—select specific data.
- Figure 6.60: Discoverer Plus—report using conditions.
Chapter 7: Managing the Warehouse
- Figure 7.1: Launching the Oracle Enterprise Manager Console.
- Figure 7.2: Oracle Enterprise Manager Console.
- Figure 7.3: The Enterprise Manager Navigator window.
- Figure 7.4: Creating an Enterprise Manager administrator account.
- Figure 7.5: Creating a group.
- Figure 7.6: Group—Easy Shopping Inc.
- Figure 7.7: Creating an event.
- Figure 7.8: Selecting events to monitor.
- Figure 7.9: Advising users of an event.
- Figure 7.10: Notification schedule for events.
- Figure 7.11: Creating a job.
- Figure 7.12: Selecting task for a job.
- Figure 7.13: Parameters for a job.
- Figure 7.14: Scheduling a job.
- Figure 7.15: Watching a job run.
- Figure 7.16: Logging from the job.
- Figure 7.17: Output from the job.
- Figure 7.18: Starting applications from the console.
- Figure 7.19: Creating a backup configuration.
- Figure 7.20: Selecting the channels in a backup configuration.
- Figure 7.21: Backup frequency.
- Figure 7.22: Backup configuration selection.
- Figure 7.23: Selecting the database.
- Figure 7.24: Reviewing the backup procedure.
- Figure 7.25: Backup Job on the console job queue.
- Figure 7.26: Type of custom backup.
- Figure 7.27: Including backup job in library.
- Figure 7.28: Incremental backup level.
- Figure 7.29: Selecting an incremental backup.
- Figure 7.30: Selecting a tablespace to back up.
- Figure 7.31: Making a tablespace read-only.
- Figure 7.32: Backup file sizes.
- Figure 7.33: Recovery catalog.
- Figure 7.34: RMAN schema report showing the target database.
- Figure 7.35: RMAN lists the contents of a backup.
- Figure 7.36: RMAN report files needing backup.
- Figure 7.37: Selecting type of restore.
- Figure 7.38: Location of data files.
- Figure 7.39: Recovery configuration.
- Figure 7.40: Recovery log.
- Figure 7.41: Data guard configuration.
- Figure 7.42: Partition maintenance.
- Figure 7.43: Merge partition.
- Figure 7.44: Split partition.
- Figure 7.45: Outline management.
- Figure 7.46: The original outline.
- Figure 7.47: Changing the join order.
- Figure 7.48: Executing the query with a revised outline.
- Figure 7.49: Creating a role.
- Figure 7.50: Allocating a role to a user.
- Figure 7.51: Space utilization.
Chapter 8: Data Warehousing and the Web
- Figure 8.1: Signing into the Oracle portal.
- Figure 8.2: Oracle portal—standard view.
- Figure 8.3: Discoverer Viewer Report from our browser.
- Figure 8.4: Discoverer Viewer—specify reporting criteria.
- Figure 8.5: Discoverer Plus—Export Wizard—specify output format.
- Figure 8.6: Oracle Reports—select the reporting medium.
- Figure 8.7: Choosing the style of report and title.
- Figure 8.8: Oracle files—selecting the data source.
- Figure 8.9: Oracle Reports—specifying the SQL query.
- Figure 8.10: Oracle Reports—using the Query Builder.
- Figure 8.11: Oracle Reports—specifying the grouping levels.
- Figure 8.12: Oracle Reports—selecting the fields in the report.
- Figure 8.13: Oracle Reports—calculate totals.
- Figure 8.14: Oracle Reports—specify the column widths.
- Figure 8.15: Oracle Reports—final report.
- Figure 8.16: Oracle Reports—matrix report.
- Figure 8.17: Oracle Reports—conditional report.
- Figure 8.18: Oracle Reports—Navigator and Designer.
- Figure 8.19: Oracle Reports in Web format.
- Figure 8.20: Oracle Reports Server—select the report.
- Figure 8.21: Oracle Reports Server—specify the output format.
- Figure 8.22: Oracle Reports Server—schedule a report.
- Figure 8.23: Oracle Reports Server—job queue.
Chapter 9: Oracle 9i OLAP and Data Mining
- Figure 9.1: OLAP 9i Release 2 architecture.
- Figure 9.2: Level-based versus parent-child dimension tables.
- Figure 9.3: Conceptual view of a variable.
- Figure 9.4: OLAP worksheet in Oracle Enterprise Manager.
- Figure 9.5: Application access to analytical workspaces.
- Figure 9.6: Dimensions for OLAP in Oracle Enterprise Manager.
- Figure 9.7: Cube Wizard—choosing fact tables.
- Figure 9.8: Cube Wizard—choosing dimensions.
- Figure 9.9: Cube Wizard—joining dimension and fact tables.
- Figure 9.10: Cube Wizard—specifying measures.
- Figure 9.11: Cube Wizard—summary screen.
- Figure 9.12: Cube Viewer.
- Figure 9.13: Analytic Workspace Manager.
- Figure 9.14: Analytic Workspace Creation Wizard— Select Cubes.
- Figure 9.15: Analytic Workspace Creation Wizard— Select Analytic Workspace.
- Figure 9.16: Analytic Workspace Creation Wizard— Enable Workspace for OLAP API & BI Beans.
- Figure 9.17: New Presentation Wizard.
- Figure 9.18: New Presentation Wizard—choosing measures and dimensions.
- Figure 9.19: Layout of a crosstab.
- Figure 9.20: Choosing dimension members.
- Figure 9.21: The EASYDW sales analysis report.
- Figure 9.22: Customizing the content with Query Wizard—Conditions.
- Figure 9.23: EASYDW analysis report with top ten products.
- Figure 9.24: Customizing the crosstab look and feel.
- Figure 9.25: Data-driven formatting.
- Figure 9.26: Specifying data-driven formatting rules.
- Figure 9.27: Specifying a condition on purchase price.
- Figure 9.28: EASYDW analysis report with badly performing products highlighted.
- Figure 9.29: Graphs.
- Figure 9.30: Specifying the layout of a graph.
- Figure 9.31: Graph of product sales by county.
- Figure 9.32: Drilling down in the graph.
- Figure 9.33: Creating a calculation.
- Figure 9.34: Specifying the parameters of the calculation.
- Figure 9.35: Graphing a Calculation
- Figure 9.36: Association rules.
- Figure 9.37: Clustering.
- Figure 9.38: Classification.
- Figure 9.39: Confusion matrix.
- Figure 9.40: Using lift analysis for targeted promotions.
- Figure 9.41: Adaptive Bayes Network decision tree.
- Figure 9.42: Table formats for data mining.