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 VB.NET 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>

http://www.sqlservercentral.com/articles/SQL+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.net articles, vb net algorithm, vb articles, vb algorithm, example for algorithm, algorithm vb.net, algorithm in visual basic, sql server or, SQL Server, sql server c, sql server c# 2008, sql duplicates, net sql server, net c# sql server, detector, c sql server, duplicate table, net sql script, php sql 2000, found server, sql server database project, sql algorithm, sql server 2008 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