Saturday, September 29, 2018

Understanding Conceptual vs.Data Modeling Part 2: E/RM Models Reality, RDM Models Data

›
Re-write 10/17/18 Revised 11/1/18 In Part 1 we explained that when the RDM and the E/RM were introduced, the distinct conceptual-logical-...
Tuesday, September 18, 2018

Don't Conflate/Confuse Primary Keys, PK Constraints, and Indexes

›
“What is the difference between an index and a key? How are they related?” “There seams to be some confusion between what a Primary Key ...
Tuesday, September 11, 2018

RE-WRITE

›
See: https://www.dbdebunk.com/2018/09/designation-property-and-assertion.html
Wednesday, August 29, 2018

DISTINCT and ORDER BY Are Not Relational

›
“One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query ... most people quickly und...
Wednesday, August 15, 2018

Order Is For Society, Not Databases

›
8/18/18: I have re-written this post for a better explanation. If you read it prior to the revision, you should re-read it.   “I learned...
Sunday, August 5, 2018

No Such Thing As "Primary Key Tuning"

›
“The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing ...
Monday, July 30, 2018

Lenin, Trotsky, Data Management, and the Tyranny of Knowledge and Reason -- Version 2

›
14 years ago I published an editorial with this title in response to a Slashdot.com exchange triggered by one of my articles at DBAzine.com...