Oracle 9i OLAP 用户指南：Release 2 (9.2.0.2) 简介

oracle

需积分: 1 189 浏览量更新于2024-06-26 收藏 3.25MB PDF 举报

身份认证购VIP最低享 7 折!

30元优惠券

"Oracle 9i OLAP User’s Guide Release 2 (9.2.0.2) 是一本关于Oracle数据库在在线分析处理(Online Analytical Processing, OLAP)方面的用户指南，主要针对的是9.2.0.2版本。本书由Oracle Corporation于2002年9月出版，版权归属Oracle Corporation所有。" Oracle 9i OLAP是Oracle数据库系统的一个重要组成部分，专门设计用于高效处理大规模的数据分析和复杂查询，尤其适合业务智能、数据挖掘和决策支持系统。OLAP技术允许用户从多个角度（多维视图）快速分析数据，支持即席查询和深入洞察数据模式。在这本用户指南中，你可能会了解到以下关键知识点： 1. **OLAP概念**：了解OLAP的基本原理，包括多维数据模型、立方体(cubes)、维度(dimensions)、层次(hierarchies)和度量(measures)等核心概念。 2. **Oracle OLAP架构**：探索Oracle OLAP的体系结构，包括OLAP服务器、存储管理、OLAP DML（数据分析语言）以及与数据库的集成方式。 3. **数据源连接**：如何将Oracle OLAP与各种数据源（如Oracle数据库、其他关系型数据库或非结构化数据源）集成，进行数据导入和转换。 4. **多维数据建模**：学习如何设计和构建多维模型，包括定义维度、层次、成员和计算公式。 5. **数据立方体操作**：掌握切片、骰子、钻取和旋转等操作，以便对数据立方体进行分析和探索。 6. **性能优化**：了解如何通过索引、分区、物化视图和查询优化来提高OLAP查询的性能。 7. **安全性与权限管理**：学习如何设置访问控制，管理用户权限，确保数据的安全性。 8. **API和开发工具**：了解Oracle提供的API（如OLAP API）和开发工具，用于构建自定义的OLAP应用。 9. **报表和可视化**：学习如何使用Oracle OLAP与报表工具结合，创建交互式报告和可视化效果。 10. **故障排查和维护**：获取有关诊断问题、监控性能和维护OLAP环境的最佳实践。由于这是一本用户指南，书中还会包含详细的步骤说明、示例和案例研究，帮助用户理解和应用这些知识。同时，Oracle Corporation鼓励用户在遇到文档中的错误或不准确之处时，书面报告给公司以促进文档的改进。然而，Oracle并不保证文档无误，且未授权任何部分复制或传播，除非在特定的许可协议下允许。

资源详情

资源推荐

xvi

22 CWM2_OLAP_LEVEL_ATTRIBUTE

Understanding Level Attributes .................................................................................................... 22-2

Summary of CWM2_OLAP_LEVEL_ATTRIBUTE Subprograms........................................... 22-3

CREATE_LEVEL_ATTRIBUTE ................................................................................................ 22-3

DROP_LEVEL_ATTRIBUTE Procedure.................................................................................. 22-5

LOCK_LEVEL_ATTRIBUTE Procedure.................................................................................. 22-6

SET_DESCRIPTION Procedure................................................................................................ 22-8

SET_DISPLAY_NAME Procedure ........................................................................................... 22-9

SET_LEVEL_ATTRIBUTE_NAME Procedure ..................................................................... 22-10

SET_SHORT_DESCRIPTION Procedure .............................................................................. 22-12

Example: Creating a Level Attribute........................................................................................... 22-13

23 CWM2_OLAP_MEASURE

Understanding Measures ................................................................................................................ 23-2

Summary of CWM2_OLAP_MEASURE Subprograms............................................................. 23-2

CREATE_MEASURE Procedure .............................................................................................. 23-3

DROP_MEASURE Procedure................................................................................................... 23-4

LOCK_MEASURE Procedure................................................................................................... 23-4

SET_DESCRIPTION Procedure................................................................................................ 23-5

SET_DISPLAY_NAME Procedure ........................................................................................... 23-6

SET_MEASURE_NAME Procedure......................................................................................... 23-7

SET_SHORT_DESCRIPTION Procedure ................................................................................ 23-8

Example: Creating a Measure ......................................................................................................... 23-9

24 CWM2_OLAP_METADATA_REFRESH

The OLAP API Metadata Reader Views....................................................................................... 24-2

Summary of CWM2_OLAP_METADATA_REFRESH Subprograms ..................................... 24-3

MR_REFRESH Procedure.......................................................................................................... 24-3

25 CWM2_OLAP_PC_TRANSFORM

Prerequisites ...................................................................................................................................... 25-2

Parent-Child Dimensions................................................................................................................ 25-2

Solved, Level-Based Dimensions .................................................................................................. 25-3

Example: Creating a Solved, Level-Based Dimension Table.................................................... 25-4

xvii

Grouping ID Column................................................................................................................. 25-5

Embedded Total Key Column .................................................................................................. 25-5

Summary of CWM2_OLAP_PC_TRANSFORM Subprograms............................................... 25-5

CREATE_SCRIPT Procedure .................................................................................................... 25-5

26 CWM2_OLAP_TABLE_MAP

Understanding OLAP Metadata Mapping .................................................................................. 26-2

Summary of CWM2_OLAP_TABLE_MAP Subprograms ........................................................ 26-2

MAP_DIMTBL_HIERLEVELATTR Procedure...................................................................... 26-3

MAP_DIMTBL_HIERLEVEL Procedure................................................................................. 26-5

MAP_DIMTBL_HIERSORTKEY Procedure........................................................................... 26-6

MAP_DIMTBL_LEVELATTR Procedure................................................................................ 26-7

MAP_DIMTBL_LEVEL Procedure .......................................................................................... 26-9

MAP_FACTTBL_LEVELKEY Procedure.............................................................................. 26-10

MAP_FACTTBL_MEASURE Procedure............................................................................... 26-12

REMOVEMAP_DIMTBL_HIERLEVELATTR Procedure .................................................. 26-13

REMOVEMAP_DIMTBL_HIERLEVEL Procedure ............................................................. 26-15

REMOVEMAP_DIMTBL_HIERSORTKEY Procedure ....................................................... 26-16

REMOVEMAP_DIMTBL_LEVELATTR Procedure ............................................................ 26-17

REMOVEMAP_DIMTBL_LEVEL Procedure....................................................................... 26-18

REMOVEMAP_FACTTBL_LEVELKEY Procedure............................................................. 26-19

REMOVEMAP_FACTTBL_MEASURE Procedure.............................................................. 26-20

Example: Mapping a Dimension ................................................................................................. 26-21

Example: Mapping a Cube............................................................................................................ 26-22

27 CWM2_OLAP_VALIDATE

Summary of CWM2_OLAP_VALIDATE Subprograms............................................................ 27-2

VALIDATE_DIMENSION Procedure..................................................................................... 27-2

VALIDATE_CUBE Procedure .................................................................................................. 27-2

28 CWM_CLASSIFY

Understanding the OLAP Classification System ....................................................................... 28-2

Summary of CWM_CLASSIFY Subprograms ............................................................................ 28-3

ADD_CATALOG_ENTITY Procedure.................................................................................... 28-4

xviii

ADD_DESCRIPTOR_ENTITY_TYPE Procedure................................................................... 28-5

ADD_ENTITY_DESCRIPTOR_USE Procedure ..................................................................... 28-6

CREATE_CATALOG Function ................................................................................................ 28-7

CREATE_DESCRIPTOR Function ........................................................................................... 28-8

CREATE_DESCRIPTOR_TYPE Procedure............................................................................. 28-9

DROP_CATALOG Procedure................................................................................................. 28-10

DROP_DESCRIPTOR Procedure............................................................................................ 28-10

DROP_DESCRIPTOR_TYPE Procedure................................................................................ 28-11

LOCK_CATALOG Procedure................................................................................................. 28-12

REMOVE_CATALOG_ENTITY Procedure.......................................................................... 28-12

REMOVE_DESCRIPTOR_ENTITY_TYPE Procedure......................................................... 28-13

REMOVE_ENTITY_DESCRIPTOR_USE Procedure ........................................................... 28-14

SET_CATALOG_DESCRIPTION Procedure........................................................................ 28-16

SET_CATALOG_PARENT Procedure .................................................................................. 28-16

Example: Creating a Measure Folder .......................................................................................... 28-18

Part V OLAP API Materialized View Reference

29 Creating Dimension Materialized Views

Creating Materialized Views for Dimensions ............................................................................ 29-2

Statistics and Bitmap Indexes......................................................................................................... 29-2

Statistics........................................................................................................................................ 29-2

Bitmap Indexes............................................................................................................................ 29-3

The CREATE Statement for a Dimension Materialized View.............................................. 29-3

Sample Script for the TIMES_DIM Dimension ......................................................................... 29-4

Table Structure of Sample TIMES_DIM Dimension Materialized View............................ 29-10

30 Creating Fact Materialized Views With DBMS_ODM

Using the DBMS_ODM Package................................................................................................... 30-2

Procedure: Create and Run Scripts to Generate Grouping Set Materialized Views......... 30-2

Partitioning, Statistics, and Indexes.............................................................................................. 30-3

Partitioning ................................................................................................................................. 30-3

Statistics........................................................................................................................................ 30-3

Bitmap Indexes............................................................................................................................ 30-4

xix

Sample Script for the COST Cube ................................................................................................ 30-4

Summary of DBMS_ODM Subprograms.................................................................................. 30-11

CREATEDIMLEVTUPLE Procedure..................................................................................... 30-11

CREATECUBELEVELTUPLE Procedure.............................................................................. 30-12

CREATEFACTMV_GS Procedure ......................................................................................... 30-13

CREATEDIMMV_GS Procedure............................................................................................ 30-14

31 Creating Fact Materialized Views With OLAP Summary Advisor

Using the OLAP Summary Advisor Wizard................................................................................ 31-2

Procedure: Run the OLAP Summary Advisor....................................................................... 31-2

Partitioning, Statistics, and Indexes.............................................................................................. 31-3

Partitioning................................................................................................................................. 31-3

Statistics........................................................................................................................................ 31-3

Bitmap Indexes............................................................................................................................ 31-4

The MV CREATE Statement With Concatenated Rollup......................................................... 31-4

Sample Script for the COST Cube ................................................................................................ 31-6

A Upgrading From Express Server

Administration .................................................................................................................................... A-2

Authentication of Users............................................................................................................... A-2

Management Tools ....................................................................................................................... A-2

Data Transfer........................................................................................................................................ A-3

Localization.......................................................................................................................................... A-3

Applications Support......................................................................................................................... A-4

Programming Environment........................................................................................................ A-4

Communications........................................................................................................................... A-5

Metadata ........................................................................................................................................ A-5

Programming Language Changes.................................................................................................... A-5

New Commands........................................................................................................................... A-5

Obsolete Commands.................................................................................................................... A-6

UPDATE and COMMIT .............................................................................................................. A-6

How to Upgrade an Express Database............................................................................................ A-6

Index

剩余453页未读，继续阅读

rocazj

粉丝: 9
资源: 725

Oracle 9i OLAP 用户指南：Release 2 (9.2.0.2) 简介

Oracle Intelligent Agent User’s Guide Release 9.2.0.2

Oracle 9i OLAP Developer’s Guide to the OLAP API Release 2 (9.2)

cannot resolve org.olap4j:olap4j:0.9.7.309-js-3

Oracle的olap和oltp

OLAP查询SQL引擎有哪些

如何查询当前oracle是oltp还是olap

开源OLAP数据库推荐免费

\MSAS10.MSSQLSERVER\OLAP\Log\FlightRecorderCurrent.trc 时出错

OLAP立方可用的案例

oracle是oltp还是olap

oceanbase 创建olap表

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

crystal reports 9.2

oracle11g 版本

Oracle伪列的种类和使用方式

达梦数据库与Oracle的差距

olap多维度分析技术

第四周实践课-课堂笔记.pdf

第5周玩转案例分析(2).pdf

最新资源