Browse Prior Art Database

Database Access Duplicator

IP.com Disclosure Number: IPCOM000019662D
Original Publication Date: 2003-Sep-24
Included in the Prior Art Database: 2003-Sep-24
Document File: 2 page(s) / 23K

Publishing Venue

IBM

Abstract

A process that reads a database's system catalog (syscat) and applies the information to a template in order to generate database table specific source code.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 52% of the total text.

Page 1 of 2

Database Access Duplicator

  This document discloses process that dynamically generates non-language specific database client code, stored procedures, in-line code, test drivers, build components, and other forms of source code through the use of templates, a markup language, and the database's system catalog. The invention is that this process reads a database's system catalog (syscat) and applies the information to a template in order to generate database table specific source code. This process can be used to enhance development of new source code and its future maintenance.

The process described here accomplishes the following:

Reduces development time of large database applications. Is source language, platform, and database independent. Provides an avenue to enforce coding practices and standards. Tends to lessen the schedule impact of database changes late in the development schedule.

Applications that utilize databases typically consist of some number of databases containing sets of tables and some sort of interface routine to manipulate the data in the tables. Sophisticated interface routines might contain a grate deal of functionality and processes but at some point SQL statements are executed to interact with data in the database tables. A common problem with development and maintenance of database applications is that when table definitions change the interface code must be changed to accommodate the new definition. These changes could be anything from...