IP Library Granted Patent US 10,169,381
Granted Patent B2
US 10,169,381 · App. 13/459,722 · Granted Jan 1, 2019

Database recovery by container

Inventor: Stephen Gregory Walkauskas (Boston, MA)
Assignee: ENTIT SOFTWARE LLC
G06F17/30303G06F17/30283
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 10,169,381
App. No.
13/459,722
Filed
Apr 30, 2012
Granted
Jan 1, 2019
Kind
B2
Examiner
VO, CECILE H
Art Unit
2153
USPC
707/674
Abstract

A method includes identifying a buddy database projection that corresponds to a recovering database projection that is to be recovered to a recovering node of a database system. A source container containing data of the buddy database projection is identified on a source node of the database system, the source container being characterized by a range of epochs that includes an epoch for which data is to be recovered to the recovering node. Data is copied from the identified source container to the recovering node.

Claims (33)

1. A method comprising:

identifying a buddy database projection that is a copy of a recovering database projection of a database, wherein the recovering database projection is stored on a recovering node of a database system and the buddy database projection is stored on a source node of the database system, the buddy database projection and the recovering database projection each providing a first view of a first database table;

identifying, based on the identified buddy database projection, a source container on the source node of the database system, the source container containing data of the identified buddy database projection; and

in response to a determination that a range of epochs of the identified source container includes an epoch for which data is to be recovered to the recovering database projection from the buddy database projection, direct copying the identified source container on the source node to the recovering node.

2. The method of claim 1 , wherein the data contained by the source container is compressed.

3. The method of claim 2 , wherein the direct copying of the source container to the recovering node is performed without decompressing the compressed data of the source container.

4. The method of claim 1 , wherein the range of epochs includes a superfluous epoch for which data need not be recovered to the recovering node.

5. The method of claim 4 , further comprising automatically applying a filter to a query to the recovering database projection so as to prevent a returned result to the query from including data that is associated with the superfluous epoch.

6. The method of claim 1 , wherein the data in the container comprises an index of the first database table.

7. The method of claim 1 , wherein the database is modifiable concurrently with copying the data.

8. A non-transitory computer readable storage medium having stored thereon instructions that when executed by a processor will cause the processor to perform the method of:

identifying a recovering node of a database system;

identifying a recovering database projection of a database, wherein the recovering database projection is stored on the recovering node;

identifying a buddy database projection that is a copy of the recovering database projection, wherein the buddy database projection is stored on a source node of the database system, the buddy database projection and the recovering database projection each providing a first view of a first database table;

identifying, based on the identified buddy database projection, a source container on the source node of the database system, the source node being different from the recovering node, the source container containing data of the identified buddy database projection;

in response to a determination that a range of epochs of the identified source container includes an epoch for which data is to be recovered to the recovering database projection from the buddy database projection, direct copying the identified source container to the recovering node.

9. The computer readable storage medium of claim 8 , wherein the data contained by the source container is compressed.

10. The computer readable storage medium of claim 9 , wherein the direct copying of the source container to the recovering node is performed without decompressing the compressed data.

11. The computer readable storage medium of claim 8 , wherein the range of epochs includes a superfluous epoch for which data need not be recovered to the recovering node.

12. The computer readable storage medium of claim 11 , further comprising automatically applying a filter to a query to the recovering database projection so as to prevent a returned result to the query from including data that is associated with the superfluous epoch.

13. The computer readable storage medium of claim 8 , wherein the data in the container comprises an index of the first database table.

14. The computer readable storage medium of claim 8 , wherein the database is modifiable concurrently with copying the data.

15. A system comprising:

a processing unit in communication with a computer readable medium, wherein the computer readable medium contains a set of instructions wherein the processing unit is designed to carry out the set of instructions to:

identify a recovering node of a database system;

identify a buddy database projection that is a copy of a recovering database projection of a database, wherein the recovering database projection is stored on the recovering node, wherein the buddy database projection is stored on a source node of the database system, the buddy database projection and the recovering database projection each providing a first view of a first database table;

identify, based on the identified buddy database projection, a source container on the source node of the database system, the source container containing data of the buddy database projection; and

in response to a determination that a range of epochs of the identified source container includes an epoch for which data is to be recovered to the recovering database projection from the buddy database projection, direct copy the identified source container on the source node to the recovering node.

16. The system of claim 15 , wherein the source node and the recovering node are connected via a network.

17. The system of claim 15 , wherein the data contained by the source container is compressed.

18. The system of claim 15 , wherein the system is configured to direct copy the source container byte-for-byte to the recovering node.

19. The system of claim 15 , wherein the system is configured to modify the database concurrently with copying the data from the source container to the recovering node.

20. The system of claim 17 , wherein the direct copy of the source container to the recovering node is performed without decompressing the compressed data.

Assignments (9)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 28, 2026
From: MICRO FOCUS LLC
To: ROCKET SOFTWARE, INC.
Reel/Frame 075795/0114 →
RELEASE OF SECURITY INTEREST REEL/FRAME 044183/0718 Recorded Feb 2, 2023
From: JPMORGAN CHASE BANK, N.A.
To: MICRO FOCUS LLC (F/K/A ENTIT SOFTWARE LLC); BORLAND SOFTWARE CORPORATION; MICRO FOCUS (US), INC.; SERENA SOFTWARE, INC; ATTACHMATE CORPORATION; MICRO FOCUS SOFTWARE INC. (F/K/A NOVELL, INC.); NETIQ CORPORATION
Reel/Frame 062746/0399 →
RELEASE OF SECURITY INTEREST REEL/FRAME 044183/0577 Recorded Feb 2, 2023
From: JPMORGAN CHASE BANK, N.A.
To: MICRO FOCUS LLC (F/K/A ENTIT SOFTWARE LLC)
Reel/Frame 063560/0001 →
CHANGE OF NAME Recorded Aug 8, 2019
From: ENTIT SOFTWARE LLC
To: MICRO FOCUS LLC
Reel/Frame 050004/0001 →
SECURITY INTEREST Recorded Oct 11, 2017
From: ATTACHMATE CORPORATION; BORLAND SOFTWARE CORPORATION; NETIQ CORPORATION; MICRO FOCUS (US), INC.; MICRO FOCUS SOFTWARE, INC.; ENTIT SOFTWARE LLC; ARCSIGHT, LLC; SERENA SOFTWARE, INC.
To: JPMORGAN CHASE BANK, N.A.
Reel/Frame 044183/0718 →
SECURITY INTEREST Recorded Oct 11, 2017
From: ENTIT SOFTWARE LLC; ARCSIGHT, LLC
To: JPMORGAN CHASE BANK, N.A.
Reel/Frame 044183/0577 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 9, 2017
From: HEWLETT PACKARD ENTERPRISE DEVELOPMENT LP
To: ENTIT SOFTWARE LLC
Reel/Frame 042746/0130 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 9, 2015
From: HEWLETT-PACKARD DEVELOPMENT COMPANY, L.P.
To: HEWLETT PACKARD ENTERPRISE DEVELOPMENT LP
Reel/Frame 037079/0001 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 1, 2012
From: WALKAUSKAS, STEPHEN GREGORY
To: HEWLETT-PACKARD DEVELOPMENT COMPANY, L.P.
Reel/Frame 028133/0324 →
Continuity (2)
Provisional Application 61485792 · May 13, 2011
Related Publication 20120290540A1 · Nov 15, 2012