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.4139981e-05
Overall Rank: 7,900 | 47.05%
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,487	A Deferred Cleansing Method for RFID Data Analytics	2006	VLDB	5.7522385e-05
7,893	Incorporating String Transformations in Record Matching	2008	SIGMOD	5.4156783e-05
12,957	XClean in Action: A Demonstration of Declarative XML Data Cleaning	2007	CIDR	4.9605343e-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.00039343755
162	Robust and Efficient Fuzzy Match for Online Data Cleaning	2003	SIGMOD	0.00027626077

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	653	Discovering Data Quality Rules	2008	VLDB
2	8,241	Customizable and Scalable Fuzzy Join for Big Data	2019	VLDB
3	989	Data Cleaning: Overview and Emerging Challenges	2016	SIGMOD
4	3,437	Modeling and Querying Possible Repairs in Duplicate Detection	2009	VLDB
5	5,022	Descriptive and Prescriptive Data Cleaning	2014	SIGMOD
6	6,327	Qualitative Data Cleaning	2016	VLDB
7	527	Improving Data Quality: Consistency and Accuracy	2007	VLDB
8	1,510	Data Quality and Data Cleaning: An Overview	2003	SIGMOD
9	162	Robust and Efficient Fuzzy Match for Online Data Cleaning	2003	SIGMOD
10	308	Eliminating Fuzzy Duplicates in Data Warehouses	2002	VLDB