Study of Data Warehouse Architecture

Data warehousing is the essential elements of decision support, which has increasingly become a focus of the database industry. Many commercial products and services are now available, and all of the principal database management system vendors now have offerings in these areas. Decision support places some rather different requirements on database technology compared to traditional on-line transaction processing applications. This paper provides an overview of data warehousing with an emphasis on their new requirements and alsodefine back end tools for extracting, cleaning and loading data into a data warehouse, front-end client tools for querying and data analysis and tools for metadata management and for managing the warehouse.