Archiving data in database management systems

摘要

According to one embodiment of the present invention, 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.

主权项

1. A system comprising:
a first processing system including at least one processor configured to:
archive at least a portion of data from the first processing system onto a second processing system;determine whether data satisfying a received query includes the archived data or non-archived data;in response to the determined data being the archived data, transfer 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:
determine eligibility of the received query for processing by the second processing system;process the received query to retrieve non-archived data satisfying the received query in response to the received query being ineligible for processing by the second processing system; andtransfer 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.