The Herald Bulletin

Overnight Update

Columns

September 9, 2013

Emmett Dulaney: Databases that automate the errors

I recently conducted a bit of an experiment to determine the accuracy of databases we interact with every day. Before discussing it in more detail, however, it is important to explain the logic behind it.

Today, every packaged product sold in a store has a bar code and the cashier is really just a cog in the conveyor belt making sure each item goes across the scanner the right way before bagging. The database does all the work – identifying the product, the category, whether it is taxable or not, and so on – and this is a great thing on many levels. It helps with inventory control, it helps with pricing, and it is especially helpful with navigating through the convoluted sales tax status of items. I haven’t heard anyone complain about sales tax being incorrectly calculated for quite a while even though the laws regarding it are so complex.

For example, the Indiana Department of Revenue published Information Bulletin #29 and made it effective Feb. 1, 2012. This document specifically spells out what is taxable and nontaxable as it relates to food and even goes so far as to name a number of individual products in one category or another. The category “Candy and confections,” for example, are listed as taxable items but “Nestle Crunch bars” are explicitly listed as “Non-taxable Food Items” (I guess that they can pass for a tasty breakfast just like mother would make). By having a database for a point-of-sale (POS) register, the merchant need only have identified Crunch bars as non-taxable within the last 18 months, but left Hershey bars and Bit-O-Honeys as taxable, and let the cashiers take the money identified as the total at the end of the transaction without question.

From the standpoint of a consumer, an awful lot of blind faith is put in those databases and this brings me to my experiment. Over a seven-day period, I bought a fair number of Nestle Crunch bars and checked to see if I was charged sales tax. The result is that I was not charged sales tax at four Anderson stores. I was, however, incorrectly charged sales tax at three others. An accuracy rate below 60 percent certainly delivered a blow to my trust in the system.

Text Only
Columns
  • Clark, Big Joe mug [Duplicate] 'Big Joe' Clark: Plan your strategy for financing higher education Planning is essential regardless of the situation, but no plan is perfect. There will be flat tires and snow days, but there will also be dances and great memories. Let’s plan for what we can even if we know it won’t be perfect.

    August 1, 2014 1 Photo

  • Davis, Verna mug Verna Davis: Peace is worth fighting for Some people say they know how to find peace. We should “simply” follow our hearts, search for meaning in our lives, and fulfill our dreams. Sad to say, those things may bring us a bit of satisfaction, but they certainly don’t bring us peace.

    August 1, 2014 1 Photo

  • Jim Bailey: Gospel singer’s long road to recovery has begun Eighteen months ago, gospel singer and The Perrys manager Tracy Stuffle found himself wrecked by the side of the road, where he struggled to summon help on his cell phone. He had suffered a severe stroke while driving.

    July 30, 2014

  • OPN - Mootry column mug [Duplicate] [Duplicate] Primus Mootry: The African-American community toward a new narrative African Americans are entirely unique in the annals of American history and, perhaps, the whole history of mankind. This uniqueness demands an African American agenda and, with it, a new narrative, or way of articulating that agenda.

    July 29, 2014 1 Photo

  • underwood mug [Duplicate] [Duplicate] Scott Underwood: Headlines can capture imagination I'd just left the newspaper office one morning and was driving north on Jackson Street, when I stopped at a red light and glanced at the rearview mirror.

    July 28, 2014 1 Photo

  • Charo Boyd: 'My Social Security' simplifies your life So many people buzz through extremely busy and complicated schedules these days. A smartphone in one hand, a computer in front of you, and a digital task list that never seems to end. In addition, to complicate things just a little more, there’s another event you need to add to your list — National Simplify Your Life week.

    July 28, 2014

  • Maureen Hayden: 9/11 Commission chair scolds Congress for national security failures Retired Congressman Lee Hamilton has warned of the perils of political ideology, calling the body where he spent 34 years “noxiously partisan.” Now, he worries the divide is downright dangerous.

    July 27, 2014

  • Vaughan, Nancy mug [Duplicate] Nancy Vaughan: Fireworks and fireflies mean summer in full swing Hasn't July been a fabulous month? It began with multiple fireworks venues and parades and ends with fairs and football in full swing. We have been blessed with mild weather and if you haven't had to travel much outside of the county, roadwork has been minimal.

    July 26, 2014 1 Photo

  • Ken de la Bastide: City unions go without contracts for many years How Anderson deals with unions has changed dramatically over the years. In the past it would have been unheard of for union members to continue to work without a contract or an agreed upon deadline. But members of three unions that represent Anderson city employees have been working without a new contract agreement for up to seven years.

    July 26, 2014

  • Jim Bailey: Traveling by passenger train was a page from the past My wife doesn’t remember riding on a full-fledged passenger train as a baby. Our children have never ridden. It’s an experience rapidly going the way of the horse and buggy and the stagecoach throughout a nation now obsessed with jumbo jets and sport-utility vehicles.

    July 26, 2014

Featured Ads
More Resources from The Herald Bulletin
AP Video
Renewed Violence Taking Toll on Gaza Residents 2 Americans Detained in North Korea Seek Help US Employers Add 209K Jobs, Rate 6.2 Pct House GOP Optimistic About New Border Bill Gaza Truce Unravels; Israel, Hamas Trade Blame Raw: Tunisia Closes Borders With Libya Four Rescued From Crashed Plane Couple Channel Grief Into Soldiers' Retreat WWI Aviation Still Alive at Aerodrome in NY Raw: Rescuers at Taiwan Explosion Scene Raw: Woman Who Faced Death Over Faith in N.H. Clinton Before 9-11: Could Have Killed Bin Laden Netanyahu Vows to Destroy Hamas Tunnels Obama Slams Republicans Over Lawsuit House Leaders Trade Blame for Inaction
Parade
Magazine

Click HERE to read all your Parade favorites including Hollywood Wire, Celebrity interviews and photo galleries, Food recipes and cooking tips, Games and lots more.
Hyperlocal Search
Premier Guide
Find a business

Walking Fingers
Maps, Menus, Store hours, Coupons, and more...
Premier Guide
Helium debate
Helium
Front page
Poll

How many Dan Patch races have you attended?

None
1-2
3 or more
All 20
     View Results