Data warehouse data modeling

As mentioned above, even the so-called masters of the data warehouse have differing ideas as to the data modeling methodology that should be used in a data warehouse. There is general agreement that seem to have the choices narrowed down to just two popular architectures. There is the Third Normal Form and the Dimensional Data Model.

Of the two main types of data modeling most popularly used in data warehousing the more common of the two is the Dimensional Data Model. Read on as we briefly explain the differences between the two.