Browse Prior Art Database

Manage and Store Database Data Definition or Data Model as User Data

IP.com Disclosure Number: IPCOM000116345D
Original Publication Date: 1995-Sep-01
Included in the Prior Art Database: 2005-Mar-30
Document File: 2 page(s) / 38K

Publishing Venue

IBM

Related People

McGarrahan, JR: AUTHOR [+2]

Abstract

Disclosed is a method of managing database data definition as user data. This approach gives the database administrator the same facilities for managing data definition (i.e., searching, reporting, application programming interfaces, etc.) that are available to a general user in managing user data.

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

Manage and Store Database Data Definition or Data Model as User Data

      Disclosed is a method of managing database data definition as
user data.  This approach gives the database administrator the same
facilities for managing data definition (i.e., searching, reporting,
application programming interfaces, etc.) that are available to a
general user in managing user data.

      Database products typically store data definition internally,
inaccessible through programming interfaces.  The reason for this is
that some of this information is employed to optimize the data
structures used to record user data.  For example, relational
databases store user data in tables, and the field lengths specified
by the database administrator determine the column widths for the
tables.  For some databases, the data definition is independent of
the layout of the database.  In these cases, it might be reasonable
to dynamically change the data definition.  Furthermore, it might be
desirable to make these changes through a programming interface.  For
example, suppose that a database and corresponding data definition
reside on a mainframe system, and the user interface is created and
maintained on a personal computer (with a GUI visual builder, for
instance).  Given the close relationship between changes to the user
interface and data definition, it makes sense to perform these two
tasks simultaneously, with a single interface.  Hence, the need for
remote access to the data de...