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
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.
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.
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.
Oracle Warehouse Builder
Oracle Warehouse Builder (OWB) enables the design and deployment of enterprise data warehouses, data marts, and e-business intelligence applications.
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.
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.
Download As...
Data Mining
Analyze data from a data warehouse to identify trends and patterns.
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.
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.
Download As...