IP Library Granted Patent US 8,495,021
Granted Patent B2
US 8,495,021 · App. 12/324,453 · Granted Jul 23, 2013

Distribution data items within geographically distributed databases

Inventors: Utkarsh Srivastava (Fremont, CA); Arvind Thiagarajan (Cambridge, MA)
Assignee: Yahoo! Inc.
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,495,021
App. No.
12/324,453
Granted
Jul 23, 2013
Kind
B2
Abstract

The subject matter disclosed herein relates to distribution data items within geographically distributed databases.

Claims (61)

1. A method, comprising:

determining access patterns for one or more data items within a geographically distributed database via a computing platform based at least partially on a number of read-type access requests of said one or more data items, wherein said geographically distributed database is mapped to store said one or more data items in a set of data centers comprising at least a first data center and a second data center; and

modifying distribution of said one or more data items within said set of data centers of said geographically distributed database based at least in part on said determination of access patterns, wherein said modifying distribution comprises removing at least one of said one or more data items from said first data center and adding said at least one or more data items to said second data center at least partially in response to a determination of one or more locations from which one or more recent updates of said at least one of said one or more data items have originated;

assigning individual data items to a master regional data center, wherein said geographically distributed database comprises two or more regional data centers;

receiving an access request for a given data item at a second regional data center;

determining that said second regional data center does not contain a replica copy of said given data item;

wherein said determination of access patterns comprises determining a local read rate for said given data item at said second regional data center; and

wherein said modification of distribution of said one or more data items comprises sending a request for a replica copy of said given data item from said second regional data center to said master regional data center based at least in part on said local read rate.

2. The method of claim 1 , further comprising transmitting at least one of said one or more data items to a user from said geographically distributed database.

3. The method of claim 1 , wherein said access patterns are further determined based at least in part on update type-access requests.

4. The method of claim 1 , wherein said modification of distribution of said one or more data items comprises sending a request for a replica copy of a given data item from a second regional data center portion of said geographically distributed database to a master regional data center portion of said geographically distributed database based at least in part on a local read rate associated with said given data item at said second regional data center.

5. The method of claim 1 , wherein said modification of distribution of said one or more data items comprises sending a replica copy of a given data item from a master regional data center portion of said geographically distributed database to a second regional data center portion of said geographically distributed database based at least in part on a replica placement constraint, wherein said replica placement constraint comprises restrictions on associating replica copies with portions of said geographically distributed database.

6. The method of claim 1 , wherein said determination of access patterns comprises determining a value function for a given data item at a second regional data center portion of said geographically distributed database, and wherein said modification of distribution of said one or more data items comprises sending a request to remove a replica copy of said given data item from said second regional data center to a master regional data center portion of said geographically distributed database based at least in part on a latency constraint associated with said value function.

7. The method of claim 1 , wherein said determination of access patterns comprises determining a value function for a given data item at a second regional data center portion of said geographically distributed database, wherein said value function comprises an association of read rate, update rate, and/or read count for individual data items.

8. The method of claim 1 ,

wherein said modification of distribution of said one or more data items further comprises sending a replica copy of said given data item from said master regional data center to said second regional data center based at least in part on a replica placement constraint, wherein said replica placement constraint comprises restrictions on associating replica copies with individual regional data centers.

9. The method of claim 1 , further comprising:

wherein said determination of access patterns comprises determining a value function for said given data item at said second regional data center; and

wherein said modification of distribution of said one or more data items comprises sending a request to remove a replica copy of said given data item from said second regional data center to said master regional data center further based at least in part on a latency constraint associated with said value function.

10. The method of claim 1 , further comprising:

wherein said determination of access patterns comprises determining a value function for said given data item at said second regional data center;

wherein said modification of distribution of said one or more data items comprises sending a request to remove a replica copy of said given data item from said second regional data center to said master regional data center further based at least in part on a latency constraint associated with said value function; and

wherein said modification of distribution of said one or more data items further comprises sending approval for removal of said replica copy of said given data item from said master regional data center to said second regional data center based at least in part on a replica placement constraint.

11. The method of claim 1 , further comprising:

wherein said determination of access patterns comprises determining a value function for said given data item at said second regional data center, wherein said value function comprises an association of read rate, update rate, and/or read count for individual data items;

wherein said modification of distribution of said one or more data items comprises sending a request to remove a replica copy of said given data item from said second regional data center to said master regional data center further based at least in part on a latency constraint associated with said value function, wherein said latency constraint comprises a quantification of a portion of access requests served from an individual regional data center; and

wherein said modification of distribution of said one or more data items further comprises sending approval for removal of said replica copy of said given data item from said master regional data center to said second regional data center based at least in part on a replica placement constraint, wherein said replica placement constraint comprises a quantification of a minimum number of data item replications within said geographically distributed database.

12. The method of claim 1 , further comprising:

wherein said modification of distribution of said one or more data items further comprises sending a replica copy of said given data item from said master regional data center to said second regional data center based at least in part on a replica placement constraint, wherein said replica placement constraint comprises restrictions on associating replica copies with individual regional data centers;

receiving a second access request for said given data item at a second regional data center;

wherein said determination of access patterns comprises determining a value function for said given data item at said second regional data center, wherein said value function comprises an association of read rate, update rate, and/or read count for individual data items;

wherein said modification of distribution of said one or more data items further comprises sending a request to remove said replica copy of said given data item from said second regional data center to said master regional data center based at least in part on a latency constraint associated with said value function, wherein said latency constraint comprises a quantification of a portion of access requests served from an individual regional data center; and

wherein said modification of distribution of said one or more data items further comprises sending approval for removal of said replica copy of said given data item from said master regional data center to said second regional data center based at least in part on a replica placement constraint, wherein said replica placement constraint comprises a quantification of a minimum number of data item replications within said geographically distributed database.

13. An article comprising:

a non-transitory storage medium comprising machine-readable instructions stored thereon which are executable by one or more processors to:

determine access patterns for one or more data items within a geographically distributed database based at least partially on a number of read-type access requests of said one or more data items, wherein said geographically distributed database is mapped to store said one or more data items in a set of data centers comprising at least a first data center and a second data center;

modify distribution of said one or more data items within said set of data centers of said geographically distributed database based at least in part on said determination of access patterns, wherein said modify distribution comprises removing at least one of said one or more data items from said first data center and adding said at least one of said one or more data items to said second data center at least partially in response to a determination of one or more locations from which one or more recent updates of said at least one of said one or more data items have originated;

assign individual data items to a master regional data center, wherein said geographically distributed database comprises two or more regional data centers;

receive an access request for a given data item at a second regional data center;

determine that said second regional data center does not contain a replica copy of said given data item;

wherein said determination of access patterns comprises determining a local read rate for said given data item at said second regional data center; and

wherein said modification of distribution of said one or more data items comprises sending a request for a replica copy of said given data item from said second regional data center to said master regional data center based at least in part on said local read rate.

14. The article of claim 13 , wherein said modification of distribution of said one or more data items further comprises initiation of transmission of a request for a replica copy of a given data item from a second regional data center portion of said geographically distributed database to a master regional data center portion of said geographically distributed database based at least in part on a local read rate associated with said given data item at said second regional data, center.

15. The article of claim 13 , wherein said modification of distribution of said one or more data items further comprises initiation of transmission of a replica copy of a given data item from a master regional data center portion of said geographically distributed database to a second regional data center portion of said geographically distributed database based at least in part on a replica placement constraint, wherein said replica placement constraint comprises restrictions on associating replica copies with portions of said geographically distributed database.

16. The article of claim 13 , wherein said determination of access patterns further comprises determination of a value function for a given data item at a second regional data center portion of said geographically distributed database, wherein said value function comprises an association of read rate, update rate, and/or read count for individual data items, and wherein said modification of distribution of said one or more data items comprises operatively enabling the computing platform to send a request to remove a replica copy of said given data item from said second regional data center to a master regional data center portion of said geographically distributed database based at least in part on a latency constraint associated with said value function.

17. An apparatus comprising:

a computing platform comprising one or more processors to:

determine access patterns for one or more data items within a geographically distributed database based at least partially on a number of read-type access requests of said one or more data items, wherein said geographically distributed database is mapped to store said one or more data items in a set of data centers comprising at least a first data center and a second data center;

modify distribution of said one or more data items within said set of data centers of said geographically distributed database based at least in part on said determination of access patterns, wherein said modify distribution comprises removing at least one of said one or more data items from said first data center and adding said at least one of said one or more data items to said second data center at least partially in response to a determination of one or more locations from which one or more recent updates of said at least one of said one or more data items have originated;

assign individual data items to a master regional data center, wherein said geographically distributed database comprises two or more regional data centers;

receive an access request for a given data item at a second regional data center;

determine that said second regional data center does not contain a replica copy of said given data item;

wherein said determination of access patterns comprises determining a local read rate for said given data item at said second regional data center; and

wherein said modification of distribution of said one or more data items comprises sending a request for a replica copy of said given data item from said second regional data center to said master regional data center based at least in part on said local read rate.

18. The apparatus of claim 17 , wherein said modification of distribution of said one or more data items further comprises:

initiation of transmission of a request for a replica copy of a given data item from a second regional data center portion of said geographically distributed database to a master regional data center portion of said geographically distributed database based at least in part on a local read rate associated with said given data item at said second regional data center; and

initiation of transmission of said replica copy of a given data item from said master regional data center portion of said geographically distributed database to said second regional data center portion of said geographically distributed database based at least in part on a replica placement constraint, wherein said replica placement constraint comprises restrictions on associating replica copies with portions of said geographically distributed database.

19. The apparatus of claim 17 , wherein said determination of access patterns further comprises determination of a value function for a given data item at a second regional data center portion of said geographically distributed database, wherein said value function comprises an association of read rate, update rate, and/or read count for individual data items, and wherein said modification of distribution of said one or more data items comprises operatively enabling the computing platform to send a request to remove a replica copy of said given data item from said second regional data center to a master regional data center portion of said geographically distributed database based at least in part on a latency constraint associated with said value function.

20. The method of claim 1 , wherein said modifying distribution of said one or more data items further comprises:

removing a first data item from a first data center and adding said first data item to a second data center based at least in part on access patterns of said first data item; and

removing a second data item from said first data center and adding said second data item to a third data center based at least in part on access patterns of said second data item.

Assignments (9)
CORRECTIVE ASSIGNMENT TO CORRECT THE THE ASSIGNOR NAME PREVIOUSLY RECORDED AT REEL: 052853 FRAME: 0153. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT. Recorded Mar 29, 2021
From: R2 SOLUTIONS LLC
To: STARBOARD VALUE INTERMEDIATE FUND LP, AS COLLATERAL AGENT
Reel/Frame 056832/0001 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 12, 2021
From: EXCALIBUR IP, LLC
To: R2 SOLUTIONS LLC
Reel/Frame 055283/0483 →
CORRECTIVE ASSIGNMENT TO CORRECT THE ASSIGNEE NAME PREVIOUSLY RECORDED ON REEL 053654 FRAME 0254. ASSIGNOR(S) HEREBY CONFIRMS THE RELEASE OF SECURITY INTEREST GRANTED PURSUANT TO THE PATENT SECURITY AGREEMENT PREVIOUSLY RECORDED. Recorded Dec 30, 2020
From: STARBOARD VALUE INTERMEDIATE FUND LP
To: R2 SOLUTIONS LLC
Reel/Frame 054981/0377 →
RELEASE OF SECURITY INTEREST IN PATENTS Recorded Jul 8, 2020
From: STARBOARD VALUE INTERMEDIATE FUND LP
To: ACACIA RESEARCH GROUP LLC; AMERICAN VEHICULAR SCIENCES LLC; BONUTTI SKELETAL INNOVATIONS LLC; CELLULAR COMMUNICATIONS EQUIPMENT LLC; INNOVATIVE DISPLAY TECHNOLOGIES LLC; LIFEPORT SCIENCES LLC; LIMESTONE MEMORY SYSTEMS LLC; MOBILE ENHANCEMENT SOLUTIONS LLC; MONARCH NETWORKING SOLUTIONS LLC; NEXUS DISPLAY TECHNOLOGIES LLC; PARTHENON UNIFIED MEMORY ARCHITECTURE LLC; R2 SOLUTIONS LLC; SAINT LAWRENCE COMMUNICATIONS LLC; STINGRAY IP SOLUTIONS LLC; SUPER INTERCONNECT TECHNOLOGIES LLC; TELECONFERENCE SYSTEMS LLC; UNIFICATION TECHNOLOGIES LLC
Reel/Frame 053654/0254 →
PATENT SECURITY AGREEMENT Recorded Jun 5, 2020
From: ACACIA RESEARCH GROUP LLC; AMERICAN VEHICULAR SCIENCES LLC; BONUTTI SKELETAL INNOVATIONS LLC; CELLULAR COMMUNICATIONS EQUIPMENT LLC; INNOVATIVE DISPLAY TECHNOLOGIES LLC; LIFEPORT SCIENCES LLC; LIMESTONE MEMORY SYSTEMS LLC; MERTON ACQUISITION HOLDCO LLC; MOBILE ENHANCEMENT SOLUTIONS LLC; MONARCH NETWORKING SOLUTIONS LLC; NEXUS DISPLAY TECHNOLOGIES LLC; PARTHENON UNIFIED MEMORY ARCHITECTURE LLC; R2 SOLUTIONS LLC; SAINT LAWRENCE COMMUNICATIONS LLC; STINGRAY IP SOLUTIONS LLC; SUPER INTERCONNECT TECHNOLOGIES LLC; TELECONFERENCE SYSTEMS LLC; UNIFICATION TECHNOLOGIES LLC
To: STARBOARD VALUE INTERMEDIATE FUND LP, AS COLLATERAL AGENT
Reel/Frame 052853/0153 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 3, 2016
From: YAHOO! INC.
To: EXCALIBUR IP, LLC
Reel/Frame 038950/0592 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 1, 2016
From: EXCALIBUR IP, LLC
To: YAHOO! INC.
Reel/Frame 038951/0295 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 18, 2016
From: YAHOO! INC.
To: EXCALIBUR IP, LLC
Reel/Frame 038383/0466 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 26, 2008
From: SRIVASTAVA, UTKARSH; THIAGARAJAN, ARVIND
To: YAHOO! INC.
Reel/Frame 021897/0182 →
Continuity (1)
Related Publication 20100131545A1 · May 27, 2010