Data Modeling News, Articles, & Education

EDW Slides: Data Quality for Data Modelers

EDW Webinar Series

This presentation was given in a live webinar on November 18, 2014 Enterprise Data World Webinars: Data Quality for Data Modelers from DATAVERSITY  To view the On Demand recording of this presentation, click HERE>> About the Webinar Data Quality begins with the conceptual model. It’s imperative that the modeler not only acknowledges data must be…

Degrees of Data Structuring – Again

degrees of data structuring x300

by Michael Brackett Data management is faced with a large and growing lexical challenge.  Many terms are created that do not have roots, prefixes, or suffixes applicable to data management.  Many terms are used, misused, abused, and abandoned when their usefulness is over.  Many terms are undefined or multi-defined and have no denotative definitions that…

10 Tips for Data Modeling in a Hybrid NoSQL/Relational World

Modern Data Warehouse Architecture Components

by Karen Lopez During my Big Challenges in Data Modeling; NoSQL webinar, Dan McCreary and I talked about how data modelers should approach NoSQL on development projects.  At the end, I shared these ten tips for working in a hybrid (NoSQL + relational) world.  You can listen to the webinar recording for more details about each.…

Modeling Webinar: Data Security, Data Breaches – Data Horrors

Modeling with Graeme

This presentation was given in a live webinar on October 23, 2014 Big Challenges in Data Modeling Webinar: Data Security, Data Breaches – Data Horrors from DATAVERSITY To view just the slides from this presentation, click HERE>> This Month’s Topic Focus: Data Security, Data Breaches – Data Horrors About the Webinar We invite you to…

Modeling Slides: Data Security, Data Breaches – Data Horrors

Modeling with Graeme

This presentation was given in a live webinar on October 23, 2014 Big Challenges in Data Modeling Webinar: Data Security, Data Breaches – Data Horrors from DATAVERSITY To view the On Demand recording of this presentation, click HERE>> This Month’s Topic Focus: Data Security, Data Breaches – Data Horrors About the Webinar We invite you…

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…