Tata Consultancy Services Limited

Rupali Kedar Kulkarni

Ashim Roy

Nikhil Girish Patwardhan

Sachin Premsukh Lodha

Sumit Johri

Amol Rajendra Limaye

Vijayanand Mahadeo Banahatti

Nandita Babu

Pranit Reke

Prachi Shastri

Shirish Damle

Adesh Ramdas Takawane

Ankit Jagtap

Kalaiselvan Kandasamy

Sitarama Narayana Bulusu

Nakhil Girish Patwardhan

Shraddha Kapse

Iyengar Venkatachary Srinivasan

Unique key fields in structured data is a critical characteristic of data which plays significant role in data management. Profiling high volume of data for discovering all possible unique keys with high accuracy is a costly and time taking affair. A method and system for finding one or more unique entities in a data have been provided. The one or more unique entities obtained by this approach are complete and the response time is quick. The method is scalable to increasing volume of data and number of fields. The system is configured to perform the analysis process in multiple phases taking the less volume initially and increasing it gradually, thereby reducing the load on later phases as the unique results found with light volume phases. The method also comprises a time check mechanism after different stages if a user wants to do discovery for limited time.

Method and system for finding one or more unique entities in data

This disclosure relates to a system and method for at source data masking and discovery of unique identifier for at-source masking. The method reads a table of production database comprising sensitive column from a source database for at source data masking. A unique identifier column is identified, and a temporary table is created which has three or more columns. Columns of temporary table comprises a sensitive column from the table of production database, a column for masked data of sensitive column and a unique identifier column. Sensitive column of the temporary table is masked using a known masking technique and the original data of the sensitive column and the masked data of the sensitive column is inserted into the temporary table. Finally, the production database is updated with the masked data of the sensitive column.

System and method for at-source masking of sensitive data

This disclosure relates generally to a system and method for masking text within images. Conventionally, image masking approaches have enabled masking but masking PII data which contains sensitive data is still a challenge. The present disclosure includes training and masking phase, wherein during training phase the PII label and values of the input image are captured and stored as co-ordinates in the database. During masking, the test image and the words comprised in the test image are optimized using an OCR technique. The label and value of each pairs are compared with the words comprised in the optimized test image. The comparison results in one or more matching labels and then a masking area is calculated for each matching label. The masking string is generated for each matching label based on the calculated masking area and the original text is masked with the generated string.

System and method for masking text within images

System and methods for creating one or more variants of test data during various test stages are disclosed. The system and methods facilitate a user to create a primary variant for test data and to store the primary variant of the test data in a test data variant repository. Any changes performed in the test database by the user are identified by using a tracking mechanism to store one or more new variants along with a variant number with respect to the changes performed in the test database in response to the user's request. The primary variant and the new variants are accessed by the user to perform a comparative analysis and to modify the test data at any test stage.

System and method for creating variants in a test database during various test stages

Methods and systems for masking data columns in a database are described herein. The method describes obtaining a masking template. Further the method describes associating the masking template with at least one rule and selecting columns based on the at least one rule. The method further describes identifying at least one column from the selected columns for applying masking setup and initiating masking setup on the at least one column based on the masking template.

Data masking setup

Disclosed is a method and system to provide management of test data, the management performed during at least one stage associated with lifecycle of the test data. The system comprises a processing engine, a categorization module, a privacy regulation module, a meta-data analyzer, and an output generation module. The processing engine configured to generate the test data in response to a test data request. The processing engine further comprises of the categorization module configured to categorize the test data request. The processing engine further comprises of the privacy regulation module configured to model at least one privacy regulation in accordance with a geographical location and an enterprise domain. The processing engine further comprises the meta-data analyzer configured to analyze an imported meta-data. The system further comprises of the output generation module configured to provide the test data so requested.

System and method to provide management of test data at various lifecycle stages

The present subject matter relates to systems and methods for database sampling. The method comprises identifying at least one query table and one or more associated tables amongst a plurality of tables in a production database, based on filtering criteria. Further, the method comprises generating a key value list for the at least one query table and each of the one or more associated tables based on an order indicated by an order list. Based on the generated key value list, the sample data is extracted in a reverse order indicated by the order list, from the at least one query table and each of the one or more associated tables.

Growing community of inventors

Maharashtra, India

Rupali Kedar Kulkarni