Question

: Defines the terms in your own words
i. Data warehouse and Data mining
ii. Pattern and Data purging?
iii. When we can say the association rules are interesting?

Answer 1

(i)

A data warehouse is a technique for collecting and managing data from varied sources to provide meaningful business insights. It is a blend of technologies and components which allows the strategic use of data.

Data Warehouse is electronic storage of a large amount of information by a business which is designed for query anrd analysis instead of transaction processing. It is a process of transforming data into information and making it available to users for analysis.

Data mining is considered as a process of extracting data from large data sets, whereas a Data warehouse is the process of pooling all the relevant data together.

Data mining is the process of analyzing unknown patterns of data, whereas a Data warehouse is a technique for collecting and managing data.

Data mining is usually done by business users with the assistance of engineers while Data warehousing is a process which needs to occur before any data mining can take place

Data mining allows users to ask more complicated queries which would increase the workload while Data Warehouse is complicated to implement and maintain.

Data mining helps to create suggestive patterns of important factors like the buying habits of customers while Data Warehouse is useful for operational business systems like CRM systems when the warehouse is integrated.

(ii)

Data purging is a term that is commonly used to describe methods that permanently erase and remove data from a storage space. There are many different strategies and techniques for data purging, which is often contrasted with data deletion. Deletion is often seen as a temporary preference, whereas purging removes the data permanently and opens up memory or storage space for other uses.

(iii) Solution is attached in the picture.