Skip to main content

Posts

Showing posts from June, 2012

OLTP Vs OLAP

Enterprise Systems and IT Application can be categories in two types OLTP and OLAP. In General Terms OLTP is day to day Record Keeping of any organization and OLAP is the Historical Data of Warehouse..  
OLTP (On-line Transaction Processing)is characterized by a large number of transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF)

OLAP (On-line Analytical Processing)is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations(DISTINCT,GROUP BY,SUM,COUNT ..). For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, histo…