Real-Time Data Masking on MariaDB - Pandikrishnan Gurusamy - FOSSASIA 2018

Published on: Sunday, 25 March 2018

Speaker: Pandikrishnan Gurusamy

Analyzing data to make crucial business decisions is vital for any company to survive in today's competitive market. Even more so when we consider the eCommerce industry. In every corner of the world, eCommerce companies are vying to capture the market share. As a result, companies are required to provide processes and infrastructure to allow data access to Business Intelligence and Development teams without compromising on regulatory requirements. To solve this problem, there is some commercially available software which encrypts data at rest by using key management within or outside the RDBMS. But we have been able to solve this problem innovatively by using triggers and a set of Python scripts which is free, masks data in real time, has simple to configure columns for masking and retains the usability of data after masking. We have developed a set of functions for each type of sensitive data that is used in various applications most commonly. We will also discuss pros and cons.

Track: Database
Room: Training room 2-1
Date: Sunday, 25th March, 2018

Event Page:
Follow FOSSASIA on Twitter:
Like FOSSASIA on Facebook:

Produced by Engineers.SG