Archiving data in database management systems

Patent metadata

Field	Value
Publication number	US-9286300-B2
Application number	US-201313875469-A
Country	US
Kind code	B2
Filing date	May 2, 2013
Priority date	Sep 28, 2012
Publication date	Mar 15, 2016
Grant date	Mar 15, 2016

Abstract

At least a portion of data from a first processing system is archived onto a second processing system based on partitions of the data. A query received at the first processing system is processed at the second processing system to retrieve archived data satisfying the received query in response to determining at the first processing system that the received query encompasses archived data. Embodiments of the present invention further include methods, systems, and computer program products for archiving and accessing data in substantially the same manner described above.

First claim

What is claimed is:

1. A computer-implemented method comprising:
archiving at least a portion of data from a first processing system onto a second processing system;
determining, via the first processing system, whether data satisfying a received query is the archived data or non-archived data;
in response to the determined data being the archived data, transferring the received query from the first processing system to the second processing system to retrieve archived data satisfying the received query;
in response to the determined data being non-archived data;
determining, via the first processing system, eligibility of the received query for processing by the second processing system;
processing the received query, via the first processing system, to retrieve non-archived data satisfying the received query in response to the received query being ineligible for processing by the second processing system; and
transferring the received query from the first processing system to the second processing system to retrieve non-archived data satisfying the received query in response to the received query being eligible for processing by the second processing system.

2. The computer-implemented method of claim 1 , wherein the data for archiving includes data beyond a certain date.

3. The computer-implemented method of claim 1 , wherein the data within the first processing system is stored in one or more partitions of a table, and archiving includes:
archiving one or more partitions of the table storing the data to be archived.

4. The computer-implemented method of claim 1 , wherein the first processing system is a database management system, and the second processing system is a database accelerator.

5. The computer-implemented method of claim 4 , further comprising:
transferring the received query from the database management system to the database accelerator to retrieve the non-archived data satisfying the received query in response to determining that the received query is directed to the non-archived data and is eligible for acceleration by the database accelerator.

6. The computer-implemented method of claim 1 , further comprising:
receiving the query from an application and determining a location to process the received query based on a variable external of the application and indicating the data satisfying the received query, wherein the location includes one of the first processing system and second processing system.

7. The computer-implemented method of claim 1 , further comprising:
receiving the query from an application and determining a location to process the received query based on an indication of the data satisfying the received query within a statement of the application, wherein the location includes one of the first processing system and second processing system.

Assignees

• IBM

Inventors

• Draese Oliver
• Hrle Namik
• Kempfert Claus
• Koeth Oliver
• Li Ruiping
• Muse Robert S
• Stolze Knut
• Zhang Guogen

Classifications

• G06F11/1458

  Management of the backup or restore process · CPC title

• G06F17/30477

  Physics · mapped topic

• G06F17/30073 Primary

  Physics · mapped topic

• G06F17/30289

  Physics · mapped topic

• G06F17/30575

  Physics · mapped topic