Data Warehouse Terminology

Database types

OLTP: Online Transaction Processing

OLAP: Online Analytical Processing

 Both are two different structures, determined by data storage and retrieval requirements.

1.       OLTP

It is design for data entry and manipulation.

Data to day business operation.

Contain normalized data, the data is normalize by the first, second, third and fourth normal form.

Normally concerned with current and relatively new data.

It is most common database type used.

2.      

         OLAP

     It is also known as dataware house

     It is design for data collection and data analysis. Fast, easy access to more complex queries.

     Concerned wth historical and statistical information.

     Data is not normalize in data warehouse, OLTP. 

     Not usually concerned with individual transection.

Data Warehouse Terminology

LOB: Line of Business, Specialized, transection based application/data

DW: Data Warehouse

Lineage Information: source, date etc.  about the data, (where, how, when about data coming ). It is also called metadata. Data bout data

Normalized: Data is considered to be normalized it all the dependencies is removed in the normalization phases. Tables are closely related in normalize form.

Data Formatting: consistency in data formatting. Spelling, abbreviation, codes etc.

Dimensional model: term used for Data warehouse

Star: Specific data warehouse structure

Snowflake: Specific data warehouse structure

Granularity: Level of details available from Data warehouse.

Discretizing: Grouping the data, like a student data into Junior and senior.

Sql server

A relational database management system

A cloud-ready enterprise database/information platform. Provide broad base data functionality.

Design to provide data services across the desktop, device, data centre and private or public cloud.

It is having database and data warehouse functionality.