Data Modeling News, Articles, & Education

Please Index Foreign Keys!

Michael Blaha

by Michael Blaha In the database literature, the lore has been to first design a schema and then predict the query mix to decide on a tuning strategy. This approach can work, but it is risky and error prone. A small misjudgment of the query mix can lead to vastly inferior performance. For many applications…

Data-Ed Webinar: Trends in Data Modeling

Data-Ed Thumbnail

This presentation was given in a live webinar on October 14, 2014 Data-Ed Online: Trends in Data Modeling from DATAVERSITY To view just the slides from this presentation, click HERE>> About the Webinar Businesses cannot compete without data. Every organization produces and consumes it. Data trends are hitting the mainstream and businesses are adopting buzzwords…

Data-Ed Slides: Trends in Data Modeling

Data-Ed Thumbnail

This presentation was given in a live webinar on October 14, 2014 Data-Ed Online: Trends in Data Modeling from DATAVERSITY To view the On Demand recording of this presentation, click HERE>> About the Webinar Businesses cannot compete without data. Every organization produces and consumes it. Data trends are hitting the mainstream and businesses are adopting…

Data Resource Anomalies

Anomaly x300

by Michael Brackett An anomaly is a deviation from the common rule; an irregularity; something different, abnormal, peculiar, or not easily classified.  A data resource anomaly is a deviation of an organization’s data resource from the common rule of being based on the organization’s perception of the business world and how it chooses to operate…

Modeling Slides: Modeling Metadata

Modeling with Graeme

This presentation was given in a live webinar on September 25, 2014 Big Challenges in Data Modeling: Modeling Metadata from DATAVERSITY To view just the On Demand recording of this webinar, click HERE>> This Month’s Topic Focus: Modeling Metadata About the Webinar We invite you to join us in this monthly DATAVERSITY webinar series, “Big…

Modeling Webinar: Modeling Metadata

Modeling with Graeme

This presentation was given in a live webinar on September 25, 2014 Big Challenges in Data Modeling: Modeling Metadata from DATAVERSITY To view just the slides from this presentation, click HERE>> This Month’s Topic Focus: Modeling Metadata About the Webinar We invite you to join us in this monthly DATAVERSITY webinar series, “Big Challenges with…

Myth 2 – Meaningless Normalization

?NF

by Karen Lopez Does this happen to you: someone gives you a table structure and asks you to say what normal form it’s in?  You look at it, see something that looks like repeating groups and some columns that look like they aren’t supposed to be mixed up with all those other columns (lets say…

Specify the Data Model and the Database Design

Michael Blaha

by Michael Blaha Many organizations today outsource software development. You, the customer, specify your requirements and the vendor is supposed to build software that meets your requirements. But requirements are not sufficient as a specification. With this common scenario, you have no control over the quality of the software being built. Furthermore, you have no…

Characteristics of a Great Enterprise Data Modeler – Part II

Number five button

by Karen Lopez In a previous post, I wrote about five characteristics of a great data modeler and why it’s important to assess these traits during the interview process.  I continue here with five more characteristics. That brings us to a total of ten. In the comments below, I’d love to hear about other characteristics you’d want…

Modeling Webinar: Supertyping and Subtyping

Modeling with Graeme

This presentation was given in a live webinar on August 28, 2014 Big Challenges in Data Modeling: Supertyping and Subtyping from DATAVERSITY To view just the slides from this presentation, click HERE>> This Month’s Topic Focus: Supertyping and Subtyping About the Webinar We invite you to join us in this monthly DATAVERSITY webinar series, “Big…