• DocumentCode
    3122957
  • Title

    Large-Scale Deduplication with Constraints Using Dedupalog

  • Author

    Arasu, Arvind ; Re, Cristina ; Suciu, Dan

  • Author_Institution
    Microsoft Res., Redmond, WA
  • fYear
    2009
  • fDate
    March 29 2009-April 2 2009
  • Firstpage
    952
  • Lastpage
    963
  • Abstract
    We present a declarative framework for collective deduplication of entity references in the presence of constraints. Constraints occur naturally in many data cleaning domains and can improve the quality of deduplication. An example of a constraint is "each paper has a unique publication venue\´\´; if two paper references are duplicates, then their associated conference references must be duplicates as well. Our framework supports collective deduplication, meaning that we can dedupe both paper references and conference references collectively in the example above. Our framework is based on a simple declarative Datalog-style language with precise semantics. Most previous work on deduplication either ignoreconstraints or use them in an ad-hoc domain-specific manner. We also present efficient algorithms to support the framework. Our algorithms have precise theoretical guarantees for a large subclass of our framework. We show, using a prototype implementation, that our algorithms scale to very large datasets. We provide thorough experimental results over real-world data demonstrating the utility of our framework for high-quality and scalable deduplication.
  • Keywords
    DATALOG; constraint handling; data analysis; Dedupalog; ad-hoc domain-specific manner; collective deduplication; conference references; constraint; data cleaning domains; declarative Datalog-style language; large-scale deduplication; paper references; Art; Cleaning; Clustering algorithms; Computer science; Concrete; Data engineering; Databases; Large-scale systems; Prototypes; USA Councils; Data cleaning; Deduplication; algorithms; performance; query language;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Data Engineering, 2009. ICDE '09. IEEE 25th International Conference on
  • Conference_Location
    Shanghai
  • ISSN
    1084-4627
  • Print_ISBN
    978-1-4244-3422-0
  • Electronic_ISBN
    1084-4627
  • Type

    conf

  • DOI
    10.1109/ICDE.2009.43
  • Filename
    4812468