Welcome! Wikis are websites that everyone can build together. It's easy!

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
AWXML
B...
Balanced Hierarchy
Base Level Data
Base Measure
C...
Calculated Measure
Cell
Child
Commit
Composite
Compressed Cube
Compression
Constraint Advisor
Cube
Cube Organized MView
Cube View
Custom Measure
Custom Member
D...
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
Drill
E...
EIF
EIFVERSION
Embedded total
Eversion
Export
Expression
F...
Fact
Fact Table
Formula
G...
H...
Hierarchy
I...
Import
Infile
J...
Join
K...
Key
L...
Leaf Data
Level
Level-based Hierarchy
M...
Mapping
Materialized View
Measure
Measure folder
Measure view
Metadata
Model
N...
$NATRIGGER
NAFill
NAspell
Non-additive
Number
O...
Object type
OLAP
OLAP Analytic Engine
OLAP API
OLAP DML
OLAP Page Pool Memory Area
OLAP Worksheet
OLTP
On the fly
P...
Page
Page Source
Parent
Parent-child Relation
Partition
Precalculate
Precompute
Property
Q...
QDR
Qualified Data Reference
R...
Ragged Hierarchy
Refresh
Relation
Row Source
S...
Skip Level Hierarchy
Snowflake Schema
Solved Data
Source
Sort
Sparsity
Sparsity Advisor
Standard Form
Star Schema
Status
Summary
T...
Time Dimension
Top-level
U...
Unbalanced Hierarchy
Update
Update window
V...
Value based hierarcy
Variable
W...
X...
XML_LOAD_LOG
Y...
Z...
Zerorow
#...
3NF






Latest page update: made by keith_laker , Mar 20 2008, 7:40 AM EDT (about this update About This Update keith_laker Edited by keith_laker

7 words added

view changes

- complete history)
Keyword tags: OLAP Terminology
More Info: links to this page

Anonymous  (Get credit for your thread)


Started By Thread Subject Replies Last Post
keith_laker Terminology 0 Jan 18 2008, 10:28 AM EST by keith_laker
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

Related Content

(what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Wiki pages
Top Contributors