OLTP VS OLAP and Data Mining and Data Warehouse

OLTP is a data processing system that records all of the business transactions as they occur. This can be characterized by many concurrent users activly adding and modifying data.

OLAP is a technology that uses multi-dimensional structures to provide fast access to data for analysis and business decision making purposes.


Data Mining is the extraction or "mining" of a large amount of knowledge from a data or data warehouse.


Data Warehouse is a centralized repository that stores data from multiple information sources and transforms them into a multi-dimensional data model for efficient querying and analysis.