Data Warehousing Technology

Data Warehousing Technology

Abstract

                                Data warehousing is the process of integrating enterprise-wide corporate data into a single repository from which end users can easily run queries, make reports and perform analysis. A data warehouse is a decision support environment that leverages data stored in different sources, organizing it and delivering it to decision makers across the enterprise, regardless of their platform or technical skill level.
                              As an integrated, subject-oriented collection of data, the data warehouse brings together common information from various sources. the data warehouse provides a stable source of information gathered over a period of time.
         Data mining and predictive analytics have the capability to provide large and midsize firms with highly detailed breakdown of business data warehouses. Data mining technologies enable enterprise managers make targeted, actionable decisions.
                             The goal of data warehousing is to free the information that is locked up in the operational databases and to mix it with information from other, often external, sources of data. This information includes demographic, econometric, competitive and purchasing trends. The so-called "information superhighway" is providing access to more data resources every day.
The following points are discussed in this paper:
•    Data access crises with traditional system
•    Operational vs. Informational Systems
•    Understanding the Framework of the Data Warehouse
•    Developing Data Warehouses
•    Data Warehouse Options
•    Managing Data Warehouses
•    What is Data Mining
•    Why it is Important
•    How it Works
•    Data Mining Techniques
•    Lucrative Applications of Data Mining