Showing posts with label RA. Show all posts
Showing posts with label RA. Show all posts
Sunday, May 28, 2023

INTENSION, EXTENSION AND R-TABLES (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...
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...
Thursday, August 4, 2022

DATABASE RELATIONS, TABLES AND SEMANTIC CONSISTENCY

›
by David McGoveran with Fabian Pascal   Note: In "Setting Matters Straight" posts I debunk online Q&As that involve fundament...
Wednesday, July 13, 2022

MISSING DATA AND MULTI-RELATION QUERY RESULTS (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...
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 "...
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...
Monday, April 25, 2022

RELATIONAL DATABASES & SET THEORY (sms)

›
Note: "Setting Matters Straight" is a new format: I post on LinkedIn an online Q&A involving data fundamentals that I subse...
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, January 30, 2022

NOBODY UNDERSTANDS WHAT A DATA MODEL IS (tyfk)

›
 “A data model is a collection of concepts ... used to describe the structure of a database...data types, relationships and constraints...is...
Friday, December 17, 2021

NO UNDERSTANDING WITHOUT FOUNDATION KNOWLEDGE PART 2: DEBUNKING A BOOK REVIEW (obg)

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