0
Difference between database and database warehouse?
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.
0
can you give me one example of each, please.