I am working on entirely new papers (not re-writes) in the PRACTICAL DATABASE FOUNDATIONS series. I have already published two: THE FIRST NO...

  Per Part 1 , meaning is captured during conceptual modeling as information about objects of interest, specifically their properties (some...

“The term data model is used in two distinct but closely related senses. Sometimes it refers to an abstract formalization of the objects a...

“Ok, now that we have those two (Parts 3 and 4 of your series) 'on the table' so to speak, perhaps you would address these question...

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

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

“A short time ago a colleague asked me where he could find a "Databases 101" guide for the non-technical professional. As it tur...

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

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

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

Revised 3/25/18 "To the question “How relevant is data modeling in the world of NoSQL?” I give the following answer. The main pur...

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

Note: This was originally posted at AllAnalytics, which no longer exists, so some links to other posts there no longer work, but I left ...

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

Re-write 10/16/18 “E/RM is a data model -- So says Date, Chen, etc. So says the majority of current industry experts ... With very stron...

One of the clearest indications of poor foundation knowledge in data management practice is misuse and abuse of terminology. Many data pro...

I am coming across, on the one hand, instructions on how to do "analytics with SQL " and, on the other, tools purporting to enable...

I have recently -- yet again -- been accused in a LinkedIn exchange   of "gibberish without any evidence" and of claiming that ...

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

Note: This is a 10/23/17 rewrite of a 7/29/12 post to bring it in line with the McGoveran interpretation [1] of Codd's true RDM. To ...