Ralph Kimball the co-founder of the data warehousing concept has defined the data warehouse as a "a copy of transaction data specifically structured for query and analysis".

Data warehousing is closely linked to OLAP - Online Analytical Processing - which relates to complex analysis of (usually aggregated, or denormalized) data in a data warehouse.

In contrast, OLTP refers to Online Transaction Processing. An OLTP database is used for day-to-day business operations and is therefore well-normalized.

See also Snowflake Schema vs. Star Schema.

Comparison chart

Data warehouse versus OLTP comparison chart
Edit this comparison chartData warehouseOLTP
Introduction (from Wikipedia) In computing, a data warehouse or enterprise data warehouse is a database used for reporting and data analysis. It is a central repository of data which is created by integrating data from one or more disparate sources. Online transaction processing, or OLTP, refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing. The term is somewhat ambiguous; some understand a "trans

About the Author

Nick Jasuja

Nick Jasuja has over 15 years of technology industry experience, including at Amazon in Seattle. He is an expert at building websites, developing software programs in PHP and JavaScript, maintaining MySQL and PostgreSQL databases, and running Linux servers for serving high-traffic websites. He has a bachelor's degree in Computer Science & Engineering.

Share this comparison via:

If you read this far, you should follow us:

"Datawarehouse vs OLTP." Diffen.com. Diffen LLC, n.d. Web. 10 Oct 2025. < >