US 12,361,008 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 Jul. 12, 2024, as Appl. No. 18/771,415.
Application 18/771,415 is a continuation of application No. 18/379,926, filed on Oct. 13, 2023, granted, now 12,067,018.
Application 18/379,926 is a continuation of application No. 17/550,040, filed on Dec. 14, 2021, granted, now 11,829,367, issued on Nov. 28, 2023.
Prior Publication US 2024/0362230 A1, Oct. 31, 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:
perform, based on one or more first rules, associated with consumer permissions to access the database via a cloud database platform, 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, via one or more virtual warehouses of the cloud database platform, access to a first portion of the records in compliance with the one or more first rules and exclude a second portion of the records not in compliance with 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 at least one record 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 one or more first rules via the updated limited consumer view definition.