Polyglot Persistence is a process for storing data in in the best database available, no matter the data model and data storage technology. This process is based on the understanding different data stores will handle certain types of data better than others. Polyglot Persistence is, unfortunately, not available for easy “downloading”, but must designed for […]
LDM Webinar: Data Modeling & Metadata Management
To view just the slides from this presentation, click HERE>> About the Webinar Metadata management is critical for organizations looking to understand the context, definition and lineage of key data assets. Data models play a key role in metadata management, as many of the key structural and business definitions are stored within the models themselves. […]
LDM Slides: Data Modeling & Metadata Management
Data Modeling & Metadata Management from DATAVERSITY To view the On Demand recording of this presentation, click HERE>> About the Webinar Metadata management is critical for organizations looking to understand the context, definition and lineage of key data assets. Data models play a key role in metadata management, as many of the key structural and […]
Enterprise Data Modeling
It’s important to have data models guide the development of individual applications and ensure that they meet business objectives. But it’s not sufficient. Other kinds of data models, such as enterprise data models, are also part of proper Data Governance. This article will explore the fundamentals of Enterprise Data Modeling. What Is an Enterprise Data […]
MIT Sloan Professor Builds New Meta-Analysis Method to Help Settle Unresolved Debates
by Angela Guess According to a recent press release, “Science progresses when researchers build on prior work to extend, test, and apply theories. Aggregating the quantitative findings from prior research – meta-analysis — plays a significant role in advancing science, however current techniques have limitations. They assume prior studies share similar substantive factors and designs, […]
Identity: Working with Surrogate Keys
Click to learn more about author Michael Blaha. Identity is the means for denoting individual entities, so that they can be found. Identity is a prominent concern for databases because developers must have some way for referring to things. There are two aspects of identity – how to connect records together (internal identity) and how […]
Building a Data Governance Program with Data Modeling
“How do you make Data Governance real where the rubber hits the road?” asked Danny Sandwell, speaking at the Enterprise Data World 2016 Conference. Sandwell, who is Product Marketing Manager for erwin, Inc. said that organizations using data models to aid in the creation of a solid Data Governance Program are better able to meet […]
Softcoded Data
Click to learn more about author Michael Blaha. Database applications typically have a direct representation. Application concepts are represented as tables with their attributes stored as table columns. This direct approach works well for applications with fixed structure. However, it fails for applications with structure that is not fully known as the application is being built. […]
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 […]
Debugging Complex SQL Queries
Click to learn more about author Michael Blaha. We favor the offloading of application logic to SQL queries. Developers can save time, effort, and reduce mistakes by substituting SQL for programming code. This leads to lengthy and complex SQL that must be debugged. It is common to write a SQL query that initially fails to execute. […]