Showing posts with label POOD. Show all posts
Showing posts with label POOD. Show all posts
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...
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...
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...
Sunday, April 10, 2022

QUOTA QUERIES (sms)

›
Note: "Setting Matters Straight" (SMS) is a new format: I post on LinkedIn an online Q&A involving data fundamentals that I...
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...
Thursday, November 11, 2021

Nobody Understands the Relational Model: Semantics, Relational Closure and Database Correctness Part 2

›
 with David McGoveran  (Title inspired by Richard Feynman) In Part 1 we explained that all database relations are, mathematically, relation...
Wednesday, October 27, 2021

Nobody Understands the Relational Model: Semantics, Relational Closure and Database Correctness Part 1

›
 with David McGoveran  (Title inspired by Richard Feynman) “As currently defined, relational algebra produces anomalies when applied to non-...
Sunday, September 19, 2021

TYFK: Calculated Attributes -- Redundancy, Full Normalization and Relational Theory

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

OBG: Database Design and Guaranteed Correctness Part 2

›
Note: This is a re-write of an earlier post (which now links here), to bring it into line with the current understanding of the RDM deriv...
Monday, March 23, 2020

TYFK: How (Not) to Compare NoSQL Systems and RDBMSs

›
Note: About TYFK posts (Test Your Foundation Knowledge) see the post insert below. “But if you still want to compare NOSQL databases wit...
Sunday, August 25, 2019

Meaning Criteria and Entity Supertype-Subtypes Relationships

›
Note: This is a re-write of a previous post. "I have a database for a school ... [with] numerous tables obviously, but consider th...
Friday, June 14, 2019

Normalization and Further Normalization Part 3: Understanding Database Design

›
Note: This is a re-write of two older posts, to bring them into line with McGoveran's formalization, re-interpretation, and extension[...
Saturday, March 2, 2019

Fourth Order Properties Part 1: Association Relations vs. Foreign Keys

›
  “We have Building, Room, and Bed entities. Logically, if this is in the scope of some hypothetical hotel, then each one of those entitie...
Sunday, November 26, 2017

What Relations Really Are and Why They Are Important

›
Note: Some of the References have been re-written to bring them into line with the McGoveran formalization and interpretation [1] of Codd...
Sunday, August 27, 2017

Object Orientation, Relational Database Design, Logical Validity and Semantic Correctness

›
Note: This is a 8/24/17 rewrite of a 5/20/13 post to bring it in line with McGoveran's formal exposition of Codd's RDM [1] and it...
2 comments:
Sunday, November 20, 2016

The Principle of Orthogonal Database Design Part III

›
Note: This is a 11/24/17 re-write of Part III of a three-part series that replaced several previous posts (the pages of which redirect her...
5 comments:
Monday, November 7, 2016

The Principle of Orthogonal Database Design Part II

›
Note: This is a 11/24/17 re-write of Part II of a three-part series that replaced several previous posts (the pages of which redirect here...
17 comments: