03-1-REVIEW - Some Terminology Handout

previousdankishSoftware and s/w Development

Nov 25, 2013 (3 years and 11 months ago)

98 views





1

of
1

previousdankish_093ccdc8
-
f3ec
-
4513
-
af20
-
8314f0016778.docx

by rt
--

25 November 2013


1

of
1

03
-
1
-
REVIEW
-

Some Terminology

Handout

OLAP
-

Online Analytical Processing

-

Software that allows users to easily
analyze

data online by manipulating the presentation of facts
and dimensions.

-

By now you have seen a little of it

OLTP
-

Online
Transaction Processing

-

Software that processes business transactions such as order processing, visitor registration, support
calls

Facts

-

Numeric values that represent

-

Amounts

-

Sales $

-

Amt

-

Quantity on Hand)

-

Or events


-

Registration count

D
imensions

-

Hierarchies that represent the perspectives a business can take of the facts

-

Time

-

Product

-

Geography

-

Customer


RDBMS
-

Relational Database Management System

-

Software for building and managing databases using SQL (Standard Query Langua
ge)

Datamart

-

A targeted subset of a data warehouse to support a particular subject area or departmental
requirement

Cube

-

A multidimensional database (MDDB) pre
-
summarized (aggregation) for fast performance and easy
slice
-
and
-
dice

Slice
-
and
-
Dice

-

The
action of changing dimensions to see information from a different perspective

ROLAP and MOLAP

-

Special purpose OLAP servers that handle multidimensional data and operations


ROLL
-
UP

-

Aggregate on some dimension

-

Daily aggregates into weekly, monthly etc

-

Store data aggregates into stores in city, region, province, and country

DRILL
-
DOWN

-

De
-
aggregate on some dimension

-

Getting at greater levels of detail

CLIENTS

-

Query and reporting tools

-

Analysis tools

DATA MINING

-

Discovering patterns of various

forms by “mining” through the data


-

Client tools used to do mining


-

PowerPlay

by Cognos

(Canadian company)

is one of them

(now IBM owned)