Which are the four keywords that distinguish data warehouse from other data repository systems.
Answers
Answer:
Data warehousing vs. database
A data warehouse need not be the same idea as a traditional database. A database is a transactional system set to track and change the data in real-time so that only the most current data is available. A database is configured over a period to store the structured data. For example, a database could only have a customer’s most current address, while a data warehouse could have all the addresses in which the consumer has resided for the past ten years.
I hope this helps you
Answer:
The required four keywords are:
- Subject-oriented
- Integrated
- Time-variant
- Non- volatile
Explanation:
Data warehouses are distinguished from other data repository systems like relational database systems, transaction processing systems, and file systems by the four keywords: subject-oriented, integrated, time-variant, and non-volatile.
- Several methods of gathering and storing data might be referred to as "data repositories," including: A data warehouse is a sizable data repository that collects data without necessarily connecting them from various sources or business sectors.
- An enterprise data storage entity that has had data specifically partitioned for analytical or reporting purposes is referred to as a data repository.
- The goal of a data repository is to maintain an isolated population of data so that it can be mined for deeper understanding or applied to a particular reporting requirement.
#SPJ3