Oracle Database Online Documentation 12c Release 1 (12.1)

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.

Supporting Documentation

Data Warehousing Guide

Provides conceptual, reference, and implementation material for using Oracle Database 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

ePub for iBooks and mobile devices

Mobi for Kindle

Performance Tuning Guide

Provides information about how to tune the performance of Oracle Database using Oracle performance tools.

Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

SQL Tuning Guide

Describes how to perform SQL tuning, which is the iterative process of improving SQL statement performance to meet specific, measurable, and achievable goals.

Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

VLDB and Partitioning Guide

Contains an overview of very large database (VLDB) topics, with emphasis on partitioning and parallel execution as a key component of the VLDB strategy.

Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

OLAP Customizing Analytic Workspace Manager

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

Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

OLAP Java API Developer's Guide

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

Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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 an overview of the features of Oracle Data Mining and information about mining functions and algorithms.

Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Data Mining User's Guide

Explains how to use the SQL interface to Oracle Data Mining to create models and score data. This Guide also addresses administrative issues such as security, import/export, and upgrade for Oracle Data Mining.

Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

R Enterprise Release Notes

Contains important information that was not included in the documentation for Oracle R Enterprise 1.2.

Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

R Enterprise User's Guide

Describes how to install and use Oracle R Enterprise which provides an environment for statistical computing.

Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle