skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: Automatically generating procedure code and database maintenance scripts

Abstract

Over the past couple of years the Information Technology Department at Sandia Laboratories has developed software to automatically generate database/4gl procedure code and database maintenance scripts based on database table information. With this software developers simply enter table and referential integrity information and the software generates code and scripts as required. The generated procedure code includes simple insert/delete/update procedures, transaction logging procedures as well as referential integrity procedures. The generated database maintenance scripts include scripts to modify structures, update remote databases, create views, and create indexes. Additionally, the software can generate EPSI representations of Binder diagrams for the tables. This paper will discuss the software application and use of it in real world applications. The automated generation of procedure code and maintenance scripts allows the developers to concentrate on the development of user interface code. The technique involves generating database/4 gl procedure code and maintenance scripts automatically from the database table information. The database/4gl procedure code provides standard insert/update/delete interfaces for upper level code as well as enforces the data constraints defined in the information model. The maintenance scripts provide maintenance scripts and migration scripts. This has resulted in fully updated database applications with complete rules enforcement and database maintenancemore » scripts within days of a database modification.« less

Authors:
 [1]
  1. Sandia National Labs., Albuquerque, NM (United States). Information Technologies and Methodologies Dept.
Publication Date:
Research Org.:
Sandia National Labs., Albuquerque, NM (United States)
Sponsoring Org.:
USDOE, Washington, DC (United States)
OSTI Identifier:
10185323
Report Number(s):
SAND-94-2524C; CONF-9410204-1
ON: DE95000545; BR: GB0103012; TRN: AHC29424%%119
DOE Contract Number:  
AC04-94AL85000
Resource Type:
Conference
Resource Relation:
Conference: 1994 Ingres world,Chicago, IL (United States),2-6 Oct 1994; Other Information: PBD: [1994]
Country of Publication:
United States
Language:
English
Subject:
99 GENERAL AND MISCELLANEOUS//MATHEMATICS, COMPUTING, AND INFORMATION SCIENCE; INFORMATION SYSTEMS; DATA BASE MANAGEMENT; COMPUTER CODES; AUTOMATION; MAINTENANCE; MODIFICATIONS; 990300; INFORMATION HANDLING

Citation Formats

Hatley, J.W. Automatically generating procedure code and database maintenance scripts. United States: N. p., 1994. Web.
Hatley, J.W. Automatically generating procedure code and database maintenance scripts. United States.
Hatley, J.W. Sat . "Automatically generating procedure code and database maintenance scripts". United States. https://www.osti.gov/servlets/purl/10185323.
@article{osti_10185323,
title = {Automatically generating procedure code and database maintenance scripts},
author = {Hatley, J.W.},
abstractNote = {Over the past couple of years the Information Technology Department at Sandia Laboratories has developed software to automatically generate database/4gl procedure code and database maintenance scripts based on database table information. With this software developers simply enter table and referential integrity information and the software generates code and scripts as required. The generated procedure code includes simple insert/delete/update procedures, transaction logging procedures as well as referential integrity procedures. The generated database maintenance scripts include scripts to modify structures, update remote databases, create views, and create indexes. Additionally, the software can generate EPSI representations of Binder diagrams for the tables. This paper will discuss the software application and use of it in real world applications. The automated generation of procedure code and maintenance scripts allows the developers to concentrate on the development of user interface code. The technique involves generating database/4 gl procedure code and maintenance scripts automatically from the database table information. The database/4gl procedure code provides standard insert/update/delete interfaces for upper level code as well as enforces the data constraints defined in the information model. The maintenance scripts provide maintenance scripts and migration scripts. This has resulted in fully updated database applications with complete rules enforcement and database maintenance scripts within days of a database modification.},
doi = {},
journal = {},
number = ,
volume = ,
place = {United States},
year = {1994},
month = {10}
}

Conference:
Other availability
Please see Document Availability for additional information on obtaining the full-text document. Library patrons may search WorldCat to identify libraries that hold this conference proceeding.

Save / Share: