System for archiving and retrieving data from a database

• US 6,915,314 B2
• Filed: 12/11/2001
• Issued: 07/05/2005
• Est. Priority Date: 12/11/2001
• Status: Active Grant

• Current Assignee: Verint Americas Incorporated (Verint Systems Incorporated)
• Original Assignee: Adtech-GESI, LLC
• Inventors: Jackson, Donnie Wayne, Shadburn, Timmie Dean, Jackson, Ronnie Glenn
• Primary Examiner(s): Robinson, Greta L
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US10/014,695
• Publication Number:
  US 20030120625A1
• Time in Patent Office: 1,302 Days
• Field of Search: 707 2- 5, 707/10, 707/200, 707103 R-103 Z, 707/1, 707/100, 707/101, 707/102, 709/203
• US Class Current: 707/661
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: Y10S 707/917 Text
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

An Administrator Module existing as a layer of software residing on an Originating System'"'"'s computer. A Server Module existing as a layer of software residing on the Originating System or some other system accessible by the Originating System. The Administrator and Server Modules enable voluminous data of all types to be archived and retrieved by a user. The Administrator Module periodically or at a scheduled time analyzes the Originating System'"'"'s computer for candidate data to be archived. The Administrator Module formulates a table indicating candidate data for archiving in an alternative storage medium accessible by the originating system. The Administrator Module, upon command by the Originating System archives the candidate data and routinely purges data from the alternative storage media once that data has reached a predefined age. On demand the table indicating archived data is available for review by the user of the Originating System. Upon command by the user, the Server Module extracts selected data of interest from the alternative storage medium and restores the data to the Originating System'"'"'s file directories.

Claims

1. Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records, the Originating System in communication with at least one user, the user generating data records for archiving and retrieving, the Administrator and Server Modules having a plurality of data structures formulated into instruction objects to direct the functioning of archiving and retrieving data records generated by the user, comprising:

a) a Migrator Object selectively receiving the generated data records;

b) said Migrator Object formulating a data record event from said selectively received data records;

c) said Migrator Object storing said data record event in a selected database;

d) said Migrator Object formulating an event table from said stored data record events displayable to the Originating System;

e) a Requestor Object receiving a request stimulus for retrieval of a selected data record event;

f) said Requestor Object responsive to said request stimulus by retrieving at least one selected file referenced; and

g) said Requestor Object transmitting said retrieved file to the Originating System;

whereby the Originating System restores the retrieved data.

2. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 1, further comprising:

h) an Auto-Purge Object in communication with said Migrator Object;

i) said Auto-Purge Object purging said data record event referencing data older than maximum age allowed subsequent to said Migrator Object said data records in said selected database.

3. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 2, further comprising:

j) said Controller Object in communication with said Requestor Object;

k) said Controller Object in communication with the Originating System user via a graphical user interface;

l) said Controller Object receiving at least one instruction via said graphical user interface;

m) said Controller Object transforming said instruction into commands for said in communication objects;

n) said Controller Object in concert with said Requestor Object communicates said event table to Originating System user; and

,

o) said Controller Object formulating user attribute data, said Controller Object transmitting said user attribute data to said Requestor Object.

4. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 3, further comprising:

p) a Scheduling Object in communication with said Migrator Object; and

q) said Scheduling Object formulating a schedule optimizing the Originating System'"'"'s resources relative the operation of Migrator Object.

5. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 4, wherein said Migrator Object selectively receiving data records comprises:

a) said Migrator Object selectively receiving said database attribute data; and

b) said Migrator Object appending database attribute data to said data record event.

6. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 5, wherein said attribute data is selected from a group consisting of various database fields.

7. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 6, wherein said Migrator Object formulating a data record event from said selectively received data record comprises appending said attribute data to said selected user'"'"'s data record.

8. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 7, said Migrator Object storing said data record event in a selected database wherein said selected database is selected from a group consisting of tape database or other storage media, static memory and dynamic memory.

9. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 8, wherein said Migrator Object in concert with Auto-Purge Object acts in purging the Originating System of selected files subsequent to storing said data record event.

10. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 9, wherein said stimulus being is derived from said event table by the Originating System.

11. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 10, wherein said Migrator Object'"'"'s received generated data records comprise text data.

12. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 11, wherein said Migrator Object'"'"'s received generated data records.

13. The Administrator and Server Modules for archiving and retrieving an Originating System'"'"'s data records of claim 1, wherein said Migrator Object is further for causing said received data records to be removed from the Originating System.

14. An article of manufacture comprising:

a) a computer usable medium having computer readable program code means embodied therein for causing a response to an Originating System generating data records, said computer readable program code means in the article of manufacture comprising;

b) computer readable program code means for causing a computer to selectively formulate a data record event relative to said Originating System'"'"'s generated data records;

c) computer readable program code means for causing a computer to store on a selected database said data record event and said data records;

d) computer readable program code means for causing a computer to formulate a data record table from said stored data record event;

e) computer readable program code means for causing a computer to derive from said data record table a stored data record event; and

f) computer readable program code means for causing a computer to selectively retrieve said derived data record from said selected database.

15. The article of manufacture of claim 14, wherein said computer readable program code means is further for causing said data records to be removed from the Originating System.