没有合适的资源?快使用搜索试试~ 我知道了~
Oracle 9i OLAP Developer’s Guide to the OLAP DML Release 2 (9.2)
需积分: 1 0 下载量 79 浏览量
2023-04-07
14:21:08
上传
评论
收藏 2.36MB PDF 举报
温馨提示
试读
342页
Oracle 9i OLAP Developer’s Guide to the OLAP DML Release 2 (9.2)
资源推荐
资源详情
资源评论
Oracle9
i
OLAP
Developer’s Guide to the OLAP DML
Release 2 (9.2)
March 2002
Part No. A95298-01
Oracle9i OLAP Developer’s Guide to the OLAP DML, Release 2 (9.2)
Part No. A95298-01
Copyright © 2001, 2002 Oracle Corporation. All rights reserved.
The Programs (which include both the software and documentation) contain proprietary information of
Oracle Corporation; they are provided under a license agreement containing restrictions on use and
disclosure and are also protected by copyright, patent and other intellectual and industrial property
laws. Reverse engineering, disassembly or decompilation of the Programs, except to the extent required
to obtain interoperability with other independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems
in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this
document is error-free. Except as may be expressly permitted in your license agreement for these
Programs, no part of these Programs may be reproduced or transmitted in any form or by any means,
electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.
If the Programs are delivered to the U.S. Government or anyone licensing or using the programs on
behalf of the U.S. Government, the following notice is applicable:
Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial
computer software" and use, duplication, and disclosure of the Programs, including documentation,
shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.
Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer
software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR
52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500
Oracle Parkway, Redwood City, CA 94065.
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,
redundancy, and other measures to ensure the safe use of such applications if the Programs are used for
such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the
Programs.
Oracle is a registered trademark, and Oracle9i, PL/SQL, and SQL*Plus are trademarks or registered
trademarks of Oracle Corporation. Other names may be trademarks of their respective owners.
iii
Contents
Send Us Your Comments.................................................................................................................. xv
Preface......................................................................................................................................................... xvii
Audience.............................................................................................................................................. xviii
Organization........................................................................................................................................ xviii
Related Documentation ...................................................................................................................... xix
Conventions........................................................................................................................................... xx
Documentation Accessibility ............................................................................................................ xxiii
What’s New in the OLAP DML? ................................................................................................... xxv
Oracle9i Release 2 (9.2) New Features in the OLAP DML........................................................... xxvi
Part I Introduction
1 Basic Concepts
What Is the OLAP DML?................................................................................................................... 1-2
Analytic Workspaces.................................................................................................................... 1-2
SQL and the OLAP DML............................................................................................................. 1-3
The OLAP API and the OLAP DML.......................................................................................... 1-3
Using the OLAP DML........................................................................................................................ 1-3
How to Use the OLAP DML to Analyze Data ......................................................................... 1-4
Creating an Analytic Workspace................................................................................................ 1-4
Loading Data Into Analytic Workspaces.................................................................................. 1-5
iv
Temporary vs. Persistent Analytic Workspaces....................................................................... 1-5
Sharing Data In Analytic Workspaces....................................................................................... 1-5
Accessing a Workspace from OLAP Worksheet............................................................................ 1-6
Procedures: How to Open OLAP Worksheet........................................................................... 1-6
Establishing a Connection........................................................................................................... 1-7
Executing Commands.................................................................................................................. 1-8
Editing an OLAP DML Program................................................................................................ 1-8
Closing the Connection................................................................................................................ 1-9
Accessing a Workspace from SQL-Based Applications .............................................................. 1-9
Using SQL SELECT Statements.................................................................................................. 1-9
Using Embedded OLAP DML Commands ............................................................................ 1-10
Accessing a Workspace from a Java Application........................................................................ 1-10
Using OLAP Metadata............................................................................................................... 1-10
Using Embedded OLAP DML Commands ............................................................................ 1-10
2 Defining and Working with Analytic Workspaces
Using the OLAP DML to Work with Analytic Workspaces........................................................ 2-2
Current Analytic Workspace ...................................................................................................... 2-2
How to Create An Analytic Workspace.................................................................................... 2-3
How to Attach an Analytic Workspace..................................................................................... 2-3
Specifying the Analytic Workspace Attachment Mode.......................................................... 2-4
Sharing Analytic Workspaces..................................................................................................... 2-4
How to Detach an Analytic Workspace .................................................................................... 2-5
How to Delete an Analytic Workspace ..................................................................................... 2-5
Workspace Localization Settings................................................................................................ 2-6
Attaching Multiple Analytic Workspaces...................................................................................... 2-6
Qualified Object Names............................................................................................................... 2-6
Multiple AUTOGO and Permission Programs ........................................................................ 2-7
Using Names and Aliases for Analytic Workspaces.................................................................... 2-7
Workspace Names........................................................................................................................ 2-7
Workspace Aliases........................................................................................................................ 2-8
Saving Analytic Workspace Changes.............................................................................................. 2-8
UPDATE Command..................................................................................................................... 2-9
COMMIT Command.................................................................................................................... 2-9
v
Effect of the ROLLBACK Command....................................................................................... 2-10
Minimizing Analytic Workspace Growth............................................................................... 2-10
Executing Programs Automatically............................................................................................... 2-11
Program Names.......................................................................................................................... 2-11
AUTOGO Program Example.................................................................................................... 2-11
Adding Security to an Analytic Workspace................................................................................. 2-12
Permission Programs................................................................................................................. 2-12
Creating and Designing Permission Programs...................................................................... 2-13
Importing and Exporting Workspace Objects............................................................................. 2-14
Obtaining Analytic Workspace Information............................................................................... 2-15
Obtaining General Information About an Analytic Workspace.......................................... 2-15
Viewing Objects in an Analytic Workspace ........................................................................... 2-16
Obtaining Information About Objects..................................................................................... 2-17
3 Defining Data Objects
Overview: Defining Workspace Objects........................................................................................ 3-2
Workspace Objects That You Can Define................................................................................ 3-3
Data Types............................................................................................................................................ 3-4
Numeric Data Types .................................................................................................................... 3-4
Examples of Literal Numeric Values.................................................................................. 3-5
Text Data Types............................................................................................................................ 3-5
Escape Sequences .................................................................................................................. 3-6
Examples of Literal Text Values.......................................................................................... 3-7
Boolean Data Type ....................................................................................................................... 3-7
Date Data Types............................................................................................................................ 3-7
Defining Dimensions ........................................................................................................................ 3-8
Determining What Dimensions to Define................................................................................. 3-9
How Data For Simple Flat Dimensions Is Stored.................................................................. 3-10
Defining Dimension Surrogates.................................................................................................... 3-11
Differences Between Dimensions and Dimension Surrogates............................................. 3-12
Defining Relations ........................................................................................................................... 3-13
How Relations Are Dimensioned ............................................................................................ 3-13
How Relation Data Is Stored..................................................................................................... 3-14
Example: Relation Between Two Dimensions........................................................................ 3-15
Example: Self-relation................................................................................................................ 3-15
剩余341页未读,继续阅读
资源评论
rocazj
- 粉丝: 8
- 资源: 726
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功