Browse Prior Art Database

Dynamic Extension and Validation of a Relational Database

IP.com Disclosure Number: IPCOM000107286D
Original Publication Date: 1992-Feb-01
Included in the Prior Art Database: 2005-Mar-21
Document File: 1 page(s) / 39K

Publishing Venue

IBM

Related People

Manchester, MG: AUTHOR [+2]

Abstract

Disclosed is a method of dynamically extending a relational database and allowing customized validation of the new fields and data being added.

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

Dynamic Extension and Validation of a Relational Database

       Disclosed is a method of dynamically extending a
relational database and allowing customized validation of the new
fields and data being added.

      A table is established to control the extension and validation
of data.  Each row of the table consists of two columns.  One column
defines allowable keywords that can be added to the database.  The
other column gives the name of a validation program that will
validate data associated with the specified keyword.  This table will
be called the control table.

      A second table actually holds the extended data.  This second
table consists of at least two columns.  One column contains the
keyword and the other column contains the data associated with the
keyword.  This table will be called the extension table.

      By use of referential integrity, only keywords entered into the
control table can be entered as keywords in the extension table.

      An application entering data into the database can fetch the
validation program name for a specified keyword. The program can then
be invoked with the keyword value as input.  In this manner, an
application can verify keywords and validate associated data being
entered into the database.

      Thus, a database can be extended to allow new keywords and data
validation by adding rows to the existing control table.  This method
of dynamically extending a database makes it possible for...