Row vs Column Oriented Databases
Column oriented databases have become dominant over row oriented databases in data warehousing.
Data Modeling
Dimensional Modeling - Part 1: Basic Fact Table Techniques
In this article, I will introduce the concept of the Basic Fact table in Dimensional data modeling. To understand this technique, we will explore the different types of data modeling and recap some fundamental knowledge, including the star and snowflake schemas, and the concepts of normalization.
Types of Fact Tables: Data Warehouse
This article provides an in-depth examination of various types of Fact Tables and their incredible ability to uncover valuable insights…