Thursday, July 16, 2009

Fun with databases: How cereals turn into silverware

This morning my wife came back from grocery shopping. Among other things, she brought back a new organic cereal mix that just had started to hit the shelves. My wife was happy because she got it for free - more or less.

While paying at the cash register, my wife checked the receipt because the amount seemed to be higher than expected. Then she noticed an item on the list that wasn't in her cart: A 24 piece silverware set. What was in her cart, but not on the receipt was the new cereal mix. After some phone calls by the store clerk to the supervisor they together found out that both the silverware and cereals were in the product database, but somehow the system mixed it up. Was the barcode on the product incorrect? Were both products listed with the same barcode? Was it a database inconsistency or a system glitch?

My wife got the cereals for free as token of appreciation for waiting and the trouble and left some puzzled store employees behind.

Did you run into similar situations? Any ideas how this could have happened?

3 comments:

  1. "Finally, from Henrik Loeser, here’s some fun with databases, which I hope will inspire you to practice your craft with care [...]"

    Log Buffer #154

    ReplyDelete
  2. This is such a good post demonstrating that even things we take for granted should not be taken for granted... thanks, I loved it.. even posted back to you from my blog.

    ReplyDelete
  3. We often see DB errors both as conssumers, and from the IT side.

    A major food chain has special prices for its identity card members, plus sale ad prices, in store sale prices and the regular price. The law in IL says the lowest advertised price is the price. 20% of the prices in the database seem to not be the lowest price for sale items. But the database gives another 20% of items a sale price when they are not on sale. It more of a problem with the identity card sale prices than with the manually entered in-store sale prices.

    And you wonder why it went thru bankruptcy a couple years ago ... and why places like Walmart that don't have identity cards are grabbing market share.

    ReplyDelete

Your thoughts and feedback are highly appreciated. Please note that comments are moderated and they will not appear immediately.

LinkWithin

Related Posts with Thumbnails