Oracle Database 12c Release 2
Data Warehousing
Give us your thoughts!
Essentials
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.
Open As...
PDF for offline viewing
Provides information about how to tune the performance of Oracle Database using Oracle performance tools.
Open As...
PDF for offline viewing
Describes how to perform SQL tuning, which is the iterative process of improving SQL statement performance to meet specific, measurable, and achievable goals.
Open As...
PDF for offline viewing
Contains an overview of very large database (VLDB) topics, with emphasis on partitioning and parallel execution as a key component of the VLDB strategy.
Open As...
PDF for offline viewing
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.
Open As...
PDF for offline viewing
Advanced Analytics
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.
Open As...
PDF for offline viewing
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.
Open As...
PDF for offline viewing
Provides reference information on Oracle Data Mining - Introduction, Using API, Data Mining API reference
Open 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.
Explains how SQL applications can extend their analytic processing capabilities and manage summary data by using the OLAP option of Oracle Database.
Open As...
PDF for offline viewing
Contains a complete description of the OLAP Data Manipulation Language (OLAP DML) used to define and manipulate analytic workspace objects.
Open As...
PDF for offline viewing
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.
Open As...
PDF for offline viewing
Provides guidance for developing client applications using the Oracle OLAP Java API.
Open As...
PDF for offline viewing
Provides reference information for the Oracle OLAP Java API.
Open As...