DATA WAREHOUSE

CHAPTER 8

Data warehouse is a database used for reporting and data analysis.it is central repository of data which is created by integrating data from one or more disparate sources. data warehouse store current as well as historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.
Data mart are related sets of data that are group together and separated out from the main body of data in the data warehouse.

The prime  purpose of data warehouse is to store , in one system data and information that originates from multiple application within or across organizations. the data may stored as received from the sources application or it may be processed upon input to processed upon to validate, translate, aggregate or derive new data.
relationship between business intelligent and data warehouse:
Business intelligent refers to the application and technologies that are used to gather, provide access to and analyze data information to support decision making efforts. as business started automating more and more system more and more information are available. However, collection remained challenge due to lack of infrastructure for information exchange or to incompatibilities between systems. in modern businesses, increasing standards automation and technologies have led to vast amount of available information..