Data Mining

What is a Data warehouse?

Data Mining

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)”.
 

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.

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.
 

What is OLTP?

Data Mining

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

OnLine Transactional Processing.

What is OLAP?

Data Mining

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

OnLine Analatical Processing
 

Page 1 of 2

«StartPrev12NextEnd»

Login Form (Can use your Gmail Acct)

Latest Comments

Copyright © 2017 Interview Questions, Tutorials, Certification Questions. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.