HI everyone!



If somebody can tell me the difference between Data warehousing and Data mining? And also their definitions

Data warehousing is a concept where all the data irrespective to the subject can be stored and where as Data mining is a concept of retrieving the data belong to the specific subject from Data warehouse.

In specific we will retrieve data from data mart, which is subset of data warehouse based on some specific rules.

Hi falgunidave,


Data warehousing is a concept of building a dataware house which is a subject oriented,non volatile,integrated and time variant in nature.all the aspects such as extracting,transformation and loading into the dataware house comes under datawarehousing.
Data mining is a concept of drilling down the data in the data warehouse or from any datamart specifying some paricular subject.

Data warehousing is the process of collecting data from across disparate company sources into an architecture designed for data access. Data mining is one of those data access mechanisms although mining can occur against data not in data warehouses.