human error

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
phpdevuk
Forum Contributor
Posts: 220
Joined: Mon Jul 04, 2005 5:31 am
Location: UK
Contact:

human error

Post by phpdevuk »

i got asked to deal with human error when it comes to a database of 1000s of numeric ids, my solution was to transfer numbers to words and soundex them, which works really well for finding similar numbers, as it happened i didn';t nered to use it but still was supprised by soundedx ability to spot similar numbers
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Is this a question, blog, or line of discussion?

If the latter, please elaborate.
Arawn
Forum Commoner
Posts: 42
Joined: Sat May 05, 2007 6:03 am

Post by Arawn »

feyd wrote:Is this a question, blog, or line of discussion?
I bet he's campaigning for "Most Peculiar" member of the year. :wink:
my solution was to transfer numbers to words and soundex them, which works really well for finding similar numbers
That's rather a unique solution though. But ... what solution did you use finally?
User avatar
phpdevuk
Forum Contributor
Posts: 220
Joined: Mon Jul 04, 2005 5:31 am
Location: UK
Contact:

Post by phpdevuk »

I just liked the idea of using soundex to find similar numbers, ultimately it never got used as it wouldn't be needed, so i never got off the playing around generating codes bit. Thought i'd post it to discuss the issue of dealing with human input error as its quite hard to suggest close alternatives when any part of a four digit number or more can be wrong. Using soundex would prove to be too hard i reckon and is just one of my more creative ideas, lol converting the numbers into words at the mysql stage would be awkward. Anyone got any thoughts, other than what is this madman dribbling about :)
User avatar
superdezign
DevNet Master
Posts: 4135
Joined: Sat Jan 20, 2007 11:06 pm

Post by superdezign »

Well... A good amount of human error on computers consists of typos rather than completely getting a number wrong... I'm not sure what the logic is behind the input, but you could assume that no one number is more than one away from the value it was meant to be.

Of course, that's assuming they don't use the number pad. :?
User avatar
phpdevuk
Forum Contributor
Posts: 220
Joined: Mon Jul 04, 2005 5:31 am
Location: UK
Contact:

Post by phpdevuk »

yeah i did think of just generating say ten numbers either side. But my problem was that the correct number might be say 4111 and the user might have input 4121 or 4112 (bad example I know but hopefully you get the idea). The soundex codes for numbers like that are all very similar, which is why it jumped at me as something to try.
I blame the cold i had last week :)
Post Reply