Nutanix, Inc.

Oracle International Corporation

Manish Pratap Singh

Kamaldeep Singh Khanuja

Yashesh Mankad

Balasubrahmanyam Kuchibhotla

Bakul Banthia

Anil Madan

Sagar Sontakke

Andrew Witkowski

Srikanth Bellamkonda

Madhuri Kandepi

A multi-cluster database management system includes a first cluster in a database management system of a virtual computing system, a second cluster in the database management system, a server on the first cluster, a first agent on the first cluster, and a second agent on the second cluster. The server provides a database management service to a first database stored on the first cluster via the first agent and to a second database stored on the second cluster via the second agent.

Multi-cluster database management system

A highly available database system includes a first instance of a database server on a first cluster of a virtual computing system, a second instance of the database server on a second cluster of the virtual computing system, a first instance of an administration database on the first cluster, and a second instance of the administration database on the second cluster. The first instance of the database server and the second instance of the database server form a highly available database server, the first instance of the administration database and the second instance of the administration database form a highly available administration database, and the first instance of the database server, the second instance of the database server, the first instance of the administration database, and the second instance of the administration database are configured to manage at least one customer database.

System and method for highly available database service

A multi-cluster configuration of a database management system in a virtual computing system includes a server that defines a first policy for a source database on a first cluster of a plurality of clusters. Each of the plurality of clusters is registered with the server and the first policy defines capture of snapshots and/or transactional logs from the source database on the first cluster. The server defines a second policy for the source database to replicate at least some of the snapshots and/or transactional logs from the first cluster to a second cluster of the plurality of clusters, captures a first snapshot and/or a first transactional log from the source database in accordance with the first policy, and replicates the first snapshot and/or the first transactional log to the second cluster in accordance with the second policy.

Multi-cluster database management services

An approach for implementing function semantic based partition-wise SQL execution and partition pruning in a data processing system is provided. The system receives a query directed to a range-partitioned table and determines if operation key(s) of the query include(s) function(s) over the table partitioning key(s). If so, the system obtains a set of values corresponding to each partition by evaluating the function(s) on a low bound and/or a high bound table partitioning key value corresponding to the partition. The system may then compare the sets of values corresponding to different partitions and determine whether to aggregate results obtained by executing the query over the partitions based on the comparison. The system may also determine whether to prune any partitions from processing based on a set of correlations between the set of values for each partition and predicate(s) of the query including function(s) over the table partitioning key(s).

Function semantic based partition-wise SQL execution and partition pruning

Growing community of inventors

Cupertino, CA, United States of America

Manish Pratap Singh