DATA WARE HOUSING AND DATA MINING Seminar

[born_for seminars]

ABSTRACT:

A modern reporting environment will give users access to their data, but it doesn’t solve all their problems. Just because users have access to data doesn’t guarantee the integrity of that data. Nor does it guarantee that system response times will be adequate. It doesn’t guarantee that the users system won’t purge old data before its useful life is passed. Data warehousing and data mining can address the above problems and provide a technology that enables the decision-maker to process this huge amount of data in a reasonable amount of time and to extract intelligence/knowledge in a near real time.
A data warehouse is a database of data gathered from many systems and intended to support management reporting and decision-making. But users such as companies want to “mine” that data for other purposes (particularly for sales, marketing etc.,). So data mining techniques are employed for extracting new insight from the data warehouse.
Our paper focuses upon the overview of the data warehouse and data mining. We also specify the use of the data mining in various fields.














INTRODUCTION:

The age of industrial revolution has finally been completed and the world has entered the age of information technology. The need for data warehouse applications is one of the manifestations of this information technology age. It has becoming more of necessity than an accessory for a progressive, competitive, and focused organization. It provides the right foundation for building decision support and executive information system tools that are often built to measure and provide a feel for how well an organization is progressing toward its goal.
A data warehouse supports business analysis and decision-making by creating an enterprise-wide integrated database of summarized, historical information. It integrates data from multiple, incompatible sources .By transforming data into meaningful information, and a data warehouse allows the manager to perform more substantive, accurate and consistent analysis.
The data warehouse is not the normal database, as we understand the term “database”. The main difference is that the traditional databases hold operational-type most often, transactional type data and that many of the decision-support type applications put too much strain on the databases intervening into the day-to-day operation (operational database). A data warehouse is of course a database, but it contains summarized information.
Data warehouse refers to database that is maintained separately from an organizations operational databases. A warehouse holds read-only-data.