This section deals with the fundamental concepts of Data warehousing that every DW professionals must know.
What is NoSQL
- Details
- Category: DWBI Basic Concepts
- Published on Tuesday, 24 April 2012 08:47
- Written by DWBIConcepts
- Hits: 122
What Is NoSQL Database?
NoSQL is not the name of any particular database instead it refers to a broad class of non-relational databases that differ from classical relational database management systems (RDBMS) in some significant aspects, most notably because they do not use SQL as their primary query language, instead providing access by means of Application Programming Interfaces (API).
What is Data Integration (DI)?
- Details
- Category: DWBI Basic Concepts
- Published on Thursday, 23 February 2012 17:30
- Hits: 460
In this tutorial we will learn - what is meant by the term "Data Integration" (DI), how data integration is done (that is different approaches of DI) and how the need of data integration require us to build a data warehouse.
BI News Flash - Feed your BI Appetite
- Details
- Category: DWBI Basic Concepts
- Published on Monday, 19 July 2010 20:09
- Written by Akash Mitra
- Hits: 572
So what's so great about Informatica® Identity Resolution™?
Informatica Identity Resolution is robust, highly scalable software that enables organizations to search and match identity data from more than 60 countries simultaneously, in both batch and real time. Know more...
What is a data warehouse - A 101 guide to modern data warehousing
- Details
- Category: DWBI Basic Concepts
- Published on Friday, 10 February 2012 11:32
- Hits: 728
This article discusses data warehousing from a holistic standpoint and quickly touches upon all the relevant concepts that one needs to know. Start here if you do not know where to start from.
Read more: What is a data warehouse - A 101 guide to modern data warehousing
Business Intelligence
- Details
- Category: DWBI Basic Concepts
- Published on Wednesday, 28 April 2010 16:37
- Written by Akash Mitra
- Hits: 1344
In a 1958 article, IBM researcher Hans Peter Luhn used the term business intelligence. He defined intelligence as: "the ability to apprehend the interrelationships of presented facts in such a way as to guide action towards a desired goal."
Data Retention and Purging in a Data Warehouse
- Details
- Category: DWBI Basic Concepts
- Published on Friday, 27 January 2012 12:44
- Hits: 608
By the typical definition of data warehouse, we expect the data warehouse to be non-volatile in nature for its entire design life time. As long as it remain operation, all data loaded in the data warehouse should remain there for the purpose of analysis. However, this is often not the case.
What is Data Warehousing?
- Details
- Category: DWBI Basic Concepts
- Published on Wednesday, 28 April 2010 16:17
- Written by Akash Mitra
- Hits: 1502
A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis.