NoSQL and SQL Logical and Physical Data Modeling with COMN

Video Description

Recorded live at Data Modeling Zone!

The Concept and Object Modeling Notation (COMN) supports contextual, logical, and physical data modeling for NoSQL and SQL DBMSs. In this advanced class, Ted Hills will walk through two physical models for a hypothetical coffee shop business, exploring a design for a document database for order capture and a traditional SQL database for data warehousing (a Star Schema). A COMN logical model ties it all together, ensuring that the two very different physical database designs are representing the same logical data. Along the way, Ted will explain the COMN notation.

Table of Contents

  1. Data Modeling Challenge 00:39:34
  2. Modeling Notation Overview 00:34:58
  3. Contextual Model Example 00:19:23
  4. Logical Model Example 00:40:06
  5. Physical Model Example 00:11:20

Product Information

  • Title: NoSQL and SQL Logical and Physical Data Modeling with COMN
  • Author(s): Ted Hills
  • Release date: November 2017
  • Publisher(s): Technics Publications
  • ISBN: 9781634622936