University COVID-19 update

The University of Waterloo is constantly updating our most Frequently Asked Questions.

Questions about buildings and services? Visit the list of Modified Services.

Please note: The University of Waterloo is closed for all events until further notice.

New AI tool able to better identify bad data

Thursday, April 18, 2019


Researchers have developed a novel tool for managing the quality of your data. 

The revolutionary tool, HoloClean is the first to use artificial intelligence (AI) to sift out dirty data and correct errors before processing it.

“More and more machines are making decisions for us, so all our lives are touched by dirty data daily,” said Ihab Ilyas, a professor in Waterloo’s David R. Cheriton School of Computer Science. “If organizations like banks or utility companies are working with bad data, it could negatively impact things such as credit scores or mortgage approvals.”

The HoloClean system, developed by Ilyas and colleagues from the University of Wisconsin and Stanford University, successfully tackles the problem of insufficient training data by automatically generating bad examples without messing with the information, but enough to train the system to find errors and correct them on its own. 

After the AI is trained, it can then independently figure out what’s an error, what’s not, and if there’s an error determine the most probable value for the missing data. Users will then have a cleaner dataset to use in their analytics which will produce more trustworthy results.  

“This work deviates from the old way of manually trying to clean the data which was expensive, didn’t scale, and does not meet the current needs for cleaning the data,” said Ilyas of Waterloo’s Faculty of Mathematics. “This system addresses the problem where the information is out there, and people are using it to run analytics, but it is not correct. It doesn’t provide information that was not there, but instead corrects information you assume is correct.”

The next step for the researchers is to pair error detection and data repair in one end-to-end solution for the ultimate data quality dashboard. 

The paper detailing the error detection module titled “HoloDetect: Few-shot Learning for Error Detection”, which is slated to appear in Proceedings of the 2019 ACM SIGMOD conference is authored by Ilyas, Waterloo’s PhD candidate in Computer Science, Alireza Heidari, assistant professor in the Department of Computer Sciences at the University of Wisconsin-Madison, Theodoros Rekatsinas, and academic researcher at the University of Wisconsin, Joshua McGrath.

MEDIA CONTACT | Matthew Grant
226-929-7627 | @uwaterloonews |

Attention broadcasters: Waterloo has facilities to provide broadcast quality audio and video feeds with a double-ender studio. Please contact us for more information.

Get these news items on your student portal

  1. 2020 (76)
    1. August (1)
    2. July (12)
    3. June (12)
    4. May (15)
    5. April (25)
    6. March (3)
    7. February (2)
    8. January (6)
  2. 2019 (126)
    1. December (2)
    2. November (7)
    3. October (9)
    4. September (13)
    5. August (13)
    6. July (13)
    7. June (23)
    8. May (13)
    9. April (14)
    10. March (10)
    11. February (6)
    12. January (3)
  3. 2018 (99)
    1. December (4)
    2. November (8)
    3. October (9)
    4. September (15)
    5. August (10)
    6. July (11)
    7. June (11)
    8. May (9)
    9. April (12)
    10. March (4)
    11. February (2)
    12. January (4)
  4. 2017 (17)
  5. 2016 (17)
  6. 2015 (19)
  7. 2014 (24)
  8. 2013 (25)
  9. 2012 (18)