The Enterprise Data World 2017 Conference in Atlanta in the beginning of April was one of the best I have attended in recent years. At least 50 sessions for a guy like me interested in modeling. I chose to focus on sessions possibly related to Data Modeling in the new worlds of NoSQL, Big Data […]
Surrogate Keys: Paving the Way for Graph / NoSQL Data Models
Click to learn more about video blogger Thomas Frisendal. Since the mid-seventies many SQL-databases have been modeled using the concept of surrogate keys: Non-information bearing primary keys Used for join purposes (inter-table relationships) System generated (integer) values Not to be shown to end-users The advantage of using surrogate keys is guaranteed persistence, even across changes in […]
Artificial Intelligence vs. Human Intelligence: Hey Robo Data Modeler!
Click to learn more about author Thomas Frisendal. In the data space plenty of new terms are being coined (by marketing?) for handling data modeling, governance and quality issues: “data preparation”, “data wrangling”, “data catalogue” and “machine-based data harmonization” (™ of ClearStory Data). Do we need stuff like this? Definitely so. Today we need to move […]
Visual Normalization – Use the Power of the Dependencies
Click to learn more about author Thomas Frisendal. One of the major contributions of Dr. Ted Codd’s relational model is the focus on the importance of functional dependencies. In fact, normalization is driven by a modeler’s desire for a relation where strict functional dependency applies across all the binary relations between the designated primary key and […]
Data Modeling: Why Not 3D?
Click here to learn more about author Thomas Frisendal. Data Models are meant to communicate structure of information to recipients, who need to understand it. But who are these recipients? In fact, they are human beings. Given that, we should choose our means of communication to be the most effective that we can find. Other […]