Note: The italicized titles are of my columns @All Analytics, a site which does no longer exist. The links are to short summaries that I posted on this site.
- ▼ 2020 (29)
- ▼ December
- ▼ November (2)
- Oldies But Goodies: Missing Data - "Horizontal Dec...
- Oldies But Goodies: Missing Data - "Horizontal Dec...
- ▼ October (2)
- ▼ September (2)
- ▼ August (4)
- TYFK: Denormalization Part 1 - Fundamentals
- Oldies But Goodies: Data Sublanguage vs. SQL
- TYFK: Relations, Tables, Domains and Normalization
- Oldies But Goodies: Data Models and Physical Indep...
- ▼ July (2)
- Oldies But Goodies: Data Independence and "Physica...
- Oldies But Goodies: Skyscrapers with Shack Foundat...
- ▼ June (2)
- ▼ May (2)
- ▼ April (1)
- ▼ March (3)
- TYFK: How (Not) to Compare NoSQL Systems and RDBMSs?
- Muddling Modeling Part 2: An Example
- Muddling Modeling Part 1: Fundamentals
- ▼ February (2)
- ▼ January (5)
- ▼ 2019 (34)
- ▼ December (2)
- ▼ November (3)
- 5NF, Association Relations, and Join: Test Your Fo...
- The CAP Theorem and the RDM: Consistency, Availabi...
- Comments on a Stonebraker Article
- ▼ October (5)
- Data Sublanguage Part 4: Conclusion
- Brother, Spare Me the "Paradigms"
- Test Your Foundation Knowledge
- Data Sublanguage Part 3: DBMS Language
- Test Your Foundation Knowledge
- ▼ September (4)
- Data Sublanguage Part 2: Data Manipulation and Def...
- Test Your Foundation Knowledge
- Data Sublanguage Part 1: Relational vs. Computatio...
- Test Your Foundation Knowledge
- ▼ August (1)
- ▼ June (4)
- Properties-object Modeling (re-write)
- Data Meaning and Mining: Knowledge Representation ...
- Normalization and Further Normalization Part 3: Un...
- Normalization and Further Normalization Part 2: If...
- ▼ May (4)
- 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 (3)
- 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 (3)
- Graph Databases: They Who Forget the Past...
- Fourth Order Properties Part 2: Association Relati...
- Fourth Order Properties Part 1: Association Relati...
- ▼ February (2)
- ▼ January (3)
- ▼ 2018 (41)
- ▼ December (2)
- ▼ November (3)
- Data and Meaning Part 1: The RDM Is Applied Theory
- Conceptual Modeling Is Not Data Modeling
- Understanding Conceptual vs. Data Modeling Part 4:...
- ▼ October (2)
- Understanding Conceptual vs. Data Modeling Part 3:...
- Understanding Conceptual vs. Data Modeling Parts 1-4
- ▼ September (3)
- Understanding Conceptual vs.Data Modeling Part 2: ...
- Don't Conflate/Confuse Primary Keys, PK Constraint...
- Designation Property and Assertion Predicate
- ▼ August (3)
- DISTINCT and ORDER BY Are Not Relational
- Order Is For Society, Not Databases
- No Such Thing As "Primary Key Tuning"
- ▼ July (4)
- 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 (6)
- 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 (4)
- 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 (4)
- 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 (4)
- 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 (3)
- ▼ January (3)
- ▼ 2017 (57)
- ▼ December (6)
- DBMS for Analytics: Risky Business Without Foundat...
- Three Re-writes with Season's Greetings
- Conventional Wisdom and True Relational Features
- DBMS for Analytics: Risky Business Without Foundat...
- ▼ November (4)
- What Relations Really Are and Why They Are Important
- Understanding Conceptual vs. Data Modeling Part 1:...
- ▼ October (6)
- The Importance of Understanding Classes, Sets, and...
- Database Design: What It Is and Isn't
- Understanding the Division of Labor between Analyt...
- Class, Type, Relation and Domain in Database Manag...
- ▼ September (4)
- Database Management: No Progress Without Data Fund...
- Don't Confuse/Conflate Database Consistency with T...
- ▼ August (5)
- Object Orientation, Relational Database Design, Lo...
- Relational Fidelity, Cursors and ORDER BY
- Structure, Integrity, Manipulation: How to Compare...
- ▼ July (5)
- Integrity Is Not Only Referential: DBMS vs Applica...
- New Paper: Logical Symmetric Access, Data Sub-lang...
- ▼ June (5)
- Data Meaning: Analytics vs. Data Mining
- Relations & Relationships Part I
- What Meaning Means: Business Rules, Predicates, In...
- Redundancy, Consistency, and Integrity: Derivable ...
- ▼ May (4)
- To Really Understand Integrity, Don't Start with SQL
- This Week Special: The US Sinking Deeper Into the ...
- ▼ April (4)
- ▼ March (4)
- New Paper: The Interpretation and Representation o...
- What Is a True Relational System (and What It Is Not)
- The Trouble with Data Warehouse Analytics
- ▼ February (4)
- ▼ January (6)
- ▼ 2016 (55)
- ▼ December (6)
- ▼ November (4)
- The Principle of Orthogonal Database Design Part III
- The Principle of Orthogonal Database Design Part II
- ▼ October (4)
- The Costly Illusion of Denormalization for Perform...
- THE DBDEBUNK GUIDE TO MISCONCEPTIONS ABOUT DATA FU...
- ▼ September (5)
- ▼ August (3)
- ▼ July (6)
- 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 (3)
- ▼ May (5)
- Why Data Scientists Must Understand Normalization
- Weak Entities, Referential Constraints and the Con...
- ▼ April (5)
- Data Fundamentals for Analysts: Nested Facts and t...
- First Normal Form in Theory and Practice Part 3
- First Normal Form in Theory and Practice Part 2
- ▼ March (5)
- Not Worth Repeating: Duplicates
- The Fourth V -- Veracity
- First Normal Form in Theory and Practice Part 1
- ▼ February (3)
- ▼ January (6)
- ▼ 2015 (62)
- ▼ December (5)
- Re-interpreting Codd: LOGIC FOR SERIOUS DATABASE F...
- Documents and Databases
- Moving in Circles: RDBMS-SQL Conflation & Logical-...
- ▼ November (5)
- ▼ October (5)
- ▼ September (5)
- The Real Data Science: Tables -- So What?
- ▼ August (5)
- ▼ July (4)
- The First Half of Database Science for Analysts
- The SQL and NoSQL Effects: Will They Ever Learn? U...
- ▼ June (4)
- Database Fundamentals for Analysts
- The Cookbook Approach to Data Management
- Forward to the Past: Sounds Familiar?
- ▼ May (6)
- R-table Constraints and Data Science
- New Versions of All 6 Papers
- On OO Relational "Extensions"
- ▼ April (5)
- Comments on Stonebraker Interview
- Class Business Rules and Table Constraints
- David McGoveran Interview
- ▼ March (6)
- ▼ February (7)
- SQLSaturday Presentation
- Understand Class Business Rules
- The Conceptual-Logical Conflation and the Logical-...
- ▼ January (5)
- Silicon Valley SQL Server UG Presentation
- Understand Property Rules & Domains
- New Version and Revision of Papers
- ▼ 2014 (52)
- ▼ December (3)
- Analytics & SQL Tables
- ▼ November (5)
- SQL's Incomplete Set-lization, Part 2
- Relational Fidelity and Analytics Integrity
- ▼ October (4)
- Precision, Procedurality and SQL, Part 1
- Tools Too Good to Be True
- ▼ September (4)
- ▼ August (5)
- Data Analysts: Know Your Business Rules
- NEW: Paper revisions available
- The 'Real World' and Database Design
- ▼ July (3)
- Big Data & Analytics: Table Interpretations
- Weekly Update UPDATED
- ▼ June (6)
- Big Data, Normalization & Analytics: Meaning & Con...
- Denormalization: Database Bias, Integrity Tradeoff...
- Big Data, Normalization & Analytics
- ▼ May (3)
- ▼ April (5)
- UPDATE 2: David McGoveran: Comments on Jim Starkey...
- Forward to the Past: From Codd to SQL to NoSQL
- Analytics = Manipulation of Data Structure
- ▼ March (4)
- Simplicity: Forgotten, Misunderstood, Underrated R...
- Science, Religion, EAV and the Relational Model
- ▼ February (5)
- Anatomy of a Data Management Project: Distribution...
- Thinking Logically: SQL, NoSQL and the Relational ...
- "Denormalization for Performance": Don't Blame the...
- ▼ January (5)
- Causality, Uncertainty & Actionability in Analytics
- New: Paper #4 Published
- Data Fundamentals and Education
- ▼ 2013 (70)
- ▼ 2012 (68)
- ▼ December (7)
- The Clouding Syndrome (REVISED)
- "Schema-less Models" and the New World Disorder
- Data Warehouses and the Logical-Physical Confusion
- ▼ November (8)
- Databases Representing ... What?
- Don't Mix Model with Implementation
- DBMS- vs. Application-Enforced Integrity
- I have rewritten this post: On Kinds of Keys: Natu...
- ▼ October (15)
- 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 (15)
- A Note on Education vs. Training
- Mountain View Presentation
- Quote of the Week
- To Laugh or Cry?
- Davide and David on NoSQL
- PRACTICAL DATABASE FOUNDATIONS PAPER #1: BUSINESS ...
- 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 (19)
No comments:
Post a Comment