Data Cleaning in Microsoft SQL Server 2005

Summary: Introduces Fuzzy Lookup and Fuzzy Grouping in SQL Server 2005 Integration Services for data cleaning. Scalable, domain-independent operators repair foreign-key mismatches and near-duplicate records, enabling high-quality data for data warehouses and mining. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: ha03a0e53cc4b2944
Venue: SIGMOD
Year: 2005
Pagerank: 5.4345321e-05
Overall Rank: 7,878 | 47.04%
DOI: 10.1145/1066157.1066287

Incoming Non-self Citations Over Time

Authors

1. Surajit Chaudhuri (Microsoft)
2. Kris Ganjam (Microsoft)
3. Venky Ganti (Microsoft)
4. Rahul Kapoor (Microsoft)
5. Vivek Narasayya (Microsoft)
6. Theo Vassilakis (Microsoft)

BibTeX Citation

@inproceedings{chaudhuri_sigmod05,
        title = {{Data Cleaning in Microsoft SQL Server 2005}},
        author = {Chaudhuri, Surajit and Ganjam, Kris and Ganti, Venky and Kapoor, Rahul and Narasayya, Vivek and Vassilakis, Theo},
        series = {{SIGMOD} '05},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1066157.1066287},
        url = {https://dl.acm.org/doi/10.1145/1066157.1066287},
        year = {2005}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,472	A Deferred Cleansing Method for RFID Data Analytics	2006	VLDB	5.7740555e-05
7,871	Incorporating String Transformations in Record Matching	2008	SIGMOD	5.4362081e-05
12,909	XClean in Action: A Demonstration of Declarative XML Data Cleaning	2007	CIDR	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
60	The Merge/Purge Problem for Large Databases	1995	SIGMOD	0.000394583
161	Robust and Efficient Fuzzy Match for Online Data Cleaning	2003	SIGMOD	0.00027718195

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	649	Discovering Data Quality Rules	2008	VLDB
2	8,219	Customizable and Scalable Fuzzy Join for Big Data	2019	VLDB
3	1,043	Data Cleaning: Overview and Emerging Challenges	2016	SIGMOD
4	3,426	Modeling and Querying Possible Repairs in Duplicate Detection	2009	VLDB
5	526	Improving Data Quality: Consistency and Accuracy	2007	VLDB
6	4,998	Descriptive and Prescriptive Data Cleaning	2014	SIGMOD
7	6,381	Qualitative Data Cleaning	2016	VLDB
8	1,509	Data Quality and Data Cleaning: An Overview	2003	SIGMOD
9	161	Robust and Efficient Fuzzy Match for Online Data Cleaning	2003	SIGMOD
10	307	Eliminating Fuzzy Duplicates in Data Warehouses	2002	VLDB