Tag: technology

Online Transactional Processing and Online Analytical Processing systems

Online Transactional Processing and Organized Analytical Processing systems

Online Transactional Processing and Online Application Processing Systems

None

Typically detailed data only, often resulting in very large data volumes

Contains summarised and detailed data

Contains Summarized data only

None

Generally dimensionally modelled and tuned to optimise query performance

Generally modelled to support rapid data update

Should not be in Dimensional Modelling way

None

Data about Data

Machine level Data

Characteristics of Data

Relationship between Data

Tables with Measures that cannot be added across all dimensions

Tables, also known as lookup or reference tables, contain relatively static/ descriptive data

Tables, represent data, usually numeric and additive, that can be analyzed and examined

None

Tables typically contain facts and primary keys to the dimension tables

Tables typically contain facts and foreign keys to the dimension tables

Tables containing detail level facts or facts that have been aggregated

None

Star Schema is a relational database schema for representing multidimensional data that contain one or more dimensions and fact tables

A snowflake schema is a term that describes a star schema structure normalized through the use of outrigger tables

Snow flaking NOT recommended in most cases because of the very big dimension table’s size

Star schema is not recommended as it will be in highly normalized state

Attribute

Fact

Hierarchy

Filter

Report Filter

View Filter

both 1&2

none

Prompt

Filter

both 1&2

none