Shri Dana

• Apr 6th, 2005

 

OLTP system stands for on-line transaction processing.  
 
These are used to store only daily transactions as the changes have to be made in as few places as possible. OLTP do not have historical data of the organization 
 
Datawarehouse will contain the historical information about the organization

Nirav

• May 14th, 2005

 

Data Warehouse is a part of OLAP (On-Line Analytical Processing). It is the source from which any BI tools fetch data for Analytical, reporting or data mining purposes. It generally contains the data through the whole life cycle of the company/product. DWH contains historical, integrated, denormalized, subject oriented data.  
However, on the other hand the OLTP system contains data that is generally limited to last couple of months or a year at most. The nature of data in OLTP is: current, volatile and highly normalized. Since, both systems are different in nature and functionality we should always keep them in different systems.

Kenneth

• Jul 18th, 2005

 

An DW is typically used most often for intensive querying . Since the primary responsibility of an OLTP system is to faithfully record on going transactions (inserts/updates/deletes), these operations will be considerably slowed down by the heavy querying that the DW is subjected to.