Encerrado

Duplicate Detector for SQL Server

In this project I need a duplicate detector developed for SQL Server 2005 as a stored procedure, VB Script, or [url removed, login to view] application. The detector should be based on the Jaro-Winkler algorithm, and should be capable determining all groups of duplicates within a data set of up to 500,000 records in under 2 hours (performance is extremely important.<br><br>

The Jaro Winkler algorithm has been implemented for SQL Server 2000, and can be found here:<br><br>

[url removed, login to view]+Puzzles/sql2000dbatoolkitpart3/2363/

<br>

<br>

The procedure, script, or application should take as input a particular field in a database table, and return 'groups of duplicates' thus that all fields of the record are returned, for example:<br><br>

Group 1:<br>

R1Field 1 R1Field 2 R1Field 3 R1Field 4 R1Field 5

R2Field 1 R2Field 2 R2Field 3 R2Field 4 R2Field 5

R3Field 1 R3Field 2 R3Field 3 R3Field 4 R3Field 5

<br>

Group 2:<br>

R1Field 1 R1Field 2 R1Field 3 R1Field 4 R1Field 5

R2Field 1 R2Field 2 R2Field 3 R2Field 4 R2Field 5

R3Field 1 R3Field 2 R3Field 3 R3Field 4 R3Field 5

<br>

Habilidades: .NET, Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, SQL, Visual Basic

Ver mais: visual basic algorithm example, visual basic algorithm, vb articles, vb algorithm, algorithm visual basic, sql duplicates, detector, duplicate table, net sql script, php sql 2000, found server, sql server database project, sql algorithm, sql server 2008 project, sql script data set, server 2008 project, script sql table, sql stored, server found, stored procedure sql algorithm, project based sql, procedure algorithm sql, 2008 server, duplicate input, algorithm based net project

Acerca do Empregador:
( 104 comentários ) SCOTTSDALE, United States

ID do Projeto: #3017966

7 freelancers estão ofertando em média $85 para este trabalho

maeenul

See private message.

$85 USD in 14 dias
(159 Comentários)
5.8
seventhsensesl

See private message.

$85 USD in 14 dias
(74 Comentários)
5.0
adeeylx

See private message.

$85 USD in 14 dias
(12 Comentários)
4.7
notvalidalv

See private message.

$85 USD in 14 dias
(43 Comentários)
4.6
farooqgill

See private message.

$85 USD in 14 dias
(15 Comentários)
4.6
jpandyavw

See private message.

$85 USD in 14 dias
(2 Comentários)
1.9
racexpertvw

See private message.

$85 USD in 14 dias
(0 Comentários)
0.0