Register Log in

Rounding Numbers

Articles tagged Database Theory

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 well be forty bucks. Dropping...

12 min read
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 of all Western thought. It...

16 min read
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 the title, “Don’t Warehouse Dirty...

10 min read
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 history about why it is...

10 min read
Theory and design
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 the tables, rows and columns...

11 min read
Theory and design
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 writing relational database code. Because...

13 min read
Theory and design
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 much anymore, the first reason...

12 min read
Software Delivery
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 example, used to restrict some...

15 min read
Theory and design
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 1970). Some more work followed...

13 min read