A Database Systems have been used traditionally for online transaction processing (OLTP). OLTP systems are designed to maximize the transaction processing capacity It is commonly used in clerical data processing tasks, structured repetitive tasks, read update a few records. In OLTP isolation, recovery and integrity are critical. It is based on operational systems.
In contrast, an organization will normally have a single data warehouse, which holds data that is historical, detailed, and summarized to various levels and rarely subject to change (other than being ·supplemented with new data). The data warehouse is designed to support relatively low numbers of transactions that are unpredictable in nature and require answers to queries that are ad hoc, unstructured, and heuristic.
Comparison of OLTP systems and data warehousing systems: