Posts in category DWH Basics

OLTP and OLAP Data Systems

In data warehousing and business intelligence, we often hear the terms OLTP and OLAP. What do these mean? Why the different systems? What are pros and cons of each of these systems? When to use which system? We will address these questions in this article. Definition: IT systems can be categorized broadly into two types. Transactional systems [...]

Data Warehousing: An Introduction

A simple definition of a Data Warehouse would call it a collection of databases. This oversimplified version, while easy to use to explain to a layman, is not entirely correct. While a Data Warehouse will contain data from a multitude of databases, it does not exactly stand to the definition of collection of databases. Definition of a Data Wa [...]

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 2 other subscribers

February 2017
« Feb