Data Warehousing

Data warehousing helps to provide information on theData warehouses are vast, due to the hundreds of
techniques involved in designing, building, maintaininggigabytes of transactions. As a result, subsets,
and retrieving information, from a data warehouse. Aknown as 'data marts,' are often designed for just
data warehouse is premeditated and produced toone department or product line.
support the decision-making process in anThe data warehouse system serves as an influential
organization. The data that is obtained from theand necessary platform, to merge the data from the
production databases are copied in the dataold and new applications. Rules can also be
warehouse, so that queries can be answered,transferred to the data warehouse, with very little
without hindering the consistency of the productioneffort. The most important and noteworthy features
systems.of a data warehouse is that it collects, records, filters
Data warehousing includes a set of important, newand provides the basic data, to other organizational
concepts and tools that have evolved into asystems, at various higher levels.
technology. This makes it possible to counter theEssentially, data warehouses are programmed to
problems involved in providing all the key information,perform the summarization and pre-defining of the
to the concerned people.analysis, to automatically generate summary reviews.
This field has evolved from the incorporation of aData warehousing helps to analyze information for
number of experiences and technologies, over thethe users. This system is very useful for providing
last two decades. Data warehousing is acollective information to the users. Data warehousing
well-organized and resourceful method of managingsystems have been created to support a variety of
and reporting data from a variety of sources,analysis, including elaborate queries on large amounts
non-uniform and scattered, throughout the company.of data that require extensive searching.