Datawarehouse vs. OLTP

Datawarehouse
OLTP

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.

Comparison chart

Edit this comparison chart

Datawarehouse

OLTP

Introduction (from Wikipedia) A data warehouse is a repository (collection of resources that can be accessed to retrieve information) of an organizatioan's electronically stored data, designed to facilitate reporting and analysis. More simply, a data warehouse is a collection of 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

Share this comparison:

If you read this far, you should follow us on:

"Datawarehouse vs OLTP." Diffen.com. Diffen LLC, n.d. Web. 23 Oct 2014. < http://www.diffen.com/difference/Datawarehouse_vs_OLTP >

Related Comparisons Follow Diffen
Make Diffen Smarter.

Log in to edit comparisons or create new comparisons in your area of expertise!

Sign up »
Top 5 Comparisons

Comments: Datawarehouse vs OLTP

Comments via Facebook

Anonymous comments (1)

December 9, 2013, 1:53pm

good for last time guide

— 106.✗.✗.179
0

share

Up next

Snowflake Schema vs. Star Schema