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

Reorganization Flags for Table Indexes

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

Publishing Venue

IBM

Related People

Li, SG: AUTHOR [+2]

Abstract

Disclosed is a scheme to provide database users with a graphical way to specify predefined indexes on which to reorganize or check the reorganization of a database table. The current design for database table reorganization and reorganization checking requires the user to pursue a two-step process for either action. This scheme simplifies the action to only one-step.

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

Reorganization Flags for Table Indexes

       Disclosed is a scheme to provide database users with a
graphical way to specify predefined indexes on which to reorganize or
check the reorganization of a database table.  The current design for
database table reorganization and reorganization checking requires
the user to pursue a two-step process for either action.  This scheme
simplifies the action to only one-step.

      Typically, after the user initiates the action to reorganize or
to check the reorganization of a table through a user interface, the
user is prompted with a modal dialog box that requires him or her to
enter an index name.  Since tables can be reorganized on a single
index or without an index, the option to reorganize a table without
using an index will also be offered at this point.

      However, this two-step action is not necessary.  In database
management, the user specifies an index for database table
reorganization and reorganization checking based on the nature and
use of the database table.  After the user determines the proper
specifications, the index specification is not likely to change for
each reorganization or reorganization check on the same database
table.  Instead of requiring the user to follow two steps, the
following gives the user a method to predefine indexes at any time by
specifying reorganization flags in a scrollable list of indexes, thus
allowing reorganization or a reorganization check based on predefined
index to immediately begin when requested.

      The panel (or pop-up) presents the user with a scrollable list.
Each row in the list consists of four fields listed from left to
right: flag for check reorganization, flag for reorganization, index
icon, and index name.  The entry fields for the index icon and name
will always be present in this list for each index in the table
object.  The index icon has the ability to act as a drag handle on
the index.  The index name provides the user with the actual name of
the index.  The other two fields allow the user to specify a flag to
indicate that the selected index should be used for the action in the
appropriate column - either check reorganization or r...