NoSQL and SQL Logical and Physical Data Modeling with COMN

NoSQL and SQL Logical and Physical Data Modeling with COMN

Ted Hills, LexisNexis

The Concept and Object Modeling Notation (COMN) supports 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 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. It is helpful, but not essential, if you have attended the course Data Modeling in the NoSQL World.

About the Speaker

Ted has been active in the Information Technology industry since 1975, moving gradually up through device drivers and operating systems to communications software, applications, and finally information architecture. Past employers include Bank of America, AT&T Bell Laboratories, Dow Jones, and Bloomberg. At LexisNexis, Ted co-leads the work of establishing enterprise data architecture standards and governance processes, working with data models and business and data definitions for both structured and unstructured data. Prior to joining LexisNexis, Ted was the Enterprise Information Architecture Executive for Bank of America, where he led several enterprise reference data and data warehouse projects. Ted’s work spans the spectrum from conceptual design through database and software implementation. Ted has always been an active researcher, with interests in software and data integration, data modeling notations, and improving the expressiveness of languages while keeping them efficient and type-safe.