Note: "Setting Matters Straight" is a new format: I post on LinkedIn an online Q&A involving data fundamentals that I subse...

Note: "Setting Matters Straight" (SMS) is a new format: I post on LinkedIn an online Q&A involving data fundamentals that I...

 with David McGoveran  (Title inspired by Richard Feynman) In Part 1 we explained that all database relations are, mathematically, relation...

 with David McGoveran  (Title inspired by Richard Feynman) “As currently defined, relational algebra produces anomalies when applied to non-...

Note: Each "Test Your Foundation Knowledge" post presents one or more misconceptions about data fundamentals. To test your knowle...

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...

Note: I am re-publishing some of the articles and reader exchanges from the old DBDebunk (2000-06). How well do they hold up -- have indus...

Note: About TYFK posts (Test Your Foundation Knowledge) see the post insert below. “But if you still want to compare NOSQL databases wit...

“3rd normal form data models in data warehousing efforts struggle when changes impact parent child relationships. These impacts cause cas...

In Part 1 we outlined some fundamentals of database design, namely the distinction between normalization to 1NF, and further normalizatio...

Note: This is a re-write of older posts (which now link here), to bring them into line with the McGoveran formalization, re-interpretation...

In Part 1 we presented some foundation knowledge with which to debunk misconceptions lurking in the industry's modeling mess that Frie...

As we have seen in Parts 1 , 2 , and 3 , the RDM is a formal theory adapted and applied to database management: database relations (1) prese...

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...

Note: This is the first part of a two-part re-write of several earlier posts, to bring them into line with McGoveran's formalization an...

Note: Some of the References have been re-written to bring them into line with the McGoveran formalization and interpretation [1] of Codd...

Revised 10/31/17. Note: Posts starting with this one will be consistent with the TERMINOLOGY page. Fundamental terms -- the grasp of whic...

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...

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

The IT industry operates like the fashion industry: every few years -- and the number keeps getting smaller -- a "new" data techn...