Discussion Locked

Data warehousing and data mining

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello I am doing a research on Data warehousing and data mining. I am new to this field. So I have some basic and difficult questions to be asked with respect to data warehousing and data mining.

The questions are as follows:

1. What are the differences between data warehousing and data mining? Where do we use data warehousing and where data mining?

2. With respect to data mining what are concept hierarchies?

3. Can you suggest some good websites on data mining?

4. Whatare cubes in data mining?

3 replies

by timthetoolman

Hi,

In answer to your questions...

1. In short a data warehouse is the data itself whereas data mining is the process of analysing that data. Here are two definitions...

A data warehouse is a copy of transaction data specifically structuredfor querying and reporting

Data mining refers to the whole process of knowledge discovery and sometimes to the specific machine learning phase.

2. Here is an extract from one of the sites I'm about to list...

Concept hierarchies organize data and concepts in hierarchical forms or in certain partial order, which helps expressing knowledge and data relationships in databases in concise, high level terms, and thus, plays an important role in knowledge discovery processes.

3. Data mining and Data warehousing...

Data Warehousing

http://www.dwinfocenter.org/

Data Mining

http://www.kdnuggets.com/faq/data-mining.html

(remove spaces from above URL)

4. Here is another definition...

The Data Cube is used to calculate and store summary information on a variety of dimensions, which is computed only partially if the number of dimensions is large

And for a dimension...

Dimension
An attribute or several attributes that together describe a property. For example, a geographical dimension might consist of three attributes: country, state, city. A time dimension might include 5 attributes: year, month, day, hour, minute.

Another couple of good websites I came across are...

http://www.supercomp.org/sc98/TechPapers/sc98_FullAbstracts/Goil660/

(remove spaces from above URL)

Hope this helps,
Cheers,
Tim.

This discussion is closed to new replies.