Data Warehouses
A data warehouse gets defined as a system that gets used in the storage and reporting on data, and it contains information from various sources of operations (Jukic et al., 2016). The data warehouse is comprised of structures of data that are populated by data that has been extracted from the OLTP database and gets transformed in order to fit a schema that is flatter. The structures of the data warehouse get exposed as star schemas by the fact views and the tables of dimensions (Bouaziz et al., 2019). The data warehouse has several components that include a database, query tools, ETL tools, DataMarts, and MetaData. Concerning access, the warehouse for storage of data is structured in such a way that the users from many departments or divisions in an organization can be able to have access to data and analyze it in accordance with their needs as it stores data from many sources of operations.
References
Bouaziz, S., Nabli, A., & Gargouri, F. (2019). Design a Data Warehouse Schema from a Document-Oriented database. Procedia Computer Science, 159, 221-230.
Jukic, N., Vrbsky, S., & Nestorov, S. (2016). Database Systems: Introduction to databases and data warehouses. Prospect press.