Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the difference between a W/H and an OLTP application?

April 26, 2017application difference OLTP

0

Posted

What is the difference between a W/H and an OLTP application?

1 Answer

0

Posted

Typical relational databases are designed for on-line transactional processing (OLTP) and do not meet the requirements for effective on-line analytical processing (OLAP). As a result, data warehouses are designed differently than traditional relational databases. Warehouses are Time Referenced, Subject-Oriented, Non-volatile (read only) and Integrated. OLTP databases are designed to maintain atomicity, consistency and integrity (the “ACID” tests). Since a data warehouse is not updated, these constraints are relaxed.