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)
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,343 | A Deferred Cleansing Method for RFID Data Analytics | 2006 | VLDB | 5.9063839e-05 |
| 7,714 | Incorporating String Transformations in Record Matching | 2008 | SIGMOD | 5.5608517e-05 |
| 12,619 | XClean in Action: A Demonstration of Declarative XML Data Cleaning | 2007 | CIDR | 5.093636e-05 |
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 58 | The Merge/Purge Problem for Large Databases | 1995 | SIGMOD | 0.00040116748 |
| 158 | Robust and Efficient Fuzzy Match for Online Data Cleaning | 2003 | SIGMOD | 0.00028199923 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 647 | Discovering Data Quality Rules | 2008 | VLDB |
| 2 | 8,088 | Customizable and Scalable Fuzzy Join for Big Data | 2019 | VLDB |
| 3 | 1,323 | Data Cleaning: Overview and Emerging Challenges | 2016 | SIGMOD |
| 4 | 3,371 | Modeling and Querying Possible Repairs in Duplicate Detection | 2009 | VLDB |
| 5 | 4,890 | Descriptive and Prescriptive Data Cleaning | 2014 | SIGMOD |
| 6 | 6,392 | Qualitative Data Cleaning | 2016 | VLDB |
| 7 | 533 | Improving Data Quality: Consistency and Accuracy | 2007 | VLDB |
| 8 | 1,484 | Data Quality and Data Cleaning: An Overview | 2003 | SIGMOD |
| 9 | 158 | Robust and Efficient Fuzzy Match for Online Data Cleaning | 2003 | SIGMOD |
| 10 | 306 | Eliminating Fuzzy Duplicates in Data Warehouses | 2002 | VLDB |