Sql server - Differentiate between Data Mining and Data warehousing

Differentiate between Data Mining and Data warehousing.

Data warehousing is merely extracting data from different sources, cleaning the data and storing it in the warehouse. Where as data mining aims to examine or explore the data using queries. These queries can be fired on the data warehouse. Explore the data in data mining helps in reporting, planning strategies, finding meaningful patterns etc.

e.g. A data warehouse of a company stores all the relevant information of projects and employees. Using Data mining, one can use this data to generate different reports like profits generated etc.

Differentiate between Data Mining and Data warehousing.

Data mining:

A process for comparing large amounts of data for finding patterns.
Intended for statistically inclined users.
Uses the logic of pattern recognition for identifying trends within a sample data set.

Data warehousing:

The ability to data that is the result of data mining that is to be used in future for database inquiries.
Intended for the users those are to be data experts who analyze by business dimensions directly
A process used for extracting and storing data which allows easier reporting
Sql server - What is Data purging?
Deleting data from data warehouse is known as data purging. While loading data into staging or in the target table fresh data loading may be needed every time.....
Sql server - What are CUBES?
A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily......
Sql server - What are OLAP and OLTP?
OLTP: Online Transaction and Processing helps and manages applications based on transactions involving high volume of data........
Post your comment