Joe Celko in Theory and design VIEW Objects A view is a virtual table, created when it’s invoked by the < view name>. The goal we had in... 13 January 2025 7 min read
Joe Celko in Theory and design Data Control Language (aka Security) Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is... 12 November 2024 11 min read
Phil Factor in AI AI and Databases Although it is probably true to say that “AI is reshaping the landscape of database technology“, it’s also an over-simplification.... 01 November 2024 12 min read
Joe Celko in Theory and design Transactions By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required... 29 October 2024 10 min read
Joe Celko in Theory and design Rounding Numbers I would hope by now everybody has figured out when you see a price like $39.99 that it might as... 23 September 2024 12 min read
Joe Celko in Theory and design Uniqueness, Keys, and Identity If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as the founding principle... 09 September 2024 16 min read
Joe Celko in Theory and design Bad Data and Dirty Databases Many years ago, my wife and I wrote an article for Datamation, a major trade publication at the time, under... 28 August 2024 10 min read
Joe Celko in Theory and design LIKE Constraints In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of... 19 August 2024 10 min read
Theory and design Joe Celko in Theory and design The CHECK() Constraint One of the many ways a relational table differs from the file structures used by pre-relational storage systems is that... 20 May 2024 11 min read
Theory and design Joe Celko in Theory and design SQL Logic In this article, I will discuss the history and thinking behind several types of logic that are typically associated with... 29 March 2024 13 min read
Theory and design Joe Celko in Theory and design Department of Redundancy Department Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too... 18 March 2024 12 min read
Software Delivery Phil Factor in Software Delivery Database Feature Toggles In software development the concept of feature toggles are used to selectively turn on and off features. They are, for... 19 February 2024 15 min read
Theory and design Joe Celko in Theory and design First Normal Form Gets No Respect Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 No 6; June... 05 October 2023 13 min read
