Invention Grant
- Patent Title: Sanitizing database structures for testing
-
Application No.: US17461960Application Date: 2021-08-30
-
Publication No.: US11645304B2Publication Date: 2023-05-09
- Inventor: Vaibhav Mallya , Nikhil Mathew
- Applicant: ZenPayroll, Inc.
- Applicant Address: US CA San Francisco
- Assignee: ZENPAYROLL, INC.
- Current Assignee: ZENPAYROLL, INC.
- Current Assignee Address: US CA San Francisco
- Agency: Fenwick & West LLP
- Main IPC: G06F16/27
- IPC: G06F16/27 ; G06F21/62 ; G06F16/16 ; G06F16/21 ; G06F16/22 ; G06F16/28

Abstract:
A central database system allows users to access and use data stored in a relational database. In order to ensure that the stored data is not detrimentally impacted and that the security of the stored data is maintained, the central database system generates a sanitized copy of the database. The central database system stores and accesses annotation files associated with data tables of the database and a schema identifying the structure of the database. Based on the schema, for each data table, the central database system validates the annotation file. A copy of the data table is created and sanitized corresponding to the annotation file. The sanitized copies of the data tables are used to generate a sanitized copy of the database. The sanitized copy of the database may then be accessed and used by users of the central database system without impacting the relational database.
Public/Granted literature
- US20210390116A1 SANITIZING DATABASE STRUCTURES FOR TESTING Public/Granted day:2021-12-16
Information query