Author: Jayadevan Maymala

Jayadevan Maymala loves words and data. He has worked with relational databases since 1999 and is the author of PostgreSQL for Data Architects. Currently a freelance database consultant, he lives in the beautiful state of Kerala, India with his wife and two kids. In his free time, he reads, solves Sudoku, and tries to play the flute

OLAP, OLTP, ETL and More: What You Need to Know About Data Warehouses

A data warehouse is a system that uses different technologies – including relational databases – to enable analytical reporting, which aids in tactical and strategic decision-making. Learn about all the key concepts of data warehousing in this article. Understanding how a data warehouse (DWH) works means more than just understanding the database designs for that DWH. You also have to understand online analytical processing (OLAP) and online transaction processing (OLTP) systems and extract-transform-load (ETL) procedures.