Oracle Database Online Documentation 11g Release 2 (11.2)

Essentials

2 Day + Data Warehousing Guide

Introduces the data warehousing solutions available in Oracle Database and discusses how to perform common day-to-day tasks necessary to implement and administer a data warehouse. This guide also provides information about design tasks needed to keep the data warehouse operational, including how to perform basic performance monitoring tasks.

Download As...

PDF for offline viewing

Supporting Documentation

Supporting documentation treats advanced topics related to Data Warehousing and Business Intelligence. In general, the 2 Day + books refer you to these topics when needed.

Data Warehousing Guide

Provides conceptual, reference, and implementation material for using Oracle Database 11g in data warehousing. It covers the full range of data warehousing activities, from physical database design to advanced calculation techniques.

Download As...

PDF for offline viewing

Performance Tuning Guide

Describes how to tune the performance of Oracle Database and SQL statements using Oracle performance tools in the command-line interface.

Download As...

PDF for offline viewing

VLDB and Partitioning Guide

Provides conceptual, reference, and implementation material for using very large databases (VLDB). It emphasizes partitioning as a key component of a VLDB strategy.

Download As...

PDF for offline viewing

Utilities

Describes how to use Oracle Database utilities to load data into a database, transfer data between databases, and maintain data. The topics discussed include Data Pump Export, Data Pump Import, SQL*Loader, external tables and associated access drivers, the Automatic Diagnostic Repository Command Interpreter (ADRCI), DBVERIFY, DBNEWID, LogMiner, the Metadata API, original Export, and original Import.

Download As...

PDF for offline viewing

Oracle Warehouse Builder

Oracle Warehouse Builder (OWB) enables the design and deployment of enterprise data warehouses, data marts, and e-business intelligence applications.

Warehouse Builder Concepts

Provides an introduction to the benefits of using Oracle Warehouse Builder and its architecture and components. It also includes quick start steps, a user interface tour, and provides information about OWB preferences and OWB editors and wizards.

Download As...

PDF for offline viewing

Warehouse Builder Sources and Targets Guide

Describes data sources and targets for Oracle Warehouse Builder data warehouses and data integration systems. This guide also lists all the supported sources and targets and provides procedures for importing from sources and deploying to targets.

Download As...

PDF for offline viewing

Warehouse Builder API and Scripting Reference

Describes the application programming interfaces and scripting language available with Oracle Warehouse Builder. It also includes information about creating Experts and Guided Assistants.

Download As...

PDF for offline viewing

Warehouse Builder Installation and Administration Guide

Describes installing the software and configuring Oracle Warehouse Builder (OWB). Part II of this guide provides procedures for administering OWB.

Download As...

PDF for offline viewing

Warehouse Builder Data Modeling, ETL, and Data Quality Guide

Provides comprehensive procedures for loading data from sources, designing target schemas, transforming data, generating code, and performing all the tasks for optimizing and managing data quality in a data management system.

Download As...

PDF for offline viewing

Warehouse Builder OMB*Plus Command Reference

Provides a complete language reference for OMB and OMU commands, which comprise OMB*Plus. OMB*Plus is the programming language included with Oracle Warehouse Builder.

Download As...

Warehouse Builder Release Notes

Contains late-breaking information about corrections, troubleshooting, and known issues for DB 11.2.0.4

Download As...

PDF for offline viewing

Data Warehousing Guide

Provides conceptual, reference, and implementation material for using Oracle Database 11g in data warehousing. It covers the full range of data warehousing activities, from physical database design to advanced calculation techniques.

Download As...

PDF for offline viewing

VLDB and Partitioning Guide

Provides conceptual, reference, and implementation material for using very large databases (VLDB). It emphasizes partitioning as a key component of a VLDB strategy.

Download As...

PDF for offline viewing

Online Analytical Processing (OLAP)

Online Analytical Processing (OLAP) analyzes data from a data warehouse, for business processes such as forecasting, planning, and what-if analysis.

OLAP User's Guide

Explains how SQL applications can extend their analytic processing capabilities and manage summary data by using the OLAP option of Oracle Database.

Download As...

PDF for offline viewing

OLAP Customizing Analytic Workspace Manager

Describes the Analytic Workspace Manager XML and Java plug-in interfaces and provides simple examples.

Download As...

PDF for offline viewing

OLAP DML Reference

Contains a complete description of the OLAP Data Manipulation Language (OLAP DML) used to define and manipulate analytic workspace objects.

Download As...

PDF for offline viewing

OLAP Expression Syntax Reference

Describes the Oracle OLAP Expression Syntax used to generate information-rich content from the data stored in dimensional database objects such as cubes and cube dimensions.

Download As...

PDF for offline viewing

OLAP Java API Developer's Guide

Provides guidance for developing client applications using the Oracle OLAP Java API.

Download As...

PDF for offline viewing

OLAP Java API Reference (Javadoc)

Provides reference information for the Oracle OLAP Java API.

Download As...

Using the OLAP APIs (Virtual Book)

No summary available.

Download As...

Oracle Advanced Analytics

Oracle Advanced Analytics extends the database into a comprehensive advanced analytics platform, including predictive analytics, data mining and text mining, statistical analysis, and advanced analytics. Advanced Analytics has two components, Oracle Data Mining and Oracle R Enterprise.

Data Mining Concepts

Discusses the basic concepts underlying Oracle Data Mining. Includes information about mining functions, algorithms, data preparation, and predictive analytics.

Download As...

PDF for offline viewing

Data Mining Application Developer's Guide

Discusses the programmatic interfaces to Oracle Data Mining.

Download As...

PDF for offline viewing

Data Mining Administrator's Guide

Documents installation, administration, and upgrade procedures for Oracle Data Mining.

Download As...

PDF for offline viewing

Data Mining Java API Reference (Javadoc)

Documents the Oracle Extensions to JSR-73, the Java standard API for data mining. The Oracle Data Mining Java API is deprecated in this release.

Download As...

Data Mining API Guide (Virtual Book)

No summary available.

Download As...

R Enterprise Release Notes

Provides key information about the current release of Oracle R Enterprise, including new features, requirements, and bugs that have been fixed

Download As...

PDF for offline viewing

R Enterprise Installation and Administration Guide

Provides instructions for installing and administering Oracle R Enterprise.

Download As...

PDF for offline viewing

R Enterprise User's Guide

Explains how to use the R language and Oracle R Enterprise packages to perform statistical analysis on data in an Oracle database.

Download As...

PDF for offline viewing

Communications Data Model

Communications Data Model Installation Guide

Describes how to install and configure the Oracle Communications Data Model.

Download As...

PDF for offline viewing

Communications Data Model Implementation and Operations Guide

Describes how you create and maintain a data warehouse based on the Oracle Communications Data Model.

Download As...

PDF for offline viewing

Communications Data Model Reference

Describes the data model structures for Oracle Communications Data Model.

Download As...

PDF for offline viewing

Communications Data Model Release Notes

Describes known issues with Oracle Communications Data Model.

Download As...

PDF for offline viewing

Airlines Data Model

Oracle Airlines Data Model is a data warehouse and business intelligence solution optimized for the airline industry.

Airlines Data Model Installation Guide

Describes how to install the Oracle Airlines Data Model.

Download As...

PDF for offline viewing

Airlines Data Model Implementation and Operations Guide

Describes best practices for implementing a data warehouse based on the Oracle Airlines Data Model.

Download As...

PDF for offline viewing

Airlines Data Model Reference

Describes the data model structures for Oracle Airlines Data Model.

Download As...

PDF for offline viewing

Airlines Data Model Release Notes

Describes known issues with Oracle Airlines Data Model.

Download As...

PDF for offline viewing

Retail Data Model

Oracle Retail Data Model is a pre-built retail-specific data warehouse solution set that supports the data warehouse foundation and analytical needs of retailers and is based on the Association for Retail Technology Standards (ARTS).

Retail Data Model Implementation and Operations Guide

Describes how you create and maintain a data warehouse based on the Oracle Retail Data Model.

Download As...

PDF for offline viewing

Retail Data Model Installation Guide

Describes how to install the Oracle Retail Data Model.

Download As...

PDF for offline viewing

Retail Data Model Reference

Contains technical information about the various components and objects in Oracle Retail Data Model.

Download As...

PDF for offline viewing

Retail Data Model Release Notes

Describes known issues for Oracle Retail Data Model

Download As...

PDF for offline viewing