DONATE



 


Donors will receive my book 

THE DBDEBUNK GUIDE TO MISCONCEPTIONS ABOUT DATA FUNDAMENTALS - A DESK REFERENCE FOR THE THINKING DATA PROFESSIONAL AND USER


 

Reviews:

This book consists of 50 sections 1-3 pages long, each based on a carefully selected dbdebunk.com Q&A. Each documents and debunks one or more major common and entrenched myths/misconceptions/fallacies about data and relational fundamentals and discusses the practical implications thereof.

Instead of a Table of Content, there is an index of misconception categories:

  • Data independence (logical, integrity, physical)
  • Data integrity (business rules, integrity constraints, database consistency)
  • Data models (relational, hierarchic, network)
  • Relational data sub-language (vs. computationally complete language)
  • Database and application-specific functions
  • Domains (simple, non-simple, data types)
  • Entity supertype-subtypes (and inapplicable data)
  • Keys (natural, primary, surrogate)
  • Levels of representation (conceptual, logical, physical)
  • Missing data (NULL, many-valued logics)
  • Normalization, further normalization, denormalization, normal forms
  • Relational Data Model
  • Relations (base, derived) vs. R-tables
  • SQL and relational fidelity
  • Types of model (conceptual, logical, physical, data)
  • "Unstructured data"

which references, for each category, all the sections in which the misconceptions in that category is discussed, possibly in different contexts, or with different emphasis. Each section has a short list of directly relevant further readings, often including my PRACTICAL DATABASE FOUNDATIONS paper series (available via the PAPERS page).


 

 

No comments:

Post a Comment

View My Stats