Showing posts with label PDI. Show all posts
Showing posts with label PDI. 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...
Thursday, May 2, 2024

SMS: PRIMARY KEYS & INDEXES

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

PREDICATE LOGIC, SEMANTICS AND RDM (sms)

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

THE DENORMALIZATION ILLUSION (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, March 4, 2023

ON NORMALIZATION AND THE SCIENTIFIC METHOD (t&n)

›
(originally published August 2002) Note: "Then & Now" (T&N) is a new version of what used to be the "Oldies but Go...
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...
Saturday, October 29, 2022

NEW "DATA MODELS" 3 (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, September 17, 2022

NEW "DATA MODELS" 1 (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, June 11, 2022

ORDER & RELATIONAL DATABASES (sms)

›
Note: In "Setting Matters Straight" I post on LinkedIn online Q&As that involve fundamentals under the header "What...
Monday, May 2, 2022

RELATION PROLIFERATION (sms)

›
Note: "Setting Matters Straight" is a new format: I post on LinkedIn an online Q&A involving data fundamentals that I subse...
Friday, March 18, 2022

ENTITIES & RECORDS (sms)

›
  Note: "Setting Matters Straight" is a new format: I post on LinkedIn an online Q&A involving data fundamentals to encoura...
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 ...
Sunday, December 5, 2021

HOW NOT TO EXPLAIN THE RELATIONAL MODEL (tyfk)

›
Note: Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your know...
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, 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, July 1, 2021

OBG: Experimental Science and Database Design

›
Note: To demonstrate the correctness and stability conferred by a sound theoretical foundation relative to the industry's fad-driven, a...
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...
Monday, February 1, 2021

Normalization -- Will They Ever Learn?

›
“To Normalize or not to Normalize? that really isn't a question. few things to consider: Normalization is supposed to protect from data ...