Thursday, November 25, 2021

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

›
(Title inspired by Richard Feynman) In Parts 1 and 2 we provided some clarifications following a discussion on LinkedIn about our contenti...
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...
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...
Friday, November 5, 2021

OBG: Database Consistency and Physical Truth

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

Relational and Referential Integrity

›
“Relational Data Integrity is like every other integrity constraint that checks that the relationships created between data using foreign ke...
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...