• Home
  • Recent Q&A
  • Java
  • Cloud
  • JavaScript
  • Python
  • SQL
  • PHP
  • HTML
  • C++
  • Data Science
  • DBMS
  • Devops
  • Hadoop
  • Machine Learning
in Dataware house by
Q:

What is the difference between OLTP and OLAP?

1 Answer

0 votes
by
Following are the differences between OLTP and OLAP:

OLTP                                                         OLAP

Data is from original data source           Data is from various data sources

Simple queries by users                        Complex queries by system

Normalized small database                     De-normalized Large Database

Fundamental business tasks                  Multi-dimensional business tasks

Related questions

0 votes
asked Dec 15, 2020 in Sql by SakshiSharma
0 votes
asked Oct 20, 2019 in Dataware house by rajeshsharma
...