Tendata Relation RepairKit

Improve the data quality with reliable database cleansing tool

The need for high quality customer data is certainly applicable to the area of database management. Data reliability is one of the highest priorities for organizations and its availability significantly contributes to their success. The consequences of data pollution can be very serious causing companies to lose credibility and reputation in their field of business.

Feel free to download the pdf version:

Automated repair of relational data and deduplication

Tendata is an intelligent software tool that keeps databases in a good shape. With this solution, businesses can repair relational data such as names, addresses and email addresses as well as detect duplicate records in a database based on fuzzy search criteria.

Name normalization

This essential Tendata function accepts full name in any natural form and splits it in proper parts such as titles, first name(s), initials, last name prefixes, last name(s), maiden names and maiden name prefixes. Tendata takes care of capitalization and proper formatting of initials; in case no initials are present, the software is capable of deriving them from the first names. Tendata also detects company names.

Email and domain correction

This function ensures that the invalid email address characters are removed, the email syntax is validated and the actual existence of domain name is verified against a reference database. If the domain name is not found, Tendata performs fuzzy search in order to prevent misspellings. In case the fuzzy search matching score is high enough, Tendata replaces the non-existing domain name with the correct one from the reference database.

Address check and correction

The address check function accepts a full address. The frequent errors such as house numbers glued to the street name are resolved first. Next, the software tool checks the address against a reference database and is capable of resolving errors in multiple address parts. The output is a consistent and correctly formatted address.

Deduplication and matching

Deduplication is a batch process of identifying records in a relational database that are sufficiently equal to be considered the same. Depending on the similarity and the parameters set in the configuration file, records are deduplicated automatically or offered for manual correction. Matching is a real-time process that checks if a record is already present in a database.

Effective strategies for data validation and repair

The Tendata Relation RepairKit is a software product that runs on all computer systems and works well with a wide variety of databases. The tool can be integrated via several strategies to suit every client’s needs. Typically during the life of a project, the product examines the entire database in order to repair the relational information. When this process is finished, all data in the database is normalized and deduplicated leaving it in a good condition. In addition, the software tool can also be seamlessly integrated with a call center application to perform the data cleaning online on request. This type of integration strategy alows utilization of the Relation RepairKit cleaning functions before the new relational data enters the database. Finally, Tendata can also be integrated with business process modeling tools (e.g., Process Engine Suite) as a part of any marketing campaign or business process flow.

High quality data reduces costs and increases operational efficiency

Quality is an important attribute of all data and can help optimize records of customers, prospects, partners or vendors and increase operations effectiveness across any enterprise. This intelligent, well manageable and easy to be integrated software tool helps save substantial amount of time and money delivering high quality outputs.

With benefits such as communication targeting and elimination of duplicate mailings, the Tendata Relation RepairKit cuts unnecessary costs caused by utilization of corrupt or inaccurate relational data. Tendata serves as a reliable tool from both operational and reputational perspective.