Skip Navigation

Oracle Database Online Documentation 11g Release 2 (11.2)

Data Warehousing and Business Intelligence

Data Warehousing involves large volumes of data used primarily for analysis. This category covers applications such as Business Intelligence and Decision Support Systems.

Essentials

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

Mobi for Kindle

ePub for iBooks and mobile devices

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.

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

Oracle Warehouse Builder

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

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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...

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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.

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides reference information for the Oracle OLAP Java API.
No other download option available.
Download As...
No summary available.
No summary available.
No other download option 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.

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

Mobi for Kindle

ePub for iBooks and mobile devices

Discusses the programmatic interfaces to Oracle Data Mining.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
No other download option available.
Download As...
No summary available.
No summary available.
No other download option available.
Download As...
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

Mobi for Kindle

ePub for iBooks and mobile devices

Provides instructions for installing and administering Oracle R Enterprise.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

Communications Data Model

Communications Data Model is a normalized data model optimized for Oracle data warehouses.
Describes how to install and configure the Oracle Communications Data Model.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the data model structures for Oracle Communications Data Model.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes known issues with Oracle Communications Data Model.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Airlines Data Model

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

Describes how to install the Oracle Airlines Data Model.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the data model structures for Oracle Airlines Data Model.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes known issues with Oracle Airlines Data Model.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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).

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install the Oracle Retail Data Model.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes known issues for Oracle Retail Data Model
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices