US 2023/0401225 A1Published application

Methods and system for detecting unmanaged resources in cloud-based data warehousing system

AssigneeCapital One Services, LLC

InventorsHiren Shah, Ganesh Bharathan, Sridhar Maramreddy, Naga Venkata Sriram Vadakattu, Naveen Kumar Kilaru, David Ellis, Felix Li, Yudhish Batra, Kishore Kolanu, Syed Siraj Mehmood, Nicole Markley

Life of this patent

Estimating the term…

patentgrep

Loading patent…

Abstract

Methods, systems, devices, and computer-readable media used by a cloud data management system for collecting data from accounts hosted by a cloud-based data warehousing system on different cloud platforms or in different cloud regions of a cloud platform. Collection 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. Based on the collected data, one or more data warehouse resources not managed by the cloud data management system may be discovered, configured, and onboarded to the cloud data management system.

Claims20

Dependent claims

A method comprising:

identifying, by a first computing device associated with a data manager account of a cloud-based data warehouse system, a plurality of client accounts associated with a first client of the cloud-based data warehouse system;
determining, by the first computing device, that the plurality of client accounts associated with the first client are hosted in a plurality of cloud regions of the cloud-based data warehouse system;
for a first client account of the plurality of client accounts associated with the first client:
sending, by the first computing device and to a second computing device associated with the first client account, a first request, wherein, when the first client account is hosted in a same cloud region as the data manager account, the first request comprises a request for the first client account to share, with the data manager account, data indicating warehouse resources associated with the first client account, and wherein, when the first client account is hosted in a different cloud region from the data manager account, the first request comprises a request for the first client account to share, with a second data manager account hosted in the different cloud region, the data indicating the warehouse resources associated with the first client account,
sending, by the first computing device and to a third computing device associated with the second data manager account, when the first client account is hosted in the different cloud region, a second request to replicate, to the data manager account, the data shared from the first client account;
receiving, by the first computing device, an indication that the data is available for access;
accessing, by the first computing device and via the data manager account, the data;
and
storing, by the first computing device and in a database associated with the data manager account, the accessed data;
determining, by the first computing device and based on the stored data, one or more new warehouse resources included in the data since a previous request to access the data;
outputting, by the first computing device, a listing comprising the one or more new warehouse resources from one or more of the plurality of accounts associated with the first client;
receiving, by the first computing device, a first selection of a warehouse resource from the listing comprising the one or more new warehouse resources;
in response to the first selection, generating, by the first computing device and based on a type of the selected warehouse resource, a set of operating parameters to be associated with the selected warehouse resource;
and
configuring, by the first computing device, the selected warehouse resource to utilize, during operation, the set of operating parameters.

12 more elements

A first computing device associated with a data manager account of a cloud-based data warehouse system, wherein the first computing device comprises:

one or more processors;
and
memory storing computer-executable instructions that, when executed by the one or more processors, cause the first computing device to:
identify a plurality of client accounts associated with a first client of the cloud-based data warehouse system;
determine that the plurality of client accounts associated with the first client are hosted in a plurality of cloud regions of the cloud-based data warehouse system;
for a first client account of the plurality of client accounts associated with the first client:
send, to a second computing device associated with the first client account, a first request, wherein, when the client account is hosted in a same cloud region as the data manager account, the first request comprises a request for the first client account to share, with the data manager account, data indicating warehouse resources associated with the first client account, and wherein, when the first client account is hosted in a different cloud region from the data manager account, the first request comprises a request for the first client account to share, with a second data manager account hosted in the different cloud region, the data indicating the warehouse resources associated with the first client account,
send, to a third computing device associated with the second data manager account, when the first client account is hosted in the different cloud region, a second request to replicate, to the data manager account, the data shared from the first client account;
receive an indication that the data is available for access;
access, via the data manager account, the data;
and
store, in a database associated with the data manager account, the accessed data;
determine, based on the stored data, one or more new warehouse resources included in the data since a previous request to access the data;
output a listing comprising the one or more new warehouse resources from one or more of the plurality of accounts associated with the first client;
receive a first selection of a warehouse resource from the listing comprising the one or more new warehouse resources;
in response to the first selection, generate, based on a type of the selected warehouse resource, a set of operating parameters to be associated with the selected warehouse resource;
and
configure the selected warehouse resource to utilize, during operation, the set of operating parameters.

15 more elements

A cloud data management system comprising:

a first computing device associated with a data manager account of a cloud-based data warehouse system;
a second computing device associated with a first client account of a plurality of client accounts associated with a first client of the cloud-based data warehouse system, wherein the second computing device is configured to receive a request to share data;
and
a third computing device associated with a second data manager account of the cloud-based data warehouse system and hosted in a different cloud region from the data manager account, wherein the third computing device is configured to receive a request to replicate data,
wherein the first computing device is configured to:
identify the plurality of client accounts associated with the first client of the cloud-based data warehouse system;
determine that the plurality of client accounts associated with the first client are hosted in a plurality of cloud regions of the cloud-based data warehouse system;
for a first client account of the plurality of client accounts associated with the first client:
send, to the second computing device, a first request, wherein, when the first client account is hosted in a same cloud region as the data manager account, the first request comprises a request for the first client account to share, with the data manager account, data indicating warehouse resources associated with the first client account, and wherein, when the first client account is hosted in the different cloud region from the data manager account, the first request comprises a request for the first client account to share, with the second data manager account hosted in the different cloud region, the data indicating the warehouse resources associated with the first client account,
send, to the third computing device, when the first client account is hosted in the different cloud region, a second request to replicate, to the data manager account, the data shared from the first client account;
receive an indication that the data is available for access;
access, via the data manager account, the data;
and
store, in a database associated with the data manager account, the accessed data;
determine, based on the stored data, one or more new warehouse resources included in the data since a previous request to access the data;
output a listing comprising the one or more new warehouse resources from one or more of the plurality of accounts associated with the first client;
receive a first selection of a warehouse resource from the listing comprising the one or more new warehouse resources;
in response to the first selection, generate, based on a type of the selected warehouse resource, a set of operating parameters to be associated with the selected warehouse resource;
and
configure the selected warehouse resource to utilize, during operation, the set of operating parameters.

17 more elements

Dependencies are inferred from the claim text.

Facts

Application: 17/964,259Filed 12 Oct 2022
Priority: 10 Jun 2022
Published: 14 Dec 2023
Term ends: Not estimatedThe source records don’t support an estimate.

Classification14 codes

G06F 16/217
Design, administration or maintenance of databases: database tuning
G06F 16/254
Integrating or interfacing systems involving database management systems: extract, transform and load [ETL] procedures, e.g. ETL data flows in…
G06F 3/0604
Specifically adapted to achieve a particular effect: improving or facilitating administration, e.g. storage management
G06F 3/0653
Making use of a particular technique: monitoring storage devices or systems