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

Interfaces

By Steve Jones,

This editorial was originally published on April 23, 2009. It is being re-run as Steve is on vacation.

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

Total article views: 252 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Free As In Speech

The online world is full of content that is free, as in beer, but not free as in speech. Steve Jones...

FORUM

Computed Columns

Computed Columns

ARTICLE

Querying System Tables

It is not recommended, but there is quite a bit of valuable information stored in the SQL Server 200...

FORUM

Sport Lap time Input

Inputting sport times

ARTICLE

Trusting Systems

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

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