This paper deals with various segments of Data Warehouse. It discusses deeply all the components and necessary processes and techniques which are used in a Data Warehouse setting.
A Data Warehouse is a repository of integrated information, collected from any number and variety of data sources, including various databases and legacy data sources. The size of a data warehouse is generally enormous and the data warehouse normally stores a wide range of information that has been generated over long periods of time. Data related to business subjects such as products, markets, and customers are all collected, integrated, and housed under the data warehouse umbrella. When this vast wealth of information is interfaced to decision support tools that offer powerful data access and analysis capabilities, the data warehouse can be fully exploited by its users. There are available a number of data warehousing tools and products presently on the market.
All of these products provide comparatively easy access to the data warehouse, both at the enterprise and the data mart level. All of these tools also provide positive facilities for administering and managing a data warehouse. However, creation, maintenance, and daily administration of data warehouses are still alarming tasks that are far from being fully automated. The triumphant administration and management of a data warehouse demands skills and proficiency that go beyond those required of a traditional database administrator (DBA). There is a need for the creation of a position that is designated a Data Warehouse Administrator (DWA). The tasks of a DWA include those of a traditional DBA, but the DWA's job is significantly more multifaceted because of the nature of the data warehouse and its position within enterprise data architecture.
[Professor's surname][Course title][Date]Data WarehouseIntroductionData Warehouse:A data warehouse stores all the meaningful information that a...