Data mining and warehouse

Question 1

What is data mining?

Answer 1

The examination of large sets of data to extract patterns and knowledge that would otherwise be unknown

Relies on techniques from database management, statistics and machine learning

Question 2

What are 6 data mining techniques?

Answer 2

1. Tracking patterns
2. Classification
3. Association (if a pattern happens, what’s likely to follow)
4. Outlier detection
5. Clustering
6. Regression (likelihood of a certain variable given another variable, shows relationship)
7. Prediction

Question 3

What is a data warehouse?

Answer 3

• A system that pulls together data from many different sources within an organisation for reporting and analysis

Reports created from complex queries within a data warehouse

Data warehouses can be used for data mining to gain new insights from the information held in many large databases