WAREHOUSE is a collection of Diverse or varied data such as, subject oriented, aimed at executive, decision maker, often a copy of operational data with value-added data (e.g., summaries, history), integrated, time-varying, non-volatile. Data Warehouse is a collection of tools such as gathering data, cleansing, integrating, querying, reporting, analysis, data mining, monitoring, administering warehouse. Data warehousing consumes a significant share of corporate IT budgets and can contribute significantly to meeting information management goals.
Data Warehouse (DW) requires techniques completely different from those accepted for operational systems; no significant effort has been made so far to develop a complete and consistent adhoc design methodology.
Subject Oriented – When any data collect from a bank, then do work with only bank related all terms, that is subject oriented.