Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

what is difference between data mining and data wharehousing?

Status
Not open for further replies.

Rousseau10

Programmer
Joined
Feb 22, 2005
Messages
242
Location
US
what is difference between data mining and data wharehousing?

 
DATA MINING - The act of analyzing a database or data warehouse and searching for new facts based on the data. For example a supermarket may mine its customer data and find that 87% of people who buy tuna in a can also buy orange juice at the same time. Typically you mine data for meaningful relationships that you can exploit in business.
 
And datawarehousing is the act of storing immense amounts of data for later mining purposes. Usually, but not always, a data warehouse is a static database(s) where records are inserted/appended on a monthly, quarterly, or yearly basis, but rarely updated once they are put there.

There are plenty of examples where the existing records are updated, though, so it's not a hard set rule.



Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top