Click to learn more about author Michael Blaha. Let’s continue last month’s discussion about different kinds of data models and look at data interchange models. My interest in this topic was piqued by several encounters with overly complex data interchange models. Data Interchange Model A data interchange model provides the means to convey data among […]
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 […]
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 […]
Why Non-Tech Execs Should Understand Data Modeling
by Angela Guess Eran Levy recently wrote in Smart Data Collective, “For many non-technical individuals in the business world, data modeling can seem like a strange and somewhat terrifying realm. Even those who are data-savvy and regularly consult and analyze data in their day-to-day operations will often view modeling as perplexing under-the-hood stuff that is […]
Documenting Data Models
Click here to learn more about author Michael Blaha. Once you’ve created a data model, how do you document it? You need to deliver the model’s content to others – to business sponsors, other developers, and posterity for purposes that you may not envision. This article looks at options for documenting data models and their […]
Ten Reasons Why Developers Ignore Data Models — Revisited
Click here to learn more about author Michael Blaha. Here is a follow- up on my blog from several months ago on “Ten Reasons Why Developers Ignore Data Models.” Paraphrasing, reader Lawrence Hecht asked via Twitter if there is any way to tell from a schema if the developers had used a data model. A […]
Embarcadero Announces ER/Studio 2016 with Expanded Data Modeling
by Angela Guess A new article out of the company reports, “Embarcadero Technologies (recently acquired by IDERA), a leading provider of database lifecycle management solutions, today released ER/Studio® 2016, a powerful data architecture solution that combines multi-platform data modeling, design and reporting with cross-organizational team collaboration for data architectures and enterprises of all sizes. The […]