Nosql and SQL Data Modeling ― Bringing Together Data, Semantics, and Software

The Concept and Object Modeling Notation (COMN) is able to cover the full spectrum of analysis and design. A single COMN model can represent the objects and concepts in the problem space, logical data design, and concrete NoSQL and SQL document, key-value, columnar, and relational database implementations. COMN models enable an unprecedented level of traceability of requirements to implementation. COMN models can also represent the static structure of software and the predicates that represent the patterns of meaning in databases.This book will teach you: ‧ the simple and familiar graphical notation of COMN with its three basic shapes and four line styles ‧ how to think about objects, concepts, types, and classes in the real world, using the ordinary meanings of English words that aren’t tangled with confused techno-speak ‧ how to express logical data designs that are freer from implementation considerations than is possible in any other notation ‧ how to understand key-value, document, columnar, and table-oriented database designs in logical and physical terms ‧ how to use COMN to specify physical database implementations in any NoSQL or SQL database with the precision necessary for model-driven development

Ted Hills has been active in the Information Technology industry since 1975. Starting with microprocessor design and "bare metal" programming, Ted moved gradually up through device drivers and operating systems to communications software, applications, and finally information architecture. Experience applying his top-to-bottom understanding of data, software, and computer architecture for many companies, including AT&T Bell Laboratories, Dow Jones, Bloomberg, Merrill Lynch, and Bank of America, has given Ted a deep understanding of the needs of modern business and of how to apply theory to practice. 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. Ted has always been an active researcher, with interests in software and data integration, data modeling notations, and improving the expressivity of languages while keeping them type-safe.