Browse Prior Art Database

Code Generation for Database Applications

IP.com Disclosure Number: IPCOM000107618D
Original Publication Date: 1992-Mar-01
Included in the Prior Art Database: 2005-Mar-22
Document File: 2 page(s) / 71K

Publishing Venue

IBM

Related People

Cavendish, C: AUTHOR [+2]

Abstract

Most industrial strength applications make use of relational databases for storing information. Currently, it is difficult to write applications that make use of the static or dynamic abilities of a database due to the complexity of the tools such as the OS/2* Database Manager. Specialized programmers are required to design and construct applications interfacing with a database. This article describes a method of automatically generating the code to interface with the database and bringing the capability of creating simple database applications to a novice end user.

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

Code Generation for Database Applications

       Most industrial strength applications make use of
relational databases for storing information. Currently, it is
difficult to write applications that make use of the static or
dynamic abilities of a database due to the complexity of the tools
such as the OS/2* Database Manager.  Specialized programmers are
required to design and construct applications interfacing with a
database. This article describes a method of automatically generating
the code to interface with the database and bringing the capability
of creating simple database applications to a novice end user.

      The invention described here is that of a method of
automatically generating a template for the application logic to
interface with a relational database.  Developing database
applications on OS/2 and especially making 'distributed' database
applications (that can run in a multi-user multi-machine environment)
require an advanced level of skill not often found at the end user
level. Publicly available tools allow an end user who has limited
familiarity with the SQL query language used by OS/2 Database manager
(and other DB2*-related products) to create a custom database
application.

      When the user generates the GUI (graphical user interface) for
an application using the direct manipulation techniques, the
application and GUI logic (code) can be generated automatically. Say,
for example, the user wants to create a simple monitor to display the
current temperature along with the tempera...