Terms to Know
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.
Last updated