Flylib.com
List of Figures
Previous page
Table of content
Next page
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.
Previous page
Table of content
Next page
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
Java I/O
The jar Tool
Filename Filters
Filtered Readers and Writers
The Generic Connection Framework
The Bluetooth Protocol
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
Formatting Your Spreadsheets
Working with Data Types
Building Support for Vectors
Introduction
Doubling Your Money
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
LAN Basics
DSL Technology
3G: Moving Toward Broadband Wireless
Beyond 3G
The IP Multimedia Subsystem
.NET-A Complete Development Cycle
Evaluating .NET for Windows Client Applications
The Project Vision and Business Case
Refined Requirements for Online Photo Shop
Design of the Photo Editor Application
Advanced GDI+ Extensions
Understanding Digital Signal Processing (2nd Edition)
ANALYZING LINEAR TIME-INVARIANT SYSTEMS
BILINEAR TRANSFORM IIR FILTER DESIGN METHOD
BANDPASS QUADRATURE SIGNALS IN THE FREQUENCY DOMAIN
COMPLEX DOWN-CONVERSION
Appendix A. The Arithmetic of Complex Numbers
Digital Character Animation 3 (No. 3)
Facial Rigging
Acting Vs. Animating
Acting Technique
Chapter Ten. Directing and Filmmaking
Conclusion
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