Transactional vs Analytical Data - Key Difference (Class -21)

We deal with Data on day-to-day basis whether be an Individual Social / Personal Data or an Organizational Business data. So, to store the Data, it needs to be processed from time-to-time. This is how Data Processing comes into picture which is of 2 types:

1) Transactional System Data (OLTP)

2) Analytical System Data (OLAP)

OLAP creates a single platform for all type of business analysis needs which includes planning, budgeting, forecasting, and analysis while OLTP is useful to administer day to day transactions of an organization.

23 Key differences between OLTP & OLAP:

Transactional Data	Analytical Data
Online Transaction Processing (OLTP)	Online Analytical Processing (OLAP)
Day to day Real-time process analyze	Analyzing huge volumes of data for Business analytics
Present Day Data	Historical Data
for simple inserts, updates, deletions, etc.	allows to extract data for complex analysis. Can't modify data.
Query response is very Fast.	Query response is Slow.
Application Users	Data analysis Users
ER model is data model.	Dimensional model is data model.
Operational processing	Informational processing
RDBMS Databases are best suited.	Data Warehouses like Hive are best suited.
e.g.:- Email conversations, Sales Records, Online Payment transactions like Google Pay, ATM, etc.	e.g.:- Financial analysis, Budgeting, Sales Forecasting, etc.
Ideal for In-Store Purchases / Online transactions .	Ideal for Data Mining, Business Intelligence.
optimized for processing a massive number of transactions.	optimized for conducting complex data analysis for smarter decision-making.
administers daily transactions of an organization.	single platform for all type of business analytical needs.
widens the customer base of an organization by simplifying individual processes.	apply security restrictions on users and protect sensitive data.
system might faces hardware failures, then online transactions get severely affected.	Implementation and maintenance are dependent on IT professional.
online database modifying system.	online database query management system.
Tables in OLTP database are normalized.	Tables in OLAP database are not normalized.
OLTP and its transactions are the sources of data.	Different OLTP databases become the source of data for OLAP.
Allow read/write operations.	Only read and rarely write.
It is a market orientated process.	It is a customer orientated process.
Queries in this process are standardized and simple.	Complex queries involving aggregations.
Complete backup of the data combined with incremental backups.	OLAP only need a backup from time to time.
DB design is application oriented.	DB design is subject oriented.