Method and Apparatus for Reducing Storage Requirements of Electronic Records

• US 20090192977A1
• Filed: 01/24/2008
• Published: 07/30/2009
• Est. Priority Date: 01/24/2008
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Parrott, Neil D.
• Granted Patent: US 8,117,234 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data

Abstract

An embodiment of the present invention includes a system for storage of electronic records. The system includes a storage unit to store records and a processing system to store and retrieve records from the storage unit. The processing system receives non-exception based records and stores the records in the storage unit. This is accomplished by storing unique information from each received non-exception based record within the storage unit separately from information common to a plurality of non-exception based records. The stored unique information is linked with the stored common information. The present invention embodiments further include a method and a program product apparatus for storing electronic records as described above.

Claims

1. A system for storage of electronic records comprising:

a first storage unit to store records; and

a processing system to store and retrieve said records from said first storage unit, said processing system including;

a data manager module to receive non-exception based records and to store said received records in said first storage unit by storing unique information from each received non-exception based record within said first storage unit separately from information common to a plurality of non-exception based records and linking said stored unique information with said stored common information.

2. The system of claim 1, wherein said first storage unit includes a plurality of template record objects each containing said information common to a plurality of non-exception based records and a record information object for each said template record object to link unique record information to that template record object, and wherein said data manager module includes:

an extraction module to extract said unique information from each received non-exception based record and produce a unique record object with said extracted information and an identifier uniquely identifying said produced unique record object; and

a link module to place said identifier within said record information object associated with a corresponding template record object to link said unique information of said received record with corresponding common information of that record.

3. The system of claim 2, wherein said processing system further includes:

a retrieval module to receive a query and selectively provide records from said first storage unit satisfying said query.

4. The system of claim 3, wherein said retrieval module includes:

a query module to examine said produced unique record objects and identify those record objects with said unique record information satisfying said query;

a template module to identify said record information objects associated with said identified unique record objects to determine template record objects corresponding to said identified unique record objects; and

a record module to combine said unique information of said identified unique record objects with said common information of said corresponding template record objects to produce non-exception based records satisfying said query.

5. The system of claim 2, wherein said data manager module further includes:

a data recovery module to redundantly store said produced unique record objects to enable recovery of said non-exception based records.

6. The system of claim 3, further including:

a second storage unit to store exception based records;

wherein said data manager module receives exception based records and includes an exception module to store unique and common information of each exception based record together within said second storage unit.

7. The system of claim 6, wherein said retrieval module selectively provides records from said second storage unit satisfying said query.

22. The system of claim 2, wherein said data manager module further includes:

a deletion module to selectively delete said non-exception based record by deleting said corresponding unique record object and associated link and selectively deleting at least one of said associated record information object and template record object in response to the absence of an associated unique record object.

8. A method of storing electronic records comprising:

storing information common to a plurality of non-exception based records in a first storage unit;

storing unique information of each non-exception based record within said first storage unit separately from said common information; and

linking said stored unique information with said stored common information to enable storage of a single instance of said common information for said plurality of non-exception based records and reduce storage requirements for those records.

9. The method of claim 8, wherein:

said storing said common information includes storing within said first storage unit a plurality of template record objects each containing said information common to said plurality of non-exception based records and a record information object for each said template record object to link unique record information to that template record object;

said storing said unique information includes extracting said unique information from each non-exception based record and producing a unique record object with said extracted information and an identifier uniquely identifying said produced unique record object; and

said linking includes placing said identifier within said record information object associated with a corresponding template record object to link said unique information of said non-exception based record with corresponding common information of that record.

10. The method of claim 9, further including:

selectively providing records from said first storage unit satisfying a query.

11. The method of claim 10, wherein said selectively providing records further includes:

examining said produced unique record objects and identifying those record objects with said unique record information satisfying said query;

identifying said record information objects associated with said identified unique record objects to determine template record objects corresponding to said identified unique record objects; and

combining said unique information of said identified unique record objects with said common information of said corresponding template record objects to produce non-exception based records satisfying said query.

12. The method of claim 9, further including:

redundantly storing said produced unique record objects to enable recovery of said non-exception based records.

13. The method of claim 10, further including:

storing unique and common information of each exception based record together within a second storage unit.

14. The method of claim 13, wherein said selectively providing records further includes:

selectively providing records from said second storage unit satisfying said query.

23. The method of claim 9, further including:

selectively deleting said non-exception based record by deleting said corresponding unique record object and associated link and selectively deleting at least one of said associated record information object and template record object in response to the absence of an associated unique record object.

15. A program product apparatus including a computer usable medium with computer program logic recorded thereon for storing electronic records, said program product apparatus comprising:

a data manager module to receive non-exception based records and to store said received records in a first storage unit by storing unique information from each received non-exception based record within said first storage unit separately from information common to a plurality of non-exception based records and linking said stored unique information with said stored common information.

16. The program product apparatus of claim 15, wherein said first storage unit includes a plurality of template record objects each containing said information common to a plurality of non-exception based records and a record information object for each said template record object to link unique record information to that template record object, and wherein said data manager module includes:

an extraction module to extract said unique information from each received non-exception based record and produce a unique record object with said extracted information and an identifier uniquely identifying said produced unique record object; and

a link module to place said identifier within said record information object associated with a corresponding template record object to link said unique information of said received record with corresponding common information of that record.

17. The program product apparatus of claim 16, further including:

a retrieval module to receive a query and selectively provide records from said first storage unit satisfying said query.

18. The program product apparatus of claim 17, wherein said retrieval module includes:

a query module to examine said produced unique record objects and identify those record objects with said unique record information satisfying said query;

a template module to identify said record information objects associated with said identified unique record objects to determine template record objects corresponding to said identified unique record objects; and

a record module to combine said unique information of said identified unique record objects with said common information of said corresponding template record objects to produce non-exception based records satisfying said query.

19. The program product apparatus of claim 16, wherein said data manager module further includes:

a data recovery module to redundantly store said produced unique record objects to enable recovery of said non-exception based records.

20. The program product apparatus of claim 17, wherein said data manager module receives exception based records and includes an exception module to store unique and common information of each exception based record together within a second storage unit.

21. The program product apparatus of claim 20, wherein said retrieval module selectively provides records from said second storage unit satisfying said query.

24. The program product apparatus of claim 16, wherein said data manager module further includes:

a deletion module to selectively delete said corresponding unique record object by deleting said corresponding unique record object and associated link and selectively deleting said at least one of said associated record information object and template record object in response to the absence of an associated unique record object.