Showing posts with label LV. Show all posts
Showing posts with label LV. Show all posts
Saturday, June 1, 2024

SMS: DOMAINS & SQL

›
I am working on entirely new papers (not re-writes) in the PRACTICAL DATABASE FOUNDATIONS series. I have already published two: THE FIRST NO...
Saturday, February 4, 2023

CONCEPTUAL MODELING, LOGICAL DATABASE DESIGN AND PHYSICAL IMPLEMENTATION (sms)

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

 NEW "DATA MODELS" 5.2 (t&n)

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

NEW "DATA MODELS" 4 (t&n)

›
Note: "Then & Now" (T&N) is a new version of what used to be the "Oldies but Goodies" (OBG) series. To demonstr...
Sunday, August 28, 2022

NOBODY UNDERSTANDS DATABASE DESIGN 1 (sms)

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

DATABASE RELATIONS, DATABASE DESIGN & CORRECTNESS (sms)

›
Note: In "Setting Matters Straight" posts I debunk online Q&As that involve fundamentals which I first post on LinkedIn. Th...
Saturday, May 21, 2022

NO RDBMS WITHOUT RELATIONAL DOMAINS (obg)

›
Note: To demonstrate the correctness and stability due to a sound theoretical foundation relative to the industry's fad-driven "...
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 ...
Saturday, January 1, 2022

SCHEMA & PERFORMANCE: NEVER THE TWINE SHALL MEET

›
One of the core objectives of this site (and my work) has been to demonstrate that there will not be progress in data management as long as ...
Saturday, December 11, 2021

NOBODY UNDERSTANDS THE RELATIONAL MODEL: SEMANTICS, CLOSURE & CORRECTNESS PART 4

›
with David McGoveran (Title inspired by Richard Feynman) In Parts 1 and Part 2 we provided some clarifications following a discussion on L...
Friday, November 19, 2021

THE FATE OF FADS: XML DBMS (obg)

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

Understanding Relational Constraints

›
“The data in a relational database is stored in form of a table. A table makes the data look organized. Yet in some cases we might face issu...
Tuesday, August 31, 2021

TYFK: Normalized, Fully Normalized, Non-Normalized, Denormalized -- Clearing the Mess

›
Note: Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your know...
Thursday, July 22, 2021

Documents and Databases

›
'These new data technologies were developed because there are new usage scenarios for data — which do not fit into the relational model....
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...
Thursday, June 10, 2021

RE-WRITE

›
See: https://www.dbdebunk.com/2023/08/entities-properties-and-codds-sleight.html
Thursday, March 25, 2021

OBG: Don't Confuse Levels of Representation Part 1

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

"Codd was wrong" and "You're teaching the gospel" Betray Lack of Foundation Knowledge

›
Note: I have documented and debunked these misconceptions so many times that I will no longer reference them -- the reader motivated to...
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...
Saturday, October 17, 2020

Understanding Codd's 12 Rules for RDBMS

›
In response to an online publication of a book appendix regurgitating Codd's 12 famous rules (some of which were, typically, incorrect[ ...