Data warehousing & data mining

Data warehousing - Difference between data mining and data warehousing - August 07, 2008 at 17:10 pm by Rajmeet Ghai

Explain the difference 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.

Data warehousing - Difference between data mining and data warehousing - May 11, 2009 at 14:40 pm by Vidya Sagar

Explain the difference between data mining and data warehousing.

Data mining is a method for comparing large amounts of data for the purpose of finding patterns. Data mining is normally used for models and forecasting. Data mining is the process of correlations, patterns by shifting through large data repositories using pattern recognition techniques.

Data warehousing is the central repository for the data of several business systems in an enterprise. Data from various resources extracted and organized in the data warehouse selectively for analysis and accessibility.


Write your comment - Share Knowledge and Experience

More Related Links
What is Data warehousing?

Answer - A data warehouse can be considered as a storage area where interest specific or relevant data........            

What are fact tables and dimension tables?

Answer - As mentioned, data in a warehouse comes from the transactions. Fact table in a data warehouse consists........

What is ETL process in data warehousing?

Answer - ETL is Extract Transform Load. It is a process of fetching.........

What is an OLTP system and OLAP system?

Answer - OLTP: Online Transaction and Processing helps and manages applications based........

Explain the difference between Data warehousing and Business Intelligence.

Answer - Data Warehousing helps you store the data while business intelligence.....

Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us