Capital One Services, LLC

Ganesh Bharathan

Yudhish Batra

Syed Shamaz Salim

Nagender Gurram

Praveen Kandukuri

Karamchandradatt Hardatt

Naga Venkata Sriram Vadakattu

Sridhar Maramreddy

Hiren Shah

Naveen Kumar Kilaru

David Ellis

Kishore Kolanu

Felix Li

Nicole Ann Luo

Fnu Syed Siraj Mehmood

Syed Mehmood

Nicole Markley

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.

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

Methods, systems, and apparatuses for managing and selecting virtual warehouses for execution of queries on one or more data warehouses are described herein. A request to execute a query may be received. An execution plan, for the query, may be identified. A processing complexity for the query may be predicted based on the query and the execution plan. A plurality of virtual warehouses may be identified. An operating status and processing capabilities of the plurality of virtual warehouses may be determined. A subset of the plurality of virtual warehouses may be selected based on the processing complexity, the operating status of the plurality of virtual warehouses, and the processing capabilities of the plurality of virtual warehouses. The query may be executed on one of the subset of the plurality of virtual warehouses.

Dynamic query allocation to virtual warehouses

Methods, systems, and apparatuses for generating notifications corresponding to queries submitted for execution by virtual warehouses are described herein. A request to execute a query may be received. An execution plan, for the query, may be identified. A processing complexity for the query may be predicted based on the query and the execution plan. A notification may be generated based on the processing complexity meeting an alert threshold. A user device may display the notification. A response to the notification comprising a selection of a first virtual warehouse, of a plurality of virtual warehouses, to execute the query may be received.

Query alerts generation for virtual warehouse

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.

Methods of data sharing across cloud regions and cloud platforms of cloud-based data warehousing systems

Methods, systems, and apparatuses for optimizing the configuration of virtual warehouses for execution of queries on one or more data warehouses are described herein. A plurality of different events associated with a data sharing platform may be logged. The data sharing platform may enable users to access one or more databases managed by the data sharing platform. The data sharing platform may be configured to provide access to the data stored by the data sharing platform via one or more of a plurality of virtual warehouses. A testing database may be generated. An optimized virtual warehouse configuration may be predicted for a first virtual warehouse by selecting a plurality of different warehouse configurations for the first virtual warehouse, measuring performance parameters of each of the plurality of different warehouse configurations by emulating, and selecting the optimized virtual warehouse configuration based on the performance parameters.

Optimization of virtual warehouse computing resource allocation

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 recommendations, notifications, or alerts associated with usage of the data warehousing system may be generated.

Methods and systems for generating recommendations in cloud-based data warehousing system

Methods, systems, devices, and computer-readable media for orchestrating the sharing of 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.

Methods of orchestrated data sharing across cloud regions and cloud platforms of cloud-based data warehousing systems

Methods, systems, and apparatuses for tracking and generating analysis of queries submitted to virtual warehouses are described herein. A request to execute a query may be received. An organization may be determined, and the query may be modified to add an indication of the organization. A plurality of virtual warehouses may be identified. One of the plurality of virtual warehouses may be caused to execute the query. Query results and costs data may be received based on execution of the query by the first virtual warehouse. The costs data may indicate one or more costs associated with the execution of the query by the first virtual warehouse. The indication of the organization may be extracted from the query results. A user interface comprising query cost information corresponding to the organization may be generated.

Growing community of inventors

Henrico, VA, United States of America

Ganesh Bharathan