Explain the difference between data mining and data warehousing.
Answer
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.
More Related Links
Answer -
A data warehouse can be considered as a storage area where interest specific or
relevant data........
Answer - As mentioned, data in a warehouse comes from the
transactions. Fact table in a data warehouse consists........
Answer - ETL is Extract Transform Load. It is a process of
fetching.........
Answer - OLTP: Online Transaction and Processing helps and
manages applications based........
Answer -
Data Warehousing helps you store the data while business intelligence.....
|