Data Warehouses and Data Mining

This article gives a detailed summary of the role of data warehouses and data mining, and their relationship to organizational databases. As you read, pay attention to how data warehouses are used to improve decision-making in organizations. Keep a summary in your notes of how an organization you are involved with could benefit from data mining and data warehousing.

Elements of Data Mining

Data mining consists of five major elements:

  1. Extract, transform, and load transaction data onto the data warehouse system.
  2. Store and manage the data in a multidimensional database system.
  3. Provide data access to business analyst.
  4. Analyze the data by application software.
  5. Present the data in a useful format.