Method and apparatus for automatic discovery of databases

Details Method and apparatus for automatic discovery of databases Method and apparatus for automatic discovery of databases

1996-03-29

1999-03-30

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

39518218, 39520064, 707204, 707205, G06F 1730

Patent

active

058901655

ABSTRACT:
A method and apparatus for automatic discovery of databases that determines what databases are installed at a client site, interrogates each database to determine what files or tables are present and what storage is associated with each, groups the databases into the smallest atomic units that can be backed up while preserving database integrity, and presents this information to backup procedures. In a preferred embodiment, a discovery process is performed by a script for each client to be backed up. Each script causes the creation of a temporary file describing each database. The temporary files are normalized into a common format which is then passed to a grouper program that analyzes the temporary files and produces a data descriptor file describing the smallest atomic units that can be backed up while still preserving database integrity at that client site. This data descriptor file is presented to a work item generator for scheduling backup procedures. Backups of each atomic unit can then be scheduled as desired.

REFERENCES:
patent: 4714995 (1987-12-01), Hatana et al.
patent: 5109515 (1992-04-01), Laggis et al.
patent: 5185860 (1993-02-01), Wu
patent: 5276872 (1994-01-01), Lomet et al.
patent: 5561797 (1996-10-01), Gilles et al.
patent: 5594900 (1997-01-01), Cohn et al.
patent: 5602936 (1997-02-01), Green et al.
patent: 5644698 (1997-07-01), Cannon
patent: 5673382 (1997-09-01), Cannon et al.
patent: 5675725 (1997-10-01), Malcom
patent: 5687367 (1997-11-01), Dockter et al.
Mosse et al. "Analysis of a Fault-Tolerance Multiprocessor Scheduling Algorithm", pp. 16-25, IEEE, Jan. 1994.
King et al, Grervicus of disaster recovery for transation processing systems, pp. 286-293, IEEE, Jul. 1990.

Affiliated with

Also associated with

Rating

Method and apparatus for automatic discovery of databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for automatic discovery of databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for automatic discovery of databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1225683