Category Archives: Uncategorized

The ABC of Data Warehousing

Data Warehousing, BI and Data Science

In this article I would like to define the terminology used in data warehousing. It is a data warehousing glossary, similar to my investing article: The ABC of Investing (link). I won’t cover terms used in business intelligence; I will only cover terms in data warehousing. Terms in bold are defined in this glossary.

This glossary consists of 2 levels. Only the first level is alphabetical. The second level is not. So the best way to use this glossary is by searching the term (Control-F).

  1. Archiving: an approach to remove old data from the fact table and store it another table (usually in different database). It is quite common that the old data is simply deleted and not stored any where else.
  2. Data Lake: a data store built in Hadoop file system, capable to store structured and unstructured It has analytic and query tools which enable users to…

View original post 1,017 more words

Advertisements

DBA Reactions

A few colleagues and I have been getting a good laugh from this series of animated gifs put up by Brent Ozar ( blog | twitter ) on this tumbler page.

Nearly all of “Strategy Consultants” I work with live in a world of PowerPoint, so this one amused me a lot:

http://dbareactions.tumblr.com/post/41357047431/when-the-datamodel-arrives-in-powerpoint-format

%d bloggers like this: