US 12,067,018 B2
Data certification process for updates to data in cloud database platform
Nagender Gurram, Glen Allen, VA (US); Yudhish Batra, Glen Allen, VA (US); Syed Shamaz Salim, North Potomac, MD (US); and Praveen Kandukuri, Ashburn, VA (US)
Assigned to Capital One Services, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Oct. 13, 2023, as Appl. No. 18/379,926.
Application 18/379,926 is a continuation of application No. 17/550,040, filed on Dec. 14, 2021, granted, now 11,829,367.
Prior Publication US 2024/0054133 A1, Feb. 15, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/2455 (2019.01); G06F 16/23 (2019.01); G06F 16/242 (2019.01); G06F 16/2457 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/24564 (2019.01) [G06F 16/2358 (2019.01); G06F 16/2365 (2019.01); G06F 16/2445 (2019.01); G06F 16/24575 (2019.01); G06F 16/256 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A data sharing platform configured to provide access to records of a database stored on a database server, the data sharing platform comprising:
one or more processors; and
memory storing instructions that, when executed by the one or more processors, cause the data sharing platform to:
determine one or more first rules that specify criteria, associated with consumer permissions to access the database via a cloud database platform, that limit consumer access to the records stored by the database;
perform, based on the one or more first rules, a data access certification process on the records stored by the database to generate a first table of certification results;
generate, based on the first table of certification results, and without modifying the records stored by the database, a limited consumer view definition configured to provide access to a first portion of the records in compliance with the criteria of the one or more first rules and exclude a second portion of the records not in compliance with the criteria of the one or more first rules;
detect an update to at least one record of the records stored by the database;
perform the data access certification process on the updated records to generate a second table of certification results;
generate, based on the first table of certification results and the second table of certification results, an updated limited consumer view definition different from the limited consumer view definition; and
cause a first virtual warehouse, of the one or more virtual warehouses, to execute a query on the records in compliance with the criteria of the one or more first rules via the updated limited consumer view definition.