what is difference between data mining and data wharehousing?

[Rousseau10]

what is difference between data mining and data wharehousing?

 

[Rousseau10]

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.

 

[Catadmin]

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!"