Browse Prior Art Database

Field Level Address Book Customizable Processing

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

Publishing Venue

IBM

Related People

Martinez, AE: AUTHOR [+3]

Abstract

Disclosed is a mechanism for automated processing of information in relational database, with field-level granularity. The processing can be fully customized by the end user. This mechanism has been implemented in the IBM OfficeVision*/2 office product, as part of the Address Book Component.

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

Field Level Address Book Customizable Processing

       Disclosed is a mechanism for automated processing of
information in relational database, with field-level granularity.
The processing can be fully customized by the end user.  This
mechanism has been implemented in the IBM OfficeVision*/2 office
product, as part of the Address Book Component.

      Against each field in the Address Book, the end user can apply
special processing to occur, via the application of a "transform".
Transforms can be associated with individual fields in the relational
database (Database Manager, part of IBM's OS/2* Extended Edition) but
can also affect other fields in other tables.  Transforms are sub-
divided into two classes: class 1 transforms alter the data as it
gets deposited in the database, and class 2 transforms alter the
search criteria as it goes against database records.

      Class 1 transforms come into play when the Address Book is
being maintained.  A few examples follow: Fig. 1 shows a transform
that converts user input to uppercase before updating the database.
The CLIENT/SERVER boundary means that the processing need not be
confined to a single machine.  As the diagram shows, before the data
is inserted into the table, it is intercepted by the Uppercase
Transform and processed.

      Fig. 2 shows a transform that converts a field into its
phonetic analog, for fuzzy searches to be enabled against this field.
Phonetic Transforms intercepts the LASTNAME value and converts it
into a phonetic searchable form.  In this case, however, LASTNAME
remains intact and TWO fields...