Definition

record standardization

In data management, record standardization is a process in which files are first parsed (assigned to appropriate fields in a database record) and then translated to a common format. For example, if an original record had the customer's name and address as "Bob Jones, VP Acme. Co., 15 S. Main St, Brooklyn" the standardized record might read "Bob Jones, Vice President, Acme Corporation, 15 South Main Street, Brooklyn, New York". Data in a database or data warehouse often lacks consistency simply because there are a lot of ways to say the same thing. Standardizing the record ensures that when a query is run for a particular field, accurate results will be returned.

There are many vendor products available to assist in record standardization. They work by comparing data in a particular field to a look-up library and can be configured either to suggest a change to the record (much like spell-check in Microsoft Word) or automatically make the change as the data is parsed. Most record standardization products allow the customer to tailor the look-up library to the customer's own needs.

This was last updated in September 2005
Posted by: Margaret Rouse

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

More News and Tutorials

  • Database index design and optimization: Some guidelines

    What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.

  • Download SQL Server Insider

    SQL Server Insider e-zine is a quarterly online publication focusing on Microsoft’s enterprise database, SQL Server. Join the editors of SearchSQLServer.com for an in-depth look into the database trends sweeping over Microsoft, including business intelligence, cloud computing and “big data.”

  • SQL Server's Data Quality Services makes cleanup a cinch

    SQL Server Data Quality Services is Microsoft’s newest data-cleansing tool. Expert Denny Cherry examines the upcoming SQL Server 2012 feature and delves into its components and processes.

Do you have something to add to this definition? Let us know.

Send your comments to techterms@whatis.com

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: