Bad Data

Not me, actual DATA in databases.

Is it just me or is there a distinct lack of common sense within the software development community? I’m being requested to create a table that holds shipping data for a major retailer. For the shipment weight column, they want the datatype (the size of the data) to be a decimal of size 21,4 – which looks like this:

99999999999999999.9999

That field will hold a maximum of 99 QUADRILLION POUNDS. For one shipment. Can someone tell me what sort of truck, ship, plane or railroad car can hold 99 quadrillion lbs? THINK PEOPLE, THINK. This is GIBBERISH. You have BAD DATA. Do some research, find out where it came from and get rid of it. Don’t just let it propagate around the enterprise!

I recently had the same thing happen with an hourly rate for repair service. A size of 17,4 they wanted. So they think they will need to accommodate a repairman who’s going to charge someone $9,999,999,999,999.9999 (nine TRILLION dollars) PER HOUR for a repair. PER HOUR. Actually, I didn’t question that one, because honestly, repairs ARE expensive!

So in response to today’s NaBloPoMoPro, What do you hope people remember about you after you’re gone?, I would like people to remember that I had at least a BIT of common sense. It seems to be rare these days.

 

 

Featured image credit: http://www.zdnet.com

Advertisements

Go ahead, say it. Don't be shy...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s