There are three types of slowly changing dimensions: Type 1, Type 2, and Type 3. Each of these types tries to help the designer of the star schema eliminate paradox from their dimensional model (just as the three interpretations of the Schrödinger’s Cat thought experiment tries to eliminate the paradox of the living dead).
If you are looking to learn about logical data modeling here is the first of a series of 9 videos by Dr. Art Langer who goes in detail and step by step in teaching you logical data modeling. You can check out the entire list
There is a quite a bit of misinformation in the world of Dimensional Modeling on what certain things are and what they aren’t and Fact Tables are often misunderstood. The term “Fact” in relation to Data Warehousing/Dimensional Modeling really started from a joint research project conducted by General Mills and Dartmouth University the 1960’s
If you are new to Data Modeling or are interested in getting started it can be hard to know where to start and what tools to learn and use. One of the best software tools you can get for Data Modeling is called ERwin Data Modeler. It it used all over the world and by [...]
What is a conceptual data model?
A conceptual schema or conceptual data model is a map of concepts and their relationships. This describes the semantics of an organization and represents a series of assertions about its nature. Specifically, it describes the things of significance to an organization (entity classes), about which it [...]
Ralph Kimball is an author on the subject of data warehousing and business intelligence. He is widely regarded as one of the original architects of data warehousing and is known for long-term convictions that data warehouses must be designed to be understandable and fast. His methodology, also known as dimensional modeling or the [...]
In Ralph Kimball’s book “The Data Warehouse Toolkit” he describes the basic elements of a data warehouse. There are essentially four main components: Operational Source Systems, Data Staging Area, Data Presentation Area, and Data Access Tools. Although Operational Source Systems is part of the model, Kimball states “The source systems should really [...]
The Real Purpose
As it was stated in the last post “Logical Data Modeling 101 (part 1)”, within the next few posts the topics will cover what was posted here at Learn Data Modeling as well as offer some good examples on what it should look like using one of [...]
Tools, Topics, and Data Modeling
There is a great site called Learn Data Modeling” that provides tons of good material in order to learn all about the practice of data modeling. At Learn Data Modeling they have a couple pages on what you should learn about data modeling [...]
If you are looking for some usable and significant data for either creating reports, statistical modeling, or anything else then here is a list of 10 places you can go to download data.
- 2,092 feed subscribers
Tags2008 Analysis Analytics Article Big Data Book Business Intelligence Charts Cognos Dashboards Data Data Warehouse Design Dimensional Flow Elements Fusion Tables Google Humor IBM Install Learning Logical Market Microsoft Model Modeling Operational Predictive Programming Python Ralph Kimball Reporting Science Server SQL SSIS Statistics TED Tools Tutorial Unstructured Video Visualization Warehousing Windows