System and method for archiving data

• US 20090132466A1
• Filed: 04/15/2005
• Published: 05/21/2009
• Est. Priority Date: 10/13/2004
• Status: Abandoned Application

• Current Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Original Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Inventors: Fear, Craig, Etherington, Mark R.
• Application Number:
  US11/107,646
• Publication Number:
  US 20090132466A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures

Abstract

Data to be archived may be stored in a data storage system in a compressed format that allows the compressed data to be accessible without decompression. Along with the data, supporting information is stored in the data storage system. The supporting information may include a location of the data in the storage system and at least one of a schema associated with the data and application information The application information may include a name and version number of an application used to access the data. One or more queries used to access the data may be stored in the storage system or elsewhere. Query attributes also may be stored in the storage system or elsewhere. Query attributes may include a location of a stored query and at least one of data, data formats, and database schemas compatible with a query.

Claims

1. A method for archiving structured data, the method comprising the steps of:

storing the structured data, or a derivative thereof, in at least one computer-accessible storage system;

storing supporting information in the storage system, wherein the supporting information comprises a location of the structured data in the storage system and a schema associated with the structured data;

storing query information comprising a query definition used to access the structured data;

compressing the structured data in a format that allows the compressed structured data to be queried without decompression, wherein the compressed structured data is the derivative of the structured data that is stored in the storage system; and

retrieving at least some of the compressed structured data without the decompression based at least upon the supporting information and the query information.

3. The method of claim 1, wherein the query information further comprises query attributes.

4. The method of claim 3, wherein the query attributes comprise a location of the stored query definition and at least one of the structured data, a data format, and a schema compatible with the stored query definition.

5. The method of claim 1, further comprising the step of retrieving at least some of the structured data based at least upon the supporting information and the query information.

2. (canceled)

6. (canceled)

7. (canceled)

8. A computer-accessible memory storing computer code for implementing a method for archiving structured data, wherein the computer code comprises:

code for storing the structured data, or a derivative thereof, in a storage system;

code for storing supporting information in the storage system, wherein the supporting information comprises a location of the structured data in the storage system and a schema associated with the structured data;

code for storing query information comprising a query definition used to access the structured data;

code for compressing the structured data in a format that allows the compressed structured data to be queried without decompression, wherein the compressed structured data is the derivative of the structured data that is stored in the storage system; and

code for retrieving at least some of the compressed structured data without the decompression based at least upon the supporting information and the query information.

10. The computer-accessible memory of claim 8, wherein the query information further comprises query attributes.

11. The computer-accessible memory of claim 10, wherein the query attributes comprise a location of the stored query definition and at least one of the structured data, a data format, and a schema compatible with the stored query definition.

12. The computer-accessible memory of claim 8, wherein the computer code further comprises code for retrieving the structured data based at least upon the supporting information and the query information.

9. (canceled)

13. (canceled)

14. A system for archiving structured data, the system comprising:

at least one storage system comprising a plurality of computer-accessible memories; and

at least one computer system communicatively connected to the storage system, wherein the computer system executes an archive application that instructs the computer system to;

store the structured data, or a derivative thereof, in the storage system;

store supporting information in the storage system, wherein the supporting information

comprises a location of the structured data in the storage system and a schema associated with the structured data;

store query information comprising a query definition used to access the structured data;

compress the structured data in a format that allows the compressed structured

data to be queried without decompression, wherein the compressed structured

data is the derivative of the structured data that is stored in the storage system; and

retrieve the compressed structured data without decompression based at least upon the supporting information and the query information.

15. The system of claim 14, wherein the archive application further instructs the computer system to retrieve at least some of the structured data from the storage system based at least upon the supporting information and the query information.

17. The system of claim 15, further comprising:

a user computer communicatively connected to the computer system, the user computer operating a user-interface, wherein the user-interface instructs the user computer to transmit a request to the computer system for at least some of the structured data stored in the storage system, and wherein the archive application further instructs the computer system to transmit the retrieved structured data to the user computer in response to the request.

18. The system according to claim 14 that are communicatively connected, such that the structured data may be retrieved from any of the storage systems.

19. The system of claim 14, further comprising:

a user computer communicatively connected to the plurality of the computer systems, the user computer operating a user-interface, wherein the user-interface instructs the user computer to transmit a request to at least one of the plurality of the computer systems, directly or indirectly, for structured data stored in at least one of the storage systems, and wherein at least one of plurality of the computer systems transmits the requested data to the user computer in response to the request.

16. (canceled)