Showing posts with label MD. Show all posts
Showing posts with label MD. Show all posts
Tuesday, July 25, 2023

NULL & THE "2ND ADDRESS LINE" (sms)

›
Note: In "Setting Matters Straight" posts I debunk online pronouncements that involve fundamentals which I first post on Linked...
Saturday, April 8, 2023

MISSING DATA: RDM VS SQL -- A REAL WORLD COMPARISON (t&n)

›
Note: "Then & Now" (t&n) is a new version of what used to be the "Oldies but Goodies" (OBG) series. To demonstra...
Wednesday, July 13, 2022

MISSING DATA AND MULTI-RELATION QUERY RESULTS (t&n)

›
Note: "Then & Now" (T&N) is a new version of what used to be the "Oldies but Goodies" (OBG) series. To demons...
Saturday, February 19, 2022

NO UNDERSTANDING WITHOUT FOUNDATION KNOWLEDGE PART 6: DEBUNKING AN ONLINE EXCHANGE 5 (obg)

›
Note: To demonstrate the correctness and stability offered by a sound theoretical foundation (relative to the industry's fad-driven ...
Sunday, February 13, 2022

NO UNDERSTANDING WITHOUT FOUNDATION KNOWLEDGE PART 5: DEBUNKING AN ONLINE EXCHANGE 4 (obg)

›
Note: To demonstrate the correctness and stability due to a sound theoretical foundation relative to the industry's fad-driven ...
Friday, January 21, 2022

READ MY LIPS: IF THERE'S NULLs, IT'S NOT RELATIONAL

›
“Let's say I want to store a list of movies that are stored on iTunes. For simplicity, we'll just store a few fields so that the fil...
Saturday, January 8, 2022

NO UNDERSTANDING WITHOUT FOUNDATION KNOWLEDGE PART 2: DEBUNKING AN ONLINE EXCHANGE 1 (obg)

›
Note: To demonstrate the soundness and stability conferred by a sound theoretical foundation (relative to the industry's fad-driven ...
Friday, December 17, 2021

NO UNDERSTANDING WITHOUT FOUNDATION KNOWLEDGE PART 2: DEBUNKING A BOOK REVIEW (obg)

›
Note: To demonstrate the correctness and stability offered by a sound theoretical foundation (relative to the industry's fad-driven ...
Saturday, July 10, 2021

Relational Misconceptions Part 2: RDM is Applied Theory

›
In Part 1 we showed (yet again) how even those with their heart in the right (relational) place can't help being affected by the common...
Saturday, January 16, 2021

OBG: Missing Data -- Many-valued Logics and NULL Part 2

›
Note: To demonstrate the correctness and stability due to a sound theoretical foundation relative to the industry's fad-driven "co...
Saturday, January 9, 2021

OBG: Missing Data -- Many-valued Logics and NULL Part 1

›
Note: To demonstrate the correctness and stability of a sound theoretical foundation relative to the industry's fad-driven "cookbo...
Friday, November 27, 2020

OBG: Missing Data -- "Horizontal Decomposition" Part 2

›
Note: To demonstrate the correctness and stability of a sound foundation relative to the industry's fad-driven "cookbook" pra...
Sunday, November 22, 2020

OBG: Missing Data -- "Horizontal Decomposition" Part 1

›
Note: To demonstrate the correctness and stability of a sound foundation relative to the industry's fad-driven "cookbook" pra...
Thursday, May 28, 2020

No Such Thing As "Current Relational Data Models"

›
“... the concept of a state group is indeed a missing modeling concept in relational/current data models...” Thus in a LinkedIn exchange....
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 ...
Sunday, July 15, 2018

Understanding Relations Part 3: Debunking Conventional Wisdom

›
(See Part 1 and Part 2 ) “A common term used in database design is a "relational database" -- but a database relation is not ...
Wednesday, July 4, 2018

N-ary vs. Binary Relations: Anatomy of a Compound Misconception

›
Note: This is a re-write of an older post, to bring it into line with the McGoveran formalization and interpretation [ 1 ] of Codd's t...
Saturday, April 1, 2017

"NULL Value" is a Contradiction in Terms

›
There is nothing wrong with Hugo Kornelis' picture of SQL NULL in NULL: The database's black hole . In fact, I recommend the series ...
14 comments:
Sunday, November 1, 2015

Re-write

›
See series starting at: The Principle of Orthogonal Database Design Part I
Sunday, September 20, 2015

Re-Write

›
Understanding Codd's 12 Rules for RDBMS