List of Figures

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.



Oracle9iR2 Data Warehousing
Oracle9iR2 Data Warehousing
ISBN: 1555582877
EAN: 2147483647
Year: 2005
Pages: 91

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net