US 12,013,851 B2
Methods of data sharing across cloud regions and cloud platforms of cloud-based data warehousing systems
Hiren Shah, Stafford, VA (US); Ganesh Bharathan, Henrico, VA (US); Sridhar Maramreddy, Glen Allen, VA (US); Naga Venkata Sriram Vadakattu, Frisco, TX (US); and Naveen Kumar Kilaru, McLean, VA (US)
Assigned to Capital One Services, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Jun. 10, 2022, as Appl. No. 17/838,117.
Prior Publication US 2023/0401205 A1, Dec. 14, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 16/2453 (2019.01); G06F 16/25 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/24532 (2019.01) [G06F 16/252 (2019.01); G06F 16/283 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, by a first computing device, a request for a first account, of a first cloud-based data warehouse located in a first cloud region, to access data associated with a client account, wherein the first cloud-based data warehouse comprises one or more databases for storing data received from a plurality of other cloud-based data warehouses;
determining, by the first computing device, that a first portion of the data associated with the client account is stored in a second cloud-based data warehouse located in the first cloud region and that a second portion of the data associated with the client account is stored in a third cloud-based data warehouse located in a second cloud region;
sending, by the first computing device and to a second computing device associated with the second cloud-based data warehouse, first instructions to share the first portion of the data with the first account;
sending, by the first computing device and to a third computing device associated with the third cloud-based data warehouse, second instructions to share the second portion of the data with a second account of a fourth cloud-based data warehouse located in the second cloud region;
sending, by the first computing device and to a fourth computing device associated with the fourth cloud-based data warehouse, third instructions to:
persist the second portion of the data shared with the second account; and
replicate, to the first account of the first cloud-based data warehouse, the persisted second portion of the data;
accessing, by the first computing device, the first portion of the data shared from the second cloud-based data warehouse;
receiving, by the first computing device, the second portion of the data replicated from the fourth cloud-based data warehouse; and
storing, by the first computing device, in the first account of the first cloud-based data warehouse:
the first portion of the data shared from the second cloud-based data warehouse, and
the second portion of the data replicated from the fourth cloud-based data warehouse.