Data Warehouse and Warehousing || Basic To Advance Concepts

DATA WAREHOUSE

Data warehouse is a collection of data that support decision making processes. It provide the following features are

·        Subject oriented

·        Consistent

·        Shows its evaluations over time

·        Non volatile

A data warehouse is a central location where consolidated data from multiple locations are stored. It is like a relational database design for analytical processing.

DATA WAREHOUSING

Data warehousing is the act of organizing data and storing data in a way so as to make its retrieval efficient and insightful. Also called data as the process of transferring  data into information. Is a collection of method, techniques, and tools to support knowledge workers to conduct data analysis that help with performing decision making process and improving information resources.