The ABC of Data Warehousing
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).
- 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.
- 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