Oracle Database Online Documentation
10g Release 2 (10.2)

Data Warehousing

Data Warehousing

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

Data Mining

Data Mining analyzes data from a data warehouse, looking for trends and patterns:

Explains how to install the various components of Oracle Data Mining and perform basic administration tasks.
Download As...

PDF for offline viewing

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...
Discusses the basic concepts underlying Oracle Data Mining. Details of programming with the Java and PL/SQL interfaces are discussed in the Oracle Data Mining Application Developer's Guide.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Describes the Oracle Data Mining Application Programming Interfaces and the SQL functions for Data Mining. APIs are available for PL/SQL and for Java.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Oracle Real Application Clusters

Oracle Real Application Clusters combines storage and processing power across a cluster of machines for high availability:

Describes how to install, configure, and administer Oracle Clusterware and Oracle Real Application Clusters on a two-node system using the Red Hat Linux system.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

No summary available.
No summary available.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Revision of SSH2 instructions from Wiekus Beukis of HP.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Explains how to install and configure Oracle Clusterware and Oracle Real Application Clusters.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Explains how to install and configure Oracle Clusterware and Oracle Real Application Clusters.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Explains how to install and configure Oracle Clusterware and Oracle Database with Oracle Real Application Clusters on Microsoft Windows clusters running Windows 2000 (32-bit) with Service Pack 1 or higher, Windows Server 2003 x64, or Windows Server 2003 for 64-bit Itanium 2 Systems.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

No summary available.
No summary available.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Describes the Oracle Clusterware and Real Application Clusters architectures and provides an overview of these products. This book also describes administrative and deployment topics for Oracle Clusterware and RAC.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Data Warehousing

Data Warehousing refers to large databases used mostly for querying. You need to understand the performance of certain types of queries, and how to move large quantities of data around. Most of the information on the Administration page also applies here.

No summary available.
No summary available.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

Explains in detail how to enhance performance by writing and tuning SQL properly, by using performance tools, and by optimizing instance performance.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Describes how to use the Oracle Database utilities for data transfer, data maintenance, and database administration.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

OLAP

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

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

Describes the relational views, SQL functions, and PL/SQL packages that support the OLAP option of the Oracle Database.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Explains how SQL and Java applications can extend their analytic processing capabilities by using the OLAP option in the Enterprise edition of the Oracle Database.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Oracle OLAP Developer's Guide to the OLAP API introduces Java programmers to the Oracle OLAP API, which is the Java application programming interface for Oracle OLAP. Through Oracle OLAP, the OLAP API provides access to data stored in an Oracle database. The OLAP API capabilities for querying, manipulating, and presenting data are particularly suited to applications that perform online analytical processing operations.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Describes the classes and methods in the Oracle OLAP Java API for querying analytic workspaces and relational data warehouses.
No other download option available.
Download As...
Describes the classes and methods in the Oracle OLAP Analytic Workspace Java API for building and maintaining analytic workspaces.
No other download option available.
Download As...

Oracle Retail Data Model

The Oracle Retail Data Model is a start-up kit for implementing a retail data warehouse solution. It speeds the development of a data warehouse solution by providing a foundation data warehouse and analytic infrastructure for the reporting needs of a retail operation.

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle