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...
Saturday, September 11, 2021

OBG: Data Warehouses Are Non-Relational Application Views

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

OBG: The Myth of Market-Based Education

›
(Originally posted on 09/08/2001, slightly revised) Note: To demonstrate the correctness and stability due to a sound theoretical foundatio...