- OLTP is a class of systems that supports or facilitates high transaction-oriented applications it 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.
- OLAP (On-line Analytical Processing) deals with Historical Data or Archival Data i.e is use for analytical analysis or reporting activities. OLAP is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations Sometime query need to access large amount of data in Management records like what was the turnover and growth of your company in last
- NOSQL/New SQL/Big Data : NoSQL is 3rd Generation Databases mostly addressing of being non-relational, distributed, open-source , horizontally scalable , simple API, eventually consistent / BASE and schema free.
The 3rd Generation of Database Technology