没有合适的资源?快使用搜索试试~ 我知道了~
首页Oracle OLAP DML 参考指南 11g Release 2 (11.2)
Oracle OLAP DML 参考指南 11g Release 2 (11.2)
需积分: 5 0 下载量 20 浏览量
更新于2024-06-25
收藏 7.79MB PDF 举报
"Oracle OLAP DML 参考 11g Release 2 (11.2)-1640"
Oracle OLAP(在线分析处理)DML(数据操纵语言)是Oracle数据库中用于处理多维数据集的一种专用语言。这个参考文档主要针对11g Release 2 (11.2)版本,为用户提供关于如何操作和查询Oracle OLAP对象的详细信息。E17122-08是该文档的特定版本号,发布于2013年11月。
Oracle OLAP DML 提供了一系列命令和语法,允许用户执行诸如创建、修改、查询和分析多维数据集等任务。这些功能对于企业进行复杂的数据分析和决策支持至关重要。在OLAP环境中,数据通常以立方体的形式组织,通过维度和度量来表示,DML则提供了操作这些立方体的方法。
以下是一些Oracle OLAP DML的关键概念和操作:
1. **数据立方体**:OLAP的核心是数据立方体,它是由多个维度(如时间、地区、产品等)和度量(如销售额、利润等)构成的多维结构。DML允许用户创建、更新和查询立方体。
2. **维度**:维度定义了数据的类别或分类,比如地理位置、产品线等。用户可以使用DML来管理维度层次结构,如添加、删除或修改维度成员。
3. **度量**:度量是可度量的数值,如销售额、成本等。DML提供了计算和聚合度量值的功能。
4. **计算成员**:用户可以通过DML定义计算成员,这是基于其他度量或成员的计算结果,如总销售额减去总成本得到毛利润。
5. **切片与 dice**:切片(slice)和骰子(dice)操作用于从立方体中选择特定部分进行分析。DML提供相应的语法来实现这些操作。
6. **钻取操作**:钻取允许用户在维度层次结构中上下移动,从高级别概括到低级别细节,反之亦然。
7. **聚合操作**:DML支持各种聚合函数,如SUM、AVG、MAX、MIN等,用于对度量数据进行统计分析。
8. **脚本和批处理**:用户可以编写DML脚本来批量执行任务,如定期更新立方体或执行复杂的分析。
9. **安全性**:DML还允许设置访问控制,确保用户只能访问他们被授权的数据。
10. **性能优化**:Oracle OLAP DML提供了优化技巧和建议,帮助用户提高查询性能,如使用物化视图和索引。
请注意,Oracle OLAP DML的使用需遵循特定的许可证协议,包含使用和披露的限制,并受知识产权法律保护。未经授权,禁止复制、修改、分发软件,除非你的许可证协议或法律规定允许。此外,对于美国政府用户,文档中可能包含特定的使用条款和通知。
Oracle OLAP DML Reference 11g Release 2 (11.2)-1640是数据库管理员、数据分析师和开发人员的重要参考资料,它详细阐述了如何有效利用Oracle OLAP功能进行高效的数据管理和分析。通过深入理解和熟练掌握DML,用户能够充分利用Oracle OLAP的特性,实现数据驱动的洞察和决策。
xvi
SINH ...................................................................................................................................................... 8-162
SMALLEST........................................................................................................................................... 8-163
SMOOTH.............................................................................................................................................. 8-165
SORT function ..................................................................................................................................... 8-168
SORTLINES.......................................................................................................................................... 8-169
SOUNDEX ............................................................................................................................................ 8-170
SQLFETCH ........................................................................................................................................... 8-171
SQRT...................................................................................................................................................... 8-172
STARTOF .............................................................................................................................................. 8-173
STATALL ............................................................................................................................................... 8-175
STATCURR ........................................................................................................................................... 8-176
STATDEPTH......................................................................................................................................... 8-177
STATEQUAL ........................................................................................................................................ 8-178
STATFIRST ........................................................................................................................................... 8-179
STATLAST ............................................................................................................................................ 8-180
STATLEN............................................................................................................................................... 8-181
STATLIST.............................................................................................................................................. 8-182
STATMAX ............................................................................................................................................. 8-184
STATMIN.............................................................................................................................................. 8-186
STATRANK .......................................................................................................................................... 8-188
STATVAL............................................................................................................................................... 8-191
STDDEV................................................................................................................................................ 8-194
SUBSTR functions .............................................................................................................................. 8-196
SUBTOTAL........................................................................................................................................... 8-198
SYS_CONTEXT ................................................................................................................................... 8-200
SYSDATE
.............................................................................................................................................. 8-201
SYSINFO............................................................................................................................................... 8-202
SYSTEM ................................................................................................................................................ 8-204
SYSTIMESTAMP ................................................................................................................................ 8-205
TALLY .................................................................................................................................................... 8-206
TAN ........................................................................................................................................................ 8-208
TANH ..................................................................................................................................................... 8-209
TCONVERT.......................................................................................................................................... 8-210
TEXTFILL.............................................................................................................................................. 8-217
TO_BINARY_DOUBLE...................................................................................................................... 8-219
TO_BINARY_FLOAT ......................................................................................................................... 8-220
TO_CHAR............................................................................................................................................. 8-221
TO_DATE.............................................................................................................................................. 8-224
TO_DSINTERVAL .............................................................................................................................. 8-226
TO_NCHAR ......................................................................................................................................... 8-227
TO_NUMBER ...................................................................................................................................... 8-230
TO_TIMESTAMP................................................................................................................................ 8-232
TO_TIMESTAMP_TZ......................................................................................................................... 8-234
TO_YMINTERVAL ............................................................................................................................. 8-235
TOD........................................................................................................................................................ 8-236
TODAY .................................................................................................................................................. 8-237
TOTAL ................................................................................................................................................... 8-238
xvii
TRANSLATE ........................................................................................................................................ 8-240
TRIGGER function ............................................................................................................................. 8-241
TRIM...................................................................................................................................................... 8-243
TRUNCATE .......................................................................................................................................... 8-244
TRUNCATE (datetime)................................................................................................................ 8-245
TRUNCATE (number).................................................................................................................. 8-246
TZ_OFFSET .......................................................................................................................................... 8-247
UNIQUELINES.................................................................................................................................... 8-248
UNRAVEL............................................................................................................................................. 8-249
UPPER.................................................................................................................................................... 8-252
UPPER.................................................................................................................................................... 8-253
VALSPERPAGE ................................................................................................................................... 8-254
VA L U E S ................................................................................................................................................. 8-255
VINTSCHED........................................................................................................................................ 8-259
VPMTSCHED ...................................................................................................................................... 8-262
VSIZE..................................................................................................................................................... 8-265
WEEKOF ............................................................................................................................................... 8-266
WIDTH_BUCKET ........................................................................................................................... 8-267
WKSDATA............................................................................................................................................ 8-269
WRITABLE ........................................................................................................................................... 8-271
YYOF...................................................................................................................................................... 8-272
9 OLAP DML Commands: A-G
About OLAP DML Commands ............................................................................................................. 9-1
Commands: Alphabetical Listing.......................................................................................................... 9-2
Commands by Category.......................................................................................................................... 9-5
ACQUIRE................................................................................................................................................ 9-10
ACROSS.................................................................................................................................................. 9-15
ADD_CUBE_MODEL .......................................................................................................................... 9-17
ADD_DIMENSION_MEMBER ......................................................................................................... 9-19
ADD_MODEL_DIMENSION ............................................................................................................ 9-24
AGGMAP................................................................................................................................................ 9-25
AGGINDEX...................................................................................................................................... 9-43
BREAKOUT DIMENSION ............................................................................................................ 9-46
CACHE ............................................................................................................................................. 9-49
DIMENSION (for aggregation)..................................................................................................... 9-52
DROP DIMENSION ....................................................................................................................... 9-53
MEASUREDIM (for aggregation)................................................................................................. 9-55
MODEL (in an aggregation) .......................................................................................................... 9-56
PRECOMPUTE................................................................................................................................ 9-57
RELATION (for aggregation)........................................................................................................ 9-58
AGGMAP ADD or REMOVE model ................................................................................................ 9-70
AGGMAP SET ....................................................................................................................................... 9-72
AGGREGATE command...................................................................................................................... 9-73
ALLCOMPILE........................................................................................................................................ 9-82
ALLOCATE............................................................................................................................................. 9-83
ALLOCMAP ........................................................................................................................................... 9-90
xviii
CHILDLOCK ................................................................................................................................... 9-95
DEADLOCK..................................................................................................................................... 9-96
DIMENSION (for allocation)......................................................................................................... 9-97
ERRORLOG ..................................................................................................................................... 9-98
ERRORMASK .................................................................................................................................. 9-99
MEASUREDIM (for allocation)................................................................................................... 9-100
RELATION (for allocation).......................................................................................................... 9-101
SOURCEVAL................................................................................................................................. 9-107
VALUESET..................................................................................................................................... 9-108
ALLSTAT............................................................................................................................................... 9-111
ARGUMENT ........................................................................................................................................ 9-112
AW command ....................................................................................................................................... 9-117
AW ALIASLIST............................................................................................................................. 9-118
AW ATTACH ................................................................................................................................ 9-119
AW CREATE.................................................................................................................................. 9-126
AW DELETE .................................................................................................................................. 9-128
AW DETACH ................................................................................................................................ 9-129
AW FREEZE................................................................................................................................... 9-131
AW LIST ......................................................................................................................................... 9-132
AW PURGE CACHE .................................................................................................................... 9-134
AW ROLLBACK TO FREEZE..................................................................................................... 9-135
AW SEGMENTSIZE ..................................................................................................................... 9-136
AW THAW..................................................................................................................................... 9-137
AW TRUNCATE ........................................................................................................................... 9-138
AWDESCRIBE ..................................................................................................................................... 9-139
BLANK .................................................................................................................................................. 9-141
BREAK................................................................................................................................................... 9-142
CALL ...................................................................................................................................................... 9-143
CDA........................................................................................................................................................ 9-147
CHGDFN .............................................................................................................................................. 9-148
CLEAR ...................................................................................................................................................
9-156
COMMIT .............................................................................................................................................. 9-159
COMPILE.............................................................................................................................................. 9-160
CONSIDER........................................................................................................................................... 9-164
CONTEXT command.......................................................................................................................... 9-165
CONTINUE .......................................................................................................................................... 9-167
COPYDFN............................................................................................................................................. 9-168
CREATE_LOGICAL_MODEL .......................................................................................................... 9-169
DATE_FORMAT.................................................................................................................................. 9-170
DBGOUTFILE...................................................................................................................................... 9-177
DEFINE.................................................................................................................................................. 9-180
DEFINE AGGMAP ....................................................................................................................... 9-182
DEFINE COMPOSITE .................................................................................................................. 9-185
DEFINE DIMENSION.................................................................................................................. 9-189
DEFINE DIMENSION (simple) ........................................................................................... 9-189
DEFINE DIMENSION (DWMQY) ...................................................................................... 9-192
DEFINE DIMENSION (conjoint)......................................................................................... 9-195
xix
DEFINE DIMENSION CONCAT........................................................................................ 9-198
DEFINE DIMENSION ALIASOF ........................................................................................ 9-200
DEFINE FORMULA ..................................................................................................................... 9-203
DEFINE MODEL........................................................................................................................... 9-205
DEFINE PARTITION TEMPLATE............................................................................................. 9-207
DEFINE PROGRAM..................................................................................................................... 9-209
DEFINE RELATION..................................................................................................................... 9-211
DEFINE SURROGATE................................................................................................................. 9-213
DEFINE VALUESET..................................................................................................................... 9-216
DEFINE VARIABLE ..................................................................................................................... 9-219
DEFINE WORKSHEET ................................................................................................................ 9-238
DELETE ................................................................................................................................................. 9-240
DESCRIBE ............................................................................................................................................ 9-241
DO ... DOEND ..................................................................................................................................... 9-243
EDIT....................................................................................................................................................... 9-245
EQ ........................................................................................................................................................... 9-246
EXPORT................................................................................................................................................. 9-248
EXPORT (EIF) ................................................................................................................................ 9-249
EXPORT (spreadsheet)................................................................................................................. 9-255
FCCLOSE .............................................................................................................................................. 9-257
FCEXEC ................................................................................................................................................. 9-258
FCSET .................................................................................................................................................... 9-262
FETCH ................................................................................................................................................... 9-268
FILECLOSE........................................................................................................................................... 9-271
FILECOPY............................................................................................................................................. 9-272
FILEDELETE ........................................................................................................................................ 9-273
FILEMOVE ........................................................................................................................................... 9-274
FILEPAGE ............................................................................................................................................. 9-275
FILEPUT................................................................................................................................................ 9-277
FILEREAD
............................................................................................................................................ 9-279
FILESET................................................................................................................................................. 9-293
FILEVIEW ............................................................................................................................................. 9-296
FOR ........................................................................................................................................................ 9-304
FORECAST........................................................................................................................................... 9-307
FORECAST.REPORT.......................................................................................................................... 9-313
FULLDSC.............................................................................................................................................. 9-315
GOTO .................................................................................................................................................... 9-317
GROUPINGID command.................................................................................................................. 9-320
10 OLAP DML Commands: H-Z
HEADING .............................................................................................................................................. 10-2
HIDE ........................................................................................................................................................ 10-4
HIERDEPTH .......................................................................................................................................... 10-5
HIERHEIGHT command..................................................................................................................... 10-7
IF...THEN...ELSE command............................................................................................................... 10-11
IMPORT ................................................................................................................................................ 10-13
IMPORT (EIF) ................................................................................................................................ 10-14
xx
IMPORT (text)................................................................................................................................ 10-23
IMPORT (spreadsheet)................................................................................................................. 10-28
INFILE ................................................................................................................................................... 10-31
LD ........................................................................................................................................................... 10-33
LIMIT command.................................................................................................................................. 10-34
LIMIT (using values) command.................................................................................................. 10-43
LIMIT using LEVELREL command ........................................................................................... 10-53
LIMIT (using related dimension) command............................................................................. 10-55
LIMIT (using parent relation)...................................................................................................... 10-58
LIMIT NOCONVERT command ................................................................................................ 10-64
LIMIT command (using POSLIST)............................................................................................. 10-65
LIMIT BASEDIMS.............................................................................................................................. 10-66
LISTBY .................................................................................................................................................. 10-68
LISTFILES............................................................................................................................................. 10-69
LISTNAMES ........................................................................................................................................ 10-70
LOAD..................................................................................................................................................... 10-73
LOG command..................................................................................................................................... 10-74
MAINTAIN........................................................................................................................................... 10-76
MAINTAIN ADD.......................................................................................................................... 10-79
MAINTAIN ADD for TEXT, ID, and INTEGER Values .................................................. 10-79
MAINTAIN ADD for DAY, WEEK, MONTH, QUARTER, and YEAR Values ........... 10-81
MAINTAIN ADD SESSION................................................................................................. 10-83
MAINTAIN ADD TO PARTITION..................................................................................... 10-87
MAINTAIN DELETE.................................................................................................................... 10-89
MAINTAIN DELETE dimension......................................................................................... 10-89
MAINTAIN DELETE composite ......................................................................................... 10-91
MAINTAIN DELETE FROM PARTITION ........................................................................ 10-92
MAINTAIN MERGE .................................................................................................................... 10-94
MAINTAIN MOVE....................................................................................................................... 10-96
MAINTAIN MOVE dimension value................................................................................. 10-96
MAINTAIN MOVE TO PARTITION.................................................................................. 10-98
MAINTAIN RENAME............................................................................................................... 10-100
MODEL ............................................................................................................................................... 10-101
DIMENSION (in models)........................................................................................................... 10-106
INCLUDE........................................................................................................................
............. 10-110
MODEL.COMPRPT.......................................................................................................................... 10-113
MODEL.DEPRT................................................................................................................................. 10-114
MODEL.XEQRPT.............................................................................................................................. 10-115
MONITOR.......................................................................................................................................... 10-117
MOVE .................................................................................................................................................. 10-121
OUTFILE ............................................................................................................................................. 10-123
PAGE .................................................................................................................................................... 10-126
PARSE .................................................................................................................................................. 10-128
PERMIT............................................................................................................................................... 10-130
PERMITRESET.................................................................................................................................. 10-137
POP....................................................................................................................................................... 10-139
POPLEVEL.......................................................................................................................................... 10-140
剩余1639页未读,继续阅读
2023-06-18 上传
2024-10-14 上传
2024-10-14 上传
2024-10-14 上传
2024-10-14 上传
2024-10-14 上传
weixin_40191861_zj
- 粉丝: 83
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 前端面试必问:真实项目经验大揭秘
- 永磁同步电机二阶自抗扰神经网络控制技术与实践
- 基于HAL库的LoRa通讯与SHT30温湿度测量项目
- avaWeb-mast推荐系统开发实战指南
- 慧鱼SolidWorks零件模型库:设计与创新的强大工具
- MATLAB实现稀疏傅里叶变换(SFFT)代码及测试
- ChatGPT联网模式亮相,体验智能压缩技术.zip
- 掌握进程保护的HOOK API技术
- 基于.Net的日用品网站开发:设计、实现与分析
- MyBatis-Spring 1.3.2版本下载指南
- 开源全能媒体播放器:小戴媒体播放器2 5.1-3
- 华为eNSP参考文档:DHCP与VRP操作指南
- SpringMyBatis实现疫苗接种预约系统
- VHDL实现倒车雷达系统源码免费提供
- 掌握软件测评师考试要点:历年真题解析
- 轻松下载微信视频号内容的新工具介绍
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功