Showing posts with label CM. Show all posts
Showing posts with label CM. 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...
Tuesday, January 9, 2024

METALOGICAL PROPERTIES PART 1: Designation Property

›
 with David McGovern One purpose of our contributions here is to suggest a vocabulary that avoids confusion not just within the formal logic...
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...
Sunday, April 30, 2023

RELATIONSHIPS AND THE RDM V2 Part 3: SEMANTIC CONSTRAINTS

›
Note: This is a multipart re-write of a previous series that, when completed, is intended to replace it. In Part 1 we documented the diffe...
Sunday, April 16, 2023

RELATIONSHIPS & THE RDM V2 PART 2: INTRA-GROUP RELATIONSHIPS

›
  Note: This is a multi-part complete re-write of a previous series which, when completed, is intended to replace it. In Part 1 we attribu...
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, March 26, 2023

RELATIONSHIPS AND THE RDM V2 PART 1: RELATIONS & DATABASE RELATIONS

›
with David McGoveran   Note: This a multi-part re-write of a previous series intended, when completed, to replace it. In the meantime you ca...
Sunday, March 19, 2023

ON PROPERTIES IN CONCEPTUAL MODELING (rm)

›
Note: Reader mail (rm) posts are exchanges with my readers that raise fundamental issues. I may improve language for clarity and amplify wi...
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...
Sunday, January 22, 2023

CONCEPTUAL BUSINESS RULES AND LOGICAL CONSTRAINTS (sms)

›
Note: In "Setting Matters Straight" posts I debunk online pronouncements that involve fundamentals which I first post on Linked...
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...
Sunday, June 26, 2022

REPEATING GROUPS AND 1NF (t&n)

›
09/19/23: For the latest on this subject see : FIRST NORMAL FORM - A DEFINITIVE GUIDE   “A commonly used example of a table that is not i...
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...
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...
Sunday, March 6, 2022

RELATIONSHIPS: UNIQUENESS & ATTRIBUTE CONSTRAINTS (tyfk)

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