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

https://meltwater-apps-production.s3.amazonaws.com/uploads/images/575177cb18844e4839553b03/blobid1_1555509776572.jpg

 “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.

Read more

Waterloo News

Media? 

Contact media relations to learn more about this or other stories.