Why does a data warehouse change much less often than a transactional/operational database?

Answered: Why does a data warehouse change much…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Why does a data warehouse change much less often than a transactional/operational database?

Expert Solution

Step 1

Why Data warehouse is changed much less often than a transactional or operational database?

Reasons :-

transactional or operational database are those system which is used to store or design to store the record any data of real time scenario. So its changed often while data ware house is used to analyze data and for analyzing data you need fix or stable data.
transactional or operational database are used to get or store the records or data in daily bases while data warehouse stores the constant data of transactional or operational database. Actually, transactional or operational database is the primary source for data warehouse.
transactional or operational database uses OLTP concept means online transactional processing where, data warehouse used OLAP means online analytic processing.
Main use of database is to store those data which is required to used in daily bases or in near by days so it might be changed very much but data warehouse is used to analyze old transaction or record which is not changed further in future so it will changed much less then transactional or operational database.