Method and apparatus for fast and comprehensive DBMS analysis

Details Method and apparatus for fast and comprehensive DBMS analysis Method and apparatus for fast and comprehensive DBMS analysis

1998-08-31

2000-08-22

Fetting, Anton W.

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707 3, G06F 1730

Patent

active

061086533

ABSTRACT:
A fast and comprehensive analysis of a database table is peformed by reading a header block describing the location of blocks storing data information of a database table. The data blocks of the database table are read using direct asynchronous IO into memory. Data read in from the data blocks is analyzed to determine information regarding the health or condition of the database table. The analysis is performed by spawning separate processes, each process being assigned an approximately equivalent number of data blocks to analyze. Once each process completes analysis of the assigned data blocks, the analysis by each thread is summarized and averaged to provide information to the DBA relating to the condition of the database table. The information gathered regarding the database table is more comprehensive than that provided by currently available database management systems and tools.

REFERENCES:
patent: 4506326 (1995-03-01), Shaw et al.
patent: 5261093 (1993-11-01), Asmuth
patent: 5806060 (1998-09-01), Borgida et al.
patent: 5864856 (1999-01-01), Young
patent: 5873091 (1999-02-01), Garth et al.
patent: 5974407 (1999-10-01), Sacks
Oracle 7tm Server SQL Language Reference Manual, Part No. 778-70-1292, Dec. 1992, pp. 4-89 thru 4-96.
Oracle 7tm Server Concepts Manual, Part No. 6693-70-1292, Dec. 1992, pp. 15-1 thru 15-14.

Affiliated with

Also associated with

Rating

Method and apparatus for fast and comprehensive DBMS analysis 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 fast and comprehensive DBMS analysis, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for fast and comprehensive DBMS analysis will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-593098