Brian D O'Connell

US Patent:

20170124148, May 4, 2017

Filed:

Oct 29, 2015

Appl. No.:

14/926997

Inventors:

- Armonk NY, US
Jeffrey R. Hoy - Gibsonia PA, US
Brian M. O'Connell - Cary NC, US
Clifford A. Pickover - Yorktown Heights NY, US
Keith R. Walker - Austin TX, US

International Classification:

G06F 17/30
G06F 1/32

Abstract:

Embodiments of the present invention disclose optimizing resources of distributed database replicas in which one or more processors receive resource information associated with a plurality of database replicas hosted on a plurality of servers, the resource information includes identification of indexes of database tables of each database replica. The instances of indexes residing in memory of the plurality of servers is determined, based on the state of each index, which indicates whether the index resides in memory. The instances of indexes that reside in memory and are redundant among the plurality of database replicas are determined, and in response to receiving a query directed to a database replica, if an index of a database table having the query-requested data resides in memory, the query is routed to the database replica on which the index resides in memory.