Method and apparatus for obtaining storage information from...

Details Method and apparatus for obtaining storage information from... Method and apparatus for obtaining storage information from...

2007-03-06

2007-03-06

Truong, Cam-Y (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10658852

ABSTRACT:
Initially, a table in the database is baselined. The baselining function is usually built into the database system program which manages the database itself. This baselining procedure generates storage information like the number of rows in the table, the average length of a row, the number of chained/migrated rows, and the average free space per page in the table. This storage information is transferred to a monitoring routine via a transaction log. The monitoring routine accepts the storage information for the table. Next, the monitoring routine monitors the transaction log for entries which alter the storage information initially passed to it. At some point, an entity may wish to know the current storage information for the table. When this occurs, a message is passed to the monitoring routine, and the monitoring routine transfers the storage information to the requesting entity, without accessing the database.

REFERENCES:
patent: 5072367 (1991-12-01), Clayton et al.
patent: 5812849 (1998-09-01), Nykiel et al.
patent: 5870758 (1999-02-01), Bamford et al.
patent: 5966709 (1999-10-01), Zhang et al.
patent: 6058389 (2000-05-01), Chandra et al.
patent: 6092083 (2000-07-01), Brodersen et al.
patent: 6122640 (2000-09-01), Pereira
patent: 6192365 (2001-02-01), Draper et al.

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3769844