Already a member?
Sign in
Oracle Olap Terminology
The aim of this page is to provide a glossary of common OLAP and data warehousing terms and expressions. Click on a letter to view a separate page containing definitions and definitions for that letter.
A...
Active Catalog
Additive
Aggregation
Aggregation Map (aggmap)
Allocation
Analytic Workspace
Analytic Workspace Manager
Ancestor
Attribute
AWXMLB...
Balanced Hierarchy
Base Level Data
Base MeasureC...
Calculated Measure
Cell
Child
Commit
Composite
Compressed Cube
Compression
Constraint Advisor
Cube
Cube Organized MView
Cube View
Custom Measure
Custom MemberD...
Data Source
Data Mart
Data warehouse
Database Standard Form
Decimal
Denormalized
Derived Measure
Descendant
Detail Data
Dimension
Dimension Key
Dimension Table
Dimension Value
Dimension View
DrillE...
EIF
EIFVERSION
Embedded total
Eversion
Export
ExpressionF...
Fact
Fact Table
FormulaG... H...
HierarchyI...
Import
InfileJ...
JoinK...
KeyL...
Leaf Data
Level
Level-based HierarchyM...
Mapping
Materialized View
Measure
Measure folder
Measure view
Metadata
Model
N...
$NATRIGGER
NAFill
NAspell
Non-additive
NumberO...
Object type
OLAP
OLAP Analytic Engine
OLAP API
OLAP DML
OLAP Page Pool Memory Area
OLAP Worksheet
OLTP
On the flyP...
Page
Page Source
Parent
Parent-child Relation
Partition
Precalculate
Precompute
PropertyQ...
QDR
Qualified Data ReferenceR...
Ragged Hierarchy
Refresh
Relation
Row SourceS...
Skip Level Hierarchy
Snowflake Schema
Solved Data
Source
Sort
Sparsity
Sparsity Advisor
Standard Form
Star Schema
Status
SummaryT...
Time Dimension
Top-levelU...
Unbalanced Hierarchy
Update
Update windowV...
Value based hierarcy
VariableW... X...
XML_LOAD_LOGY... Z...
Zerorow#...
3NF
Latest page update: made by keith_laker
, Mar 20 2008, 7:40 AM EDT
(about this update
About This Update
Edited by keith_laker
7 words added
view changes
- complete history)
7 words added
view changes
- complete history)
Keyword tags:
OLAP
Terminology
More Info: links to this page
| Started By | Thread Subject | Replies | Last Post | |
|---|---|---|---|---|
| keith_laker | Terminology | 0 | Jan 18 2008, 10:28 AM EST by keith_laker | |
|
Thread started: Jan 18 2008, 10:28 AM EST
Watch
The aim of this page is to try and document the many words and phrases we use when talking about the Oracle OLAP itself and its many features. Most of this terminology has been derived directly from Express Server. However, now a lot of key words can also cross over in to the relational world, which can result in confusion. Therefore, I have started this page to help clarify the whole world of OLAP.
Keith Laker Oracle EMEA Consulting OLAP Blog: http://oracleOLAP.blogspot.com/ OLAP Wiki: http://wiki.oracle.com/page/Oracle+OLAP+Option DM Blog: http://oracledmt.blogspot.com/ OWB Blog : http://blogs.oracle.com/warehousebuilder/ OWB Wiki : http://wiki.oracle.com/page/Oracle+Warehouse+Builder DW on OTN : http://www.oracle.com/technology/products/bi/db/11g/index.html
4
out of
5 found this valuable.
Do you?
Keyword tags:
OLAP
Terminology
|
||||

