Back to results
US 2023/0401205 A1Published application
Methods of data sharing across cloud regions and cloud platforms of cloud-based data warehousing systems s
AssigneeCapital One Services, LLC
InventorsHiren Shah, Ganesh Bharathan, Sridhar Maramreddy, Naga Venkata Sriram Vadakattu, Naveen Kumar Kilaru
Life of this patent
Estimating the term…
Abstract
Methods, systems, devices, and computer-readable media for sharing data between accounts that are hosted by a cloud-based data warehousing system on different cloud platforms or in different cloud regions of a cloud platform, and where such accounts may be associated with different organizations. Sharing of data in the multi-cloud platform and/or multi-cloud region environments may be facilitated by the on-demand creation of one or more data collection accounts.
Claims20
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.
11 more elements
A first computing device associated with a first cloud-based data warehouse located in a first cloud region, 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, and wherein the first computing device comprises:
- one or more processors;
- and
- memory storing instructions that, when executed by the one or more processors, cause the first computing device to:
- receive a request for a first account, of the first cloud-based data warehouse, to access data associated with a client account;
- determine 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;
- send, to a second computing device associated with the second cloud-based data warehouse, instructions to share the first portion of the data with the first account;
- send, to a third computing device associated with the third cloud-based data warehouse, 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;
- send, to a fourth computing device associated with the fourth cloud-based data warehouse, 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;
- access the first portion of the data shared from the second cloud-based data warehouse;
- receive the second portion of the data replicated from the fourth cloud-based data warehouse;
- and
- store 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.
14 more elements
A cloud-based data warehousing system comprising:
- a first computing device associated with a first cloud-based data warehouse located in a first cloud region, wherein the first-cloud warehouse comprises one or more databases for storing data received from a plurality of other cloud-based data warehouses;
- a second computing device associated with a second cloud-based data warehouse located in the first cloud region;
- a third computing device associated with a third cloud-based data warehouse located in a second cloud region;
- and
- a fourth computing device associated with a fourth cloud-based data warehouse located in the second cloud region,
- wherein the first computing device is configured to:
- receive a request for a first account, of the first cloud-based data warehouse, to access data associated with a client account;
- determine that a first portion of the data associated with the client account is stored in the second cloud-based data warehouse and that a second portion of the data associated with the client account is stored in the third cloud-based data warehouse;
- send, to the 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;
- send, to the 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 the fourth cloud-based data warehouse;
- send, to the 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;
- access the first portion of the data shared from the second cloud-based data warehouse;
- receive the second portion of the data replicated from the fourth cloud-based data warehouse;
- and
- store 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.
17 more elements
Dependencies are inferred from the claim text.