Browse Prior Art Database

Dynamically Extenable Data Access Request Environment

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

Publishing Venue

IBM

Related People

Geringer, SC: AUTHOR [+2]

Abstract

In SQL-based software products, customers often want to extend the database structure and program logic to accommodate their own applications. However, altering the database structure generally invalidates existing code.

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

Dynamically Extenable Data Access Request Environment

In SQL-based software products, customers often want to extend the
database structure and program logic to accommodate their own
applications.  However, altering the database structure generally
invalidates existing code.

      A programming environment is defined whereby an
object-code-only (OCO) product can allow extensions and alterations
and still meet production-system performance objectives.  The
customization requirement is twofold: (1) it must be possible to
extend the database structure without affecting code shipped with the
product; and (2) it must be possible to augment or replace any of the
product's database access logic.

The solution is compised of the following:

1.  Data Dictionary

    The data dictionary consists of database tables which describe
    all aspects of the data used in the system.

2.  Meta-data Storage Buffer

    This is an in-memory storage mechanism which stores data
    definition, content, and actions for a given object, as defined
    in the data dictionary.  When the buffer is created, its size and
    shape reflects the latest data dictionary definition.  The buffer
    exists for the duration of one transaction, so that it can be
    resized if necessary for later transactions.  Its purpose is to
    transport data back and forth between the application and the
    database access logic.

3.  Request Router

    The request router handles da...