Home \ Tutorials \ Data Warehousing Tutorials \ Data Mining

Data Mining

What is a Data warehouse?

Written by DataWarehousing Guru Wednesday, 19 May 2010 03:06

A Data warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources and stored in a database for easy and more efficient way to run queries and create reports. A data warehouse is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision-making tasks, primarily, a record of an enterprise’s past transactional and operational information, stored in a database designed to favour efficient data analysis and reporting (especially OLAP)”.

Add new comment

What is data mining?

Data Mining

Written by DataWarehousing Guru Wednesday, 19 May 2010 03:06

Data mining is a process of extracting hidden trends within a datawarehouse. For example an insurance data warehouse can be used to mine data for the most high risk people to insure in a certain geographial area.

Add new comment

What are Data Marts?

Data Mining

Written by DataWarehousing Guru Wednesday, 19 May 2010 03:06

Data Marts are subset of the corporate-wide data that is of value to a specific group of users. There are two types of Data Marts: 1.Independent data marts – sources from data captured form OLTP system, external providers or from data generated locally within a particular department or geographic area. 2.Dependent data mart – sources directly from enterprise data warehouses.

Add new comment