Browse Prior Art Database

Dynamic SQL Indexing

IP.com Disclosure Number: IPCOM000104167D
Original Publication Date: 1993-Mar-01
Included in the Prior Art Database: 2005-Mar-18
Document File: 2 page(s) / 23K

Publishing Venue

IBM

Related People

Maeker, B: AUTHOR [+2]

Abstract

The SQL database for the OV/2 Address Book contains many fields. Each of these data fields may or may not be appropriate for display to the user. Consequently, after accessing the SQL database, an OV/2 application must impose the user's particular "view" upon the information received from the SQL server. This process is iterative and very repetitive.

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

Dynamic SQL Indexing

      The SQL database for the OV/2 Address Book contains many
fields.  Each of these data fields may or may not be appropriate for
display to the user.  Consequently, after accessing the SQL database,
an OV/2 application must impose the user's particular "view" upon the
information received from the SQL server.  This process is iterative
and very repetitive.

      This article describes a method of building a dynamic index
into the SQL database.  This index is based upon the user's view, or
access, to each database field.

      The first time an application reads through the database
definition, the index of each accessible field is stored in a dynamic
array.  Each subsequent pass through the database definition is
accomplished by processing the index array, not the database
definition itself.  This technique greatly reduces processing time
and is implemented in the OV/2 R1 API set.