Note: The italicized titles are of my columns @All Analytics, a site which does no longer exist. The live links are to revised versions posted on this site.
- ▼ 2020
- ▼ December
- ▼ November
- ▼ October
- ▼ September
- ▼ August
- (TYFK) Denormalization Part 1 - Fundamentals
- (OBG) Data Sublanguage vs. SQL
- (TYFK) Relations, Tables, Domains and Normalization
- (OBG) Data Models and Physical Indep...
- ▼ July
- ▼ June
- ▼ May
- ▼ April
- ▼ March
- (TYFK) How (Not) to Compare NoSQL Systems and RDBMSs?
- Muddling Modeling Part 2: An Example
- Muddling Modeling Part 1: Fundamentals
- ▼ February
- ▼ January
- ▼ 2019
- ▼ December
- ▼ November
- (TYFK) 5NF, Association Relations, and Join
- The CAP Theorem and the RDM: Consistency, Availabi...
- Comments on a Stonebraker Article
- ▼ October
- Data Sublanguage Part 4: Conclusion
- Brother, Spare Me the "Paradigms"
- Testing Your Foundation Knowledge
- Data Sublanguage Part 3: DBMS Language
- Testing Your Foundation Knowledge
- ▼ September
- Data Sublanguage Part 2: Data Manipulation and Def...
- Testing Your Foundation Knowledge
- Data Sublanguage Part 1: Relational vs. Computatio...
- Testing Your Foundation Knowledge
- ▼ August
- ▼ June
- Data Meaning and Mining: Knowledge Representation ...
- Normalization and Further Normalization Part 3: Un...
- Normalization and Further Normalization Part 2: If...
- ▼ May
- Normalization and Further Normalization Part 1: Da...
- Reader Mail: Sets vs. Graphs, Education vs. Training
- Understanding Data Modeling Part 5: Conclusions
- Understanding Data Modeling Part 4: Fact Modeling
- ▼ April
- Understanding Data Modeling Part 3: OO/UML, and "G...
- Understanding Data Modeling Part 2: "E/RM" and "RDM"
- Understanding Data Modeling Part 1: Models, Models...
- ▼ March
- Graph Databases: They Who Forget the Past...
- Fourth Order Properties Part 2: Association Relati...
- Fourth Order Properties Part 1: Association Relati...
- ▼ February
- ▼ January
- ▼ 2018
- ▼ December
- ▼ November
- Data and Meaning Part 1: The RDM Is Applied Theory
- Conceptual Modeling Is Not Data Modeling
- Understanding Conceptual vs. Data Modeling Part 4:...
- ▼ October
- Understanding Conceptual vs. Data Modeling Part 3:...
- Understanding Conceptual vs. Data Modeling Parts 1-4
- ▼ September
- Understanding Conceptual vs.Data Modeling Part 2: ...
- Don't Conflate/Confuse Primary Keys, PK Constraint...
- Designation Property and Assertion Predicate
- ▼ August
- DISTINCT and ORDER BY Are Not Relational
- Order Is For Society, Not Databases
- No Such Thing As "Primary Key Tuning"
- ▼ July
- Lenin, Trotsky, Data Management, and the Tyranny o...
- Industry Practice Is No Substitute for Foundation ...
- Understanding Relations Part 3: Debunking Conventi...
- N-ary vs. Binary Relations: Anatomy of a Compound ...
- ▼ June
- Understanding Relations Part 2: Beware the Misconc...
- Understanding Relations Part 1: Tables? So What?
- Foreign Keys Part 2: Beware of Misconceptions
- Foreign Keys Part 1: Understanding the Fundamentals
- DBDebunk on Social Media
- Relationships and the RDM Part 3: Beware the Misco...
- ▼ May
- Relationships and the RDM Parts 1 and 2 Revised
- Relationships and the RDM Part 2: Integrity Constr...
- Relationships and the RDM Part 1: Kinds of Relatio...
- ▼ April
- A New Understanding of Keys Part 3: Surrogate Key ...
- A New Understanding of Keys Part 2: Kinds of Keys
- A New Understanding of Keys Part 1: Primary Key Fo...
- Name the Relational Violation Part 2: Self-defeati...
- ▼ March
- Name the Relational Violation Part 1: Conditional ...
- Data Modeling and NoSQL
- Physical Independence Part 2: Logical-physical Con...
- Physical Independence Part 1: Don't Mix Model with...
- ▼ February
- ▼ January
- ▼ 2017
- ▼ December
- DBMS for Analytics: Risky Business Without Foundat...
- Conventional Wisdom and True Relational Features
- DBMS for Analytics: Risky Business Without Foundat...
- ▼ November
- What Relations Really Are and Why They Are Important
- Understanding Conceptual vs. Data Modeling Part 1:...
- ▼ October
- The Importance of Understanding Classes, Sets, and...
- Database Design: What It Is and Isn't
- Understanding the Division of Labor between Analyt...
- ▼ September
- Database Management: No Progress Without Data Fund...
- Don't Confuse/Conflate Database Consistency with T...
- ▼ August
- Object Orientation, Relational Database Design, Lo...
- Relational Fidelity, Cursors and ORDER BY
- Structure, Integrity, Manipulation: How to Compare...
- ▼ July
- ▼ June
- Relations & Relationships Part I
- What Meaning Means: Business Rules, Predicates, In...
- Redundancy, Consistency, and Integrity: Derivable ...
- ▼ May
- ▼ April
- ▼ March
- ▼ February
- ▼ January
- ▼ 2016
- ▼ December
- On View Updating (C. J. Date and D. McGoveran)
- Prediction, Explanation and the November Surprise
- ▼ November
- The Principle of Orthogonal Database Design Part III
- The Principle of Orthogonal Database Design Part II
- ▼ October
- The Costly Illusion of Denormalization for Perform...
- THE DBDEBUNK GUIDE TO MISCONCEPTIONS ABOUT DATA FU...
- ▼ September
- ▼ July
- Data Science, Coding, the Automation Paradox, and ...
- Duplicates: Stating the Same Fact More Than Once D...
- Levels of Representation: Relationships, Rules, Re...
- NoSQL, Big Data Analytics, and the Loss of Knowled...
- ▼ June
- ▼ May
- Why Data Scientists Must Understand Normalization
- Weak Entities, Referential Constraints and the Con...
- ▼ April
- ▼ March
- Not Worth Repeating: Duplicates
- The Fourth V -- Veracity
- First Normal Form in Theory and Practice Part 1
- ▼ February
- ▼ January
- It’s Not Tables, It's the Relationships
- Conceptual (Business) Modeling, Logical Database D...
- The Real Data Science Series: 1NF In Theory & Prac...
- NoSQL and SQL: A Plague on Both Their Houses
- ▼ 2015
- ▼ December
- Re-interpreting Codd: LOGIC FOR SERIOUS DATABASE F...
- Documents and Databases
- Moving in Circles: RDBMS-SQL Conflation & Logical-...
- ▼ November
- ▼ October
- Mathematics & Meaning
- Database Education: Oughts and OughtNot's
- ▼ September
- The Real Data Science: Tables -- So What?
- ▼ August
- ▼ July
- The First Half of Database Science for Analysts
- The SQL and NoSQL Effects: Will They Ever Learn? U...
- ▼ June
- Database Fundamentals for Analysts
- The Cookbook Approach to Data Management
- Forward to the Past: Sounds Familiar?
- ▼ May
- R-table Constraints and Data Science
- On OO Relational "Extensions"
- ▼ April
- Comments on Stonebraker Interview
- Class Business Rules and Table Constraints
- David McGoveran Interview
- ▼ March
- ▼ February
- SQLSaturday Presentation
- Understand Class Business Rules
- The Conceptual-Logical Conflation and the Logical-...
- ▼ January
- Silicon Valley SQL Server UG Presentation
- Understand Property Rules & Domains
- ▼ 2014
- ▼ December
- Analytics & SQL Tables
- ▼ November
- SQL's Incomplete Set-lization, Part 2
- Relational Fidelity and Analytics Integrity
- ▼ October
- Precision, Procedurality and SQL, Part 1
- Tools Too Good to Be True
- ▼ August
- Data Analysts: Know Your Business Rules
- The 'Real World' and Database Design
- ▼ July
- Big Data & Analytics: Table Interpretations
- ▼ June
- Big Data, Normalization & Analytics: Meaning & Con...
- Denormalization: Database Bias, Integrity Tradeoff...
- Big Data, Normalization & Analytics
- ▼ May
- ▼ April
- David McGoveran: Comments on Jim Starkey...
- Forward to the Past: From Codd to SQL to NoSQL
- Analytics = Manipulation of Data Structure
- ▼ March
- Simplicity: Forgotten, Misunderstood, Underrated R...
- Science, Religion, EAV and the Relational Model
- ▼ February
- Anatomy of a Data Management Project: Distribution...
- Thinking Logically: SQL, NoSQL and the Relational ...
- "Denormalization for Performance": Don't Blame the...
- ▼ January
- Causality, Uncertainty & Actionability in Analytics
- Data Fundamentals and Education
- ▼ 2012
- ▼ December
- The Clouding Syndrome (REVISED)
- "Schema-less Models" and the New World Disorder
- Data Warehouses and the Logical-Physical Confusion
- ▼ October
- The Cloud and SQL
- Education, Practicality and an Introductory SQL Book
- To Laugh or Cry
- Quote of the Week
- To Laugh or Cry?
- Quote of the Week
- Data Fundamentals, Fads and "Big Data"
- To Laugh or Cry?
- Quote of the Week
- Normalization, Further Normalization, Ease of Use,...
- ▼ September
- A Note on Education vs. Training
- Mountain View Presentation
- Quote of the Week
- To Laugh or Cry?
- Davide and David on NoSQL
- Data Models and Usefulness
- Object Orientation, Logic and Database Management
- To Laugh or Cry?
- Quote of the Week
- Forward to the Past: "Out-clevering" the DBMS
- Quote of the Week
- To Laugh or Cry?
- Conceptual Business Modeling for Database Design: ...
- ▼ August
No comments:
Post a Comment