Difference between database and database warehouse? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Difference between database and database warehouse?

31st Aug 2016, 5:57 AM
Akash Jadoun
Akash Jadoun - avatar
2 Answers
0
They're both databases and they both contain tables containing data. The main difference is the purpose they have (the type of data stored). Databases are designed to record - application databases are OLTP (On-Line Transaction Processing) systems. A Data Warehouse is designed for quering and analysis, usually as OLAP (On-Line Analytical Processing) systems. Hope my answer was helpful to you, for more info try google-ing the subject, you'll find more accurate answers.
31st Aug 2016, 10:56 PM
Gamer Girl
Gamer Girl - avatar
0
can you give me one example of each, please.
3rd Sep 2016, 4:04 PM
SNEHA CHELLADURAI
SNEHA CHELLADURAI - avatar