Terms to Know

These are some basic terms to know. We will learn lot more going forward.

DBMS - Database Management System

RDBMS - Relational Database Management System

ETL - Extract Transform Load - Back office process for loading data to Data Warehouse.

Bill Inmon - Considered the Father of Data Warehousing.

Ralph Kimball - He’s the father of Dimensional modeling and the Star Schema.

OLTP - Online Transaction Processing. The classic operational database for taking orders, reservations, etc.

OLAP - Online Analytical Processing. Big database providers (IBM, Teradata, Microsoft.. ) started integrating OLAP into their systems.

MetaData - Data about Data.

Data Pipeline - A set of processes that move data from one system to another.

ETL - Extract Transform Load

ELT - Extract Load Transform