NOSQL and SQL Data Modeling: Bringing Together Data, Semantics, and Software, Paperback/Ted Hills

Descriere

How do we design for data when traditional design techniques cannot extend to new database technologies? In this era of big data and the Internet of Things, it is essential that we have the tools we need to understand the data coming to us faster than ever before, and to design databases and data processing systems that can adapt easily to ever-changing data schemas and ever-changing business requirements. There must be no intellectual disconnect between data and the software that manages it. It must be possible to extract meaning and knowledge from data to drive artificial intelligence applications. Novel No SQL data organization techniques must be used side-by-side with traditional SQL databases. Are existing data modeling techniques ready for all of this?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 No SQL 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 styleshow 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-speakhow to express logical data designs that are freer from implementation considerations than is possible in any other notationhow to understand key-value, document, columnar, and table-oriented database designs in logical and physical termshow to use COMN to specify physical database implementations in any No SQL or SQL database with the precision necessary for model-driven development A quick reference g