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.

Introduction

Databases play a critical role in almost all areas where computers are used, including education, library, science, medicine, business, law, engineering, and so on. Due to the recent developments, the storage capacity and the computing speed of the computers have increased, so now big data is being handled by the computers using different techniques handling the data. Data is a valuable asset for an organization. Data mining is the process of finding patterns in a given data set. Today, data mining is used in contexts of fraud detection, as an aid in marketing campaigns, and even by supermarkets. Data warehouse provides us generalized and consolidated data in a multidimensional view. Along with this view of data, data warehouses also supply us with online analytical processing (OLAP) tools. There is no frequent updating done in a data warehouse. Data cleaning and data transformation are important steps in improving the quality of data and data mining results. Sometimes data mining is called data or knowledge discovery.

Source: Parul Mittal
Creative Commons License This work is licensed under a Creative Commons Attribution 4.0 License.