Browse Prior Art Database

Embedded SQL Code Generator

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

Publishing Venue

IBM

Related People

Schuetze, TB: AUTHOR [+2]

Abstract

For a software application to make the most efficient use of a database, the application may need to use static-embedded SQL. While static-embedded SQL might be efficient for the database, it is not efficient for the calling application since each new type of database request must be written as a separate programming language function, even if the new function is almost identical to a previously written function. Dynamic SQL is better from a software engineering perspective since most of the source code can be shared; however, dynamic SQL usually performs poorly compared to static SQL.

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

Embedded SQL Code Generator

       For a software application to make the most efficient use
of a database, the application may need to use static-embedded SQL.
While static-embedded SQL might be efficient for the database, it is
not efficient for the calling application since each new type of
database request must be written as a separate programming language
function, even if the new function is almost identical to a
previously written function.  Dynamic SQL is better from a software
engineering perspective since most of the source code can be shared;
however, dynamic SQL usually performs poorly compared to static SQL.

      The embedded SQL code generator solves the dilemma described
above by allowing the programmer to specify the requirements of a
database request in a description file in a very terse format.  The
embedded SQL code generator reads the description file and
automatically writes all of the required programming language
functions containing the more efficient static-embedded SQL calls.
Thus, both small code size and efficient use of the database are
achieved through the embedded SQL generator.

      The embedded SQL code generator creates one or more files
containing source code functions that access the database.  The
number and kind of functions created depend on the contents of one or
more description files.

      A single description file results in the creation of one source
file. The description file is expected to be named with a suffix of
'.g'. The output source file will be named the same as the input
source file, except that the suffix will be whatever is appropriate
for the database package being used.  The output source file contains
one or more functions, one for each stanza defined in the description
file.

      The description file consists of a number of stanzas. The first
one describes any information which is true for the entire
description file, followed by one s...