Showing posts with label PORP. Show all posts
Showing posts with label PORP. Show all posts
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...
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...
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, 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...
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[...
Sunday, June 2, 2019

Normalization and Further Normalization Part 2: If You Need Them, You're Doing It Wrong

›
In Part 1 we outlined some fundamentals of database design, namely the distinction between normalization to 1NF, and further normalizatio...
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, October 29, 2017

Database Design: What It Is and Isn't

›
Revised 10/31/17. Note: Posts starting with this one will be consistent with the TERMINOLOGY page. Fundamental terms -- the grasp of whic...
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, August 13, 2017

Relational Fidelity, Cursors and ORDER BY

›
Here's what's wrong with last database picture, namely: "In a book I am reading (QUERYING SQL SERVER 2012) the author talks a...
Saturday, March 11, 2017

What Is a True Relational System (and What It Is Not)

›
(This is a rewrite of a 12/10/16 post , to bring it in line with McGoveran's interpretation of Codd's RDM.) Here's what's...
1 comment:
Monday, September 19, 2016

The Principle of Orthogonal Database Design Part I

›
Note: This is a 11/24/17 re-write of Part I of a three-part series that replaced several older posts (the pages of which which now redirec...
15 comments:
Monday, May 20, 2013

Re-write

›
See  Object Orientation, Relational Database Design, Logical Validity and Semantic Correctness .
1 comment: