The purpose of data warehouse is to consolidate and integrate data from a variety of sources, and…
The purpose of data warehouse is to consolidate and integrate data from a variety of sources, and to format those data in a context for making accurate business decisions. A data warehouse is an integrated and consistent store of subject-oriented data obtained from a variety of sources and formatted into a meaningful context to support decision making in an organization. This chapter discusses the goals of data warehousing, characteristics of data in a data warehouse, and different types of data warehouse architectures. Two types of data warehouse design like logical and physical data warehouse design are discussed in depth. Finally, the user interface which gives a brief introduction to contemporary interfaces for data warehouses is discussed.