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.
Room: Training room 2-1
Date: Sunday, 25th March, 2018
Produced by Engineers.SG