Immutable Data Warehouse
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What does immutable mean?
2. Why is data in a database described as mutable?
3. At the technology level, what must every database or data store allow?
4. By default, what kind of datastore is a data warehouse?
5. In the CUSTOMER data set example, which attributes are treated as immutable?
6. In the CUSTOMER data set example, why are address, contact details, jobs and cars considered mutable?
7. Where should the immutable or mutable behaviour of each data element be captured, and who should manage it?
8. In a data warehouse or data lake, for which tables is immutable behaviour a given?
9. What does the insurance business example illustrate about historical data in a data warehouse?
10. What is the architectural purpose of any data warehouse or data mart with respect to history?