The data warehouse, which can include both transactions as well as non-transaction data, is typically used as the foundation of a decision support system (DSS) that aims to meet the requirements of large business user community.
It is situated at the center of a decision support system (DSS) of an organization and contains historical data. The systems have become a key component of the corporate information system architecture, in which they play a crucial role in building business decision support system.
A data warehouse provides and infrastructure that enables users to obtain efficient and accurate response to complex queries. Data warehousing technology is becoming for effective business, business strategy formulation and implementation in a globally competitive environment, wherein larger and larger amounts of data are required to be processed faster and faster for comprehension of its real meaning and impact.