Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Table Activity/ Reorg Indicator for the OS/2 EE Database Manager

IP.com Disclosure Number: IPCOM000107561D
Original Publication Date: 1992-Mar-01
Included in the Prior Art Database: 2005-Mar-22
Document File: 2 page(s) / 76K

Publishing Venue

IBM

Related People

Jacobs, DC: AUTHOR [+2]

Abstract

A method is described which will provide immediate information to the Database Administrator (DBA) so that he can make 'educated' decisions as to when and what database tables to reorganize when using the OS/2* Database Manager.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Table Activity/ Reorg Indicator for the OS/2 EE Database Manager

       A method is described which will provide immediate
information to the Database Administrator (DBA) so that he can make
'educated' decisions as to when and what database tables to
reorganize when using the OS/2* Database Manager.

      In the Database Manager (DBM) arena, the performance of the
system is very important.  In fact, the throughput of the system is
one of the major considerations of the user when purchasing a
particular Database Management System (DBMS).  One of the major
causes of performance degradation is the fragmentation of the
database.  As the database is updated, information is written to DASD
(Direct Access Storage Device).  By the very nature of the DASD, the
data is disbursed to different sections of the disk.  Over a period
of time the physical arrangement of the data on the DASD is dispersed
in an inefficient manner.  This dispersion may result in a large
amount of read/write head movement in order to retrieve the necessary
data for a given SQL query. This slower seek and access time and
consequently results in a slower DBMS.  To remedy this problem, the
OS/2 Database Manager provides a Reorganization utility.

      With past releases of the OS/2 EE Database  Manager (DBM), the
DBA would have to guess at the ideal time at which to reorganize
database tables.  The DBA would also have to guess which tables were
in need of reorganization. Although reorganization helps the
throughput of the DBMS, the act of reorganizing database tables is
not a time trivial endeavor. For large, complicated tables the
process may take hours.  To reorganize a table that does not require
the defragm...