LinkageWiz - Data matching, deduplication & data cleansing

  LinkageWiz Data Matching Software

Home
Features
Applications
Clients
Specifications
Services
Free Trial
FAQ
Purchase
Publications
Contact Us

Specifications

 

LinkageWiz Specifications

System Requirements

Data Requirements

Languages

Performance

 


LinkageWiz Specifications

Maximum number of records
per table (data matching):

Approximately 4-5 million records (Enterprise version required).

Maximum number of records
per table (duplicate analysis):
Approximately 3-4 million records (Enterprise version required).
Maximum Database Size: 2 Gigabytes.

 


System Requirements

Minimum:

Pentium PC with 64 Mb of RAM.

Recommended:

Pentium III with at least 128Mb RAM or higher.

Operating System:

Windows 2000, XP, 2003 Server, Vista

 


Data Requirements

One or more data files containing several patient identification fields. These can be configured in the Linkage Variables Definition screen. Supported file formats include text (fixed and delimited), MS Excel, MS Access, FoxPro and DBASE.


Languages

LinkageWiz is available in English and French language versions. Names from non-English speaking countries (e.g. Eastern Europe, the Middle East, Asia) will be processed correctly if they have been stored using the roman character set (e.g. A-Z).

Requests for other languages will be considered upon application.


Performance

The following times were recorded using a Pentium 4 1.6GHz PC with 256Mb of RAM. Phonetic family name and date of birth were used as blocking variables (except where otherwise stated).

Deduplication

Number of Records in Table Elapsed Time Number of Record Comparisons
10,000 30 seconds 20,000
100,000 4 minutes 2 million
250,000 15 minutes 13 million
500,000 45 minutes 50 million
1,000,000 4.5 hours 180 million

Data Matching

Number of Records in 1st Table Number of Records in 2nd Table Elapsed Time  Number of Record Comparisons
1,000 10,000 10 seconds 3,000
1,000 100,000 15 seconds 20,000
1,000 1,000,000 7 minutes 200,000
10,000 1,000,000 29 minutes 2 million
5,000 700,000 2.5 minutes 450,000*
12,000 3,000,000 1.5 hours 1.1 million*

* Linkage undertaken using blocking variables of Date of Birth, Medicare Card Number and Unique Identifier on a Pentium 4 1.8GHz PC with 256 Mb RAM.

Processing times may vary according to the data set characteristics, the number of linkage fields used and the computer specifications.