Free Newsletters:
DatabaseJournal  
DBANews
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL PHP SQL Etc SQL Scripts & Samples Links Database Forum DBA Videos
internet.com

» Database Journal Home
» Database News
» DBA Videos
» Database Articles
» Database Tutorials
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs


internet.commerce
Partner With Us














internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

Database Journal | DBA Support | SQLCourse | SQLCourse2 | Swynk



Database Tools

Data Access/Reporting | Development | Management | Performance | Servers/Software
Submit Products *

DataQualityTools / DeduplicationWizard

Tools To Improve Data Quality, Esp. Remove Duplicates

DataQualityApps produces separately available tools that assist DB personnel in the cleansing of their data; especially in the removal of duplicate entries in address tables. Among their current offerings:

- The DeduplicationWizard is a program for the deduplication of address tables. Deduplication can be done using the telephone number, the E-mail address and the postal address. When the deduplication is based on the postal address--i.e. name, street, postal code and city--the program then also considers typos, inverted words and additions. It is then a fuzzy / error-tolerant deduplication. And with the deduplication between two files, black lists can also be considered.

Features and capabilities include: Largely automated; Standard Edition includes support deduplication between two files; results of the comparison can be transformed so that the duplicate records are deleted directly in the source file, or can be saved in the form of a results or an archive file; deletion log can be used to print the results of the comparison or save them as a PDF file.

The vendor notes that not all functions described above are available in the Entry Edition (USD 149).

- DataQualityTools is a collection of tools to help businesses improve the quality of their databases. The central components are a series of functions that help to find duplicate records and, a function for error-tolerant doublet search based on postal addresses.

Features and capabilities include: Largely automated; postal address (error-tolerant matching), telephone number, E-mail address, address or customer number and tax number can all serve as matching criteria; option to compare with blacklists and the enhancement of an address database using the comparison results with data from a second address database; user-defined universal matching, that the vendor states can be used for any form of data; options for the further processing of the matching results, including direct deletion in the source file, flag results in source file, process further using a stored procedure, or duplicate-, results-, or archive-file; project history; various functions for the preparation of address- and other databases, such as case correction, a function to replace terms, and a function to delete individual records systematically; more.

The vendor notes that not all functions described above are available in the Professional Edition, which has pricing starting at $498.

product submission by Company Rep

E-Mail this page to a colleague
send info about DataQualityTools / DeduplicationWizard

Suggest a link
for the DataQualityTools / DeduplicationWizard fact sheet

fact sheet
DPW id#: 1231939263
date posted: Jan. 14, 2009
category: Database Tools:Management
platform: Windows 2000/XP/2003/Vista
vendor: Thomas Hainke Dipl. Inform. Univ. (en)
(www.DataQualityApps.com/)


Database Tools

Data Access/Reporting | Development | Management | Performance | Servers/Software
Submit Products *

Latest category updates via our RSS feed
RSS



The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers