Skip Navigation

Oracle Database Online Documentation 11g Release 1 (11.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.

Essentials

Teaches you how to perform common day-to-day tasks necessary to implement and administer a data warehouse.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Supporting Documentation

Provides conceptual, reference, and implementation material for using Oracle Database 10g in data warehouses. 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 an overview of very large database (VLDB) topics, with emphasis on partitioning as a key component of the VLDB strategy
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes detailed ways to enhance Oracle performance by writing and tuning SQL properly, using performance tools, and optimizing instance performance. It also explains how to create an initial database for good performance and includes performance-related reference information. This book could be useful for database administrators, application designers, and programmers.
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 utilities described include the new Data Pump export and import products, the original export and import products, SQL*Loader, external tables, the Metadata API, LogMiner, DBVERIFY, and DBNEWID.
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.

Describes common tasks users can perform in Oracle Warehouse Builder. Includes instructions to use Data Watch and Repair for Oracle MDM applications.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes installing, configuring, and administrating Oracle Warehouse Builder.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Contains important last-minute information not included in the Oracle Warehouse Builder documentation. Release notes for the 11.1.0.7 release.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to use Warehouse Builder Oracle MetaBase (OMB) Scripting Language.
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 applications developers and DBAs can develop business intelligence applications, design and develop dimensional data stores (analytic workspaces), and administer Oracle Database with the OLAP option.
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

Assists Java programmers who are responsible for creating applications that perform analysis using Oracle OLAP.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the classes and methods in the Oracle OLAP Java API for creating OLAP metadata, defining and building analytic workspaces, and querying analytic workspaces and relational data warehouses.
No other download option available.
Download As...

Data Mining

Analyze data from a data warehouse to identify trends and patterns.

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

Describes how to install and administer Oracle Data Mining on a Windows platform. Includes instructions for creating Data Mining users, installing the sample programs, and performing other administrative tasks.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to use the Oracle Data Mining PL/SQL and Java APIs and the SQL scoring functions to create data mining applications.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the classes and methods in the Oracle Data Mining Java API, the JDM JSR-73-compliant API for data mining. The Java API supports a full range of data mining activities, including model building and scoring, data preparation, and import/export of models.
No other download option available.
Download As...