Data Warehousing and its History and Future
What is data warehousing? In the world of business intelligence, a data warehouse (DW or DWH) is the term used to describe a storage centre, or database, which is used strictly in regards to reporting and analytical purposes. A data warehouse is a compilation of data deposited from various sources, from operational systems such as marketing or sales, into a central location. The function of the warehouse is primarily to store data used for supporting managerial level business decisions. This warehouse would be regularly maintained and managed by a data warehouse developer.
Data warehousing warrants a developer to keep everything flowing properly. What is a data warehouse developer? This is a person, or team, who is responsible for the development of the operational systems from which data is ultimately extracted for future reference. This extraction load is called an ETL (extract transform load).
An ETL-based data warehousing process consists…
View original post 781 more words