Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Interfaces

By Steve Jones, 2009/04/23

Data quality is an issue in many of our systems that rely on humans for data entry. Even if you only import data from other sources, how reliable is the data that exists in those systems?

I found an interesting article on computer interfaces and it highlights some of the ways that have been designed to work with computers and put data into, as well as get data out of, computer systems. Most of these are probably familiar to you and there's nothing really groundbreaking in the article.

It had me thinking, however, of whether or not there's a better way to input and extract data from systems. I've been watching Star Trek: The Next Generation on DVD lately, and they primarily use voice recognition, but I see all kinds of flaws in that. My wife has worked with a lot of speech technology, and her current company makes the Dragon speech recognition software. I asked her if she thought it was good. She did, but it paled when compared to a good, old-fashioned keyboard. The rate of input and the few mistakes she makes typing far outweigh the benefits of using speech. Perhaps that will improve in the future, but I wonder if it will ever really supplant the keyboard.

Multi-touch has gained a lot of notoriety lately, especially in presentations, but I'm not sure it's a great way to get data out of a system for a single user. There are other possibilities, but in anything we develop, the rate of input as well as mistakes, are things on my mind. As a data guy, I am entirely too aware of how much work it is to clean data later.

Managing, storing, and securing data all is great, and you can do the best job in the world, but if users can't easily access and use the data, is it valuable? If it's not correct, is it useful? The way we work with computers will likely evolve, and while I'm not sure what will work best, I do know that us DBAs will always be in demand to ensure the data is as correct as it can be.

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 112 | Views in the last 30 days: 1
 
Related Articles
BLOG

Podcasting

A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...

ARTICLE

Podcast Announcements

Podcast Feeds

ARTICLE

Trusting Systems

The trust we build by ensuring our computer systems work is important. If we can't maintain that tru...

FORUM

Podcast Problem

Podcast Problem Blocked by group policy

BLOG

Podcast Upgrades

A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a b...

Tags
data quality    
editorial    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones