Automatically generating procedure code and database maintenance scripts

Title: Automatically generating procedure code and database maintenance scripts

Full Record
Other Related Research

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 »« less

Authors:

Hatley, J.W. ^[1]

Sandia National Labs., Albuquerque, NM (United States). Information Technologies and Methodologies Dept.

Publication Date:: 1994-10-01

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.

Copy to clipboard


                    Hatley, J.W. Automatically generating procedure code and database maintenance scripts.  United States.

Copy to clipboard


                    Hatley, J.W. Sat .  
        "Automatically generating procedure code and database maintenance scripts".  United States.  https://www.osti.gov/servlets/purl/10185323.

Copy to clipboard


                    
@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}

}

Copy to clipboard

Conference:

View Conference (0.94 MB)

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:

Export Metadata

Save to My Library

Similar records in OSTI.GOV collections:

Table of tables: A database design tool for SYBASE

Technical Report Brown, B.C. ; Coulter, K. ; Glass, H.D. ; ...

The Table of Tables' application system captures in a set of SYBASE tables the basic design specification for a database schema. Specification of tables, columns (including the related defaults and rules for the stored values) and keys is provided. The feature which makes this application specifically useful for SYBASE is the ability to automatically generate SYBASE triggers. A description field is provided for each database object. Based on the data stored, SQL scripts for creating complete schema including the tables, their defaults and rules, their indexes, and their SYBASE triggers, are written by TOT. Insert, update and delete triggers aremore »« less
DOI: 10.2172/6053641

Full Text Available
Accounting Data to Web Interface Using PERL

Technical Report Hargeaves, C

This document will explain the process to create a web interface for the accounting information generated by the High Performance Storage Systems (HPSS) accounting report feature. The accounting report contains useful data but it is not easily accessed in a meaningful way. The accounting report is the only way to see summarized storage usage information. The first step is to take the accounting data, make it meaningful and store the modified data in persistent databases. The second step is to generate the various user interfaces, HTML pages, that will be used to access the data. The third step is tomore »« less
DOI: 10.2172/15006203

Full Text Available
Making the connection between information modeling and implementation

Conference Eaton, M.J.

Over the past several years the Information Technology Department at Sandia Laboratories has developed information systems based on a solid foundation of information modeling and data administration. The output of the information modeling efforts is a fifth normal form relational table structure and associated data constraints. Developers would then implement the system by creating end-user application software. Traditionally, the development process combined the code necessary for maintaining data constraints with the code to provide the user interface (i.e. forms, windows, etc.). This approach has an adverse effect on the maintainability of the software as the system (i.e. the information model)more »« less
Making the connection between information modeling and implementation

Conference Eaton, M.J.

Over the past several years the Information Technology Department at Sandia Laboratories has developed information systems based on a solid foundation of information modeling and data administration. The output of the information modeling efforts is a fifth normal form relational table structure and associated data constraints. Developers would then implement the system by creating end-user application software. Traditionally, the development process combined the code necessary for maintaining data constraints with the code to provide the user interface (i.e. forms, windows, etc.). This approach has an adverse effect on the maintainability of the software as the system (i.e. the information model)more »« less
System for storing cathodic protection measurement data

Conference Bowman, T.J., Westinghouse Hanford

This paper describes a custom cathodic protection (CP) database, and discusses how this combination of data structure and software improves the ability to analyze cathodic protection. This may be a unique solution to the task of managing CP data, and may have value to others. This paper is primarily about the database design, and not about cathodic protection, per se. Every database project is a balancing act. A developer can create custom software that performs complex opcrafions requiring modest operator skills. On the other hand, custom software is expensive to both create and maintain. The Hanford CP data system willmore »« less
Full Text Available

Similar Records