Showing posts with label IP. Show all posts
Showing posts with label IP. Show all posts
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...
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-...
Saturday, January 9, 2021

OBG: Missing Data -- Many-valued Logics and NULL Part 1

›
Note: To demonstrate the correctness and stability of a sound theoretical foundation relative to the industry's fad-driven "cookbo...
Thursday, May 28, 2020

No Such Thing As "Current Relational Data Models"

›
“... the concept of a state group is indeed a missing modeling concept in relational/current data models...” Thus in a LinkedIn exchange....
Tuesday, September 18, 2018

Don't Conflate/Confuse Primary Keys, PK Constraints, and Indexes

›
“What is the difference between an index and a key? How are they related?” “There seams to be some confusion between what a Primary Key ...
Wednesday, August 29, 2018

DISTINCT and ORDER BY Are Not Relational

›
“One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query ... most people quickly und...
Wednesday, August 15, 2018

Order Is For Society, Not Databases

›
8/18/18: I have re-written this post for a better explanation. If you read it prior to the revision, you should re-read it.   “I learned...
Sunday, June 17, 2018

Foreign Keys Part 2: Beware of Misconceptions

›
Note: This is the second part of a multipart re-write of several older posts to bring them into line with the McGoveran formalization and r...
Sunday, April 22, 2018

A New Understanding of Keys Part 2: Kinds of Keys

›
Note: This the second of three re-writes of older posts to bring them in line with McGoveran's formalization and interpretation[ 1 ] of...
8 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...
Sunday, February 19, 2017

Simple Domains and Value Atomicity

›
09/19/23: For the latest on this subject see : FIRST NORMAL FORM - A DEFINITIVE GUIDE   11/09/22: Revised Here's what's wrong wit...
3 comments:
Tuesday, January 31, 2017

Outsmarting the DBMS: Analysts Should Beware

›
Revised 5/4/2020. Last month I alerted you to the failure by data professionals to appreciate the importance, for a variety of critical...
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:
Saturday, September 3, 2016

Relation Predicates and Identical Relations

›
Note: This is a 11/25/17 re-write of an earlier post, to bring it in line with the McGoveral formalization and interpretation [1] of Codd...
16 comments:
Monday, July 25, 2016

Duplicates: Stating the Same Fact More Than Once Does Not Make it Truer, Only Redundant

›
Here's what what wrong with last week's picture, namely: RB: "From the tabular point of view, does it make sense why we can...
Tuesday, April 19, 2016

First Normal Form in Theory and Practice Part 3

›
09/19/23: For the latest on this subject see : FIRST NORMAL FORM - A DEFINITIVE GUIDE Note: This is a 11/23/17 revision of Part 3 of a t...
Tuesday, March 1, 2016

First Normal Form in Theory and Practice Part 1

›
09/19/23: For the latest on this subject see : FIRST NORMAL FORM - A DEFINITIVE GUIDE   Note: This is a 11/23/17 revision of Part 1 of a t...
Sunday, September 20, 2015

Re-Write

›
Understanding Codd's 12 Rules for RDBMS
Sunday, February 1, 2015

Re-write

›
See series starting at The First Normal Form in Theory and Practice Part I