Repository logo

Infoscience

  • English
  • French
Log In
Logo EPFL, École polytechnique fédérale de Lausanne

Infoscience

  • English
  • French
Log In
  1. Home
  2. Academic and Research Output
  3. Conferences, Workshops, Symposiums, and Seminars
  4. Query-driven Repair of Functional Dependency Violations
 
Loading...
Thumbnail Image
conference paper

Query-driven Repair of Functional Dependency Violations

Giannakopoulou, Stella  
•
Karpathiotakis, Manos
•
Ailamaki, Anastasia  
January 1, 2020
2020 Ieee 36Th International Conference On Data Engineering (Icde 2020)
IEEE 36th International Conference on Data Engineering (ICDE)

Data cleaning is a time-consuming process that depends on the data analysis that users perform. Existing solutions treat data cleaning as a separate offline process that takes place before analysis begins. Applying data cleaning before analysis assumes a priori knowledge of the inconsistencies and the query workload, thereby requiring effort on understanding and cleaning the data that is unnecessary for the analysis.

We propose an approach that performs probabilistic repair of functional dependency violations on-demand, driven by the exploratory analysis that users perform. We introduce Daisy, a system that seamlessly integrates data cleaning into the analysis by relaxing query results. Daisy executes analytical query-workloads over dirty data by weaving cleaning operators into the query plan. Our evaluation shows that Daisy adapts to the workload and outperforms traditional offfine cleaning on both synthetic and real-world workloads.

  • Details
  • Metrics
Type
conference paper
DOI
10.1109/ICDE48307.2020.00195
Web of Science ID

WOS:000584252700190

Author(s)
Giannakopoulou, Stella  
•
Karpathiotakis, Manos
•
Ailamaki, Anastasia  
Date Issued

2020-01-01

Publisher

IEEE COMPUTER SOC

Publisher place

Los Alamitos

Published in
2020 Ieee 36Th International Conference On Data Engineering (Icde 2020)
ISBN of the book

978-1-7281-2903-7

Series title/Series vol.

IEEE International Conference on Data Engineering

Start page

1894

End page

1897

Subjects

Computer Science, Information Systems

•

Computer Science, Theory & Methods

•

Computer Science

•

data cleaning

•

dependencies

•

query-driven

Peer reviewed

REVIEWED

Written at

EPFL

EPFL units
DIAS  
Event nameEvent placeEvent date
IEEE 36th International Conference on Data Engineering (ICDE)

Dallas, TX

Apr 20-24, 2020

Available on Infoscience
December 23, 2020
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/174265
Logo EPFL, École polytechnique fédérale de Lausanne
  • Contact
  • infoscience@epfl.ch

  • Follow us on Facebook
  • Follow us on Instagram
  • Follow us on LinkedIn
  • Follow us on X
  • Follow us on Youtube
AccessibilityLegal noticePrivacy policyCookie settingsEnd User AgreementGet helpFeedback

Infoscience is a service managed and provided by the Library and IT Services of EPFL. © EPFL, tous droits réservés