Data Warehousing Concepts

This section deals with the fundamental concepts of Data warehousing that every DW professionals must know.

What is NoSQL

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

Read more: What is NoSQL

What is Data Integration (DI)?

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.

Read more: What is Data Integration (DI)?

BI News Flash - Feed your BI Appetite

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

Read more: BI News Flash - Feed your BI Appetite

What is a data warehouse - A 101 guide to modern data warehousing

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

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."

Read more: Business Intelligence

Data Retention and Purging in a Data Warehouse

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.

Read more: Data Retention and Purging in a Data Warehouse

What is Data Warehousing?

A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis.

Read more: What is Data Warehousing?

Need more help on this subject?

Free BI Digest