***************************************************
* Description: Knowledge of OLTP and OLAP database
* Date: 05:13 PM EST, 11/02/2018
***************************************************

		 
<1> Difference between OLTP and OLAP database:
     |
     |__ o. OLTP - Normal relational database with regular transaction.
     |
     |__ o. OLAP - Data Warehouse.
	
	


<2> The concept of OLTP & OLAP:
     |
     |__ o. OLTP (On-line Transaction Processing) is characterized by a large number of short on-line 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). 
     |
     |
     |__ o. OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. 
            Queries are often very complex and involve aggregations. 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, historical data, stored in multi-dimensional schemas (usually star schema). 	 
	
	

Reference:
     |
     |__ o. https://www.guru99.com/oltp-vs-olap.html
     |
     |__ o. http://datawarehouse4u.info/OLTP-vs-OLAP.html