Table of tables: A database design tool for SYBASE
- Fermi National Accelerator Lab., Batavia, IL (USA)
- Superconducting Super Collider Lab., Dallas, TX (USA)
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 are generated from TOT to guarantee integrity of data relations when tables are connected by single column foreign keys. The application is written in SYBASE's APT-SQL and includes a forms based data entry system. Using the features of TOT we can create a complete database schema for which the data integrity specified by our design is guaranteed by the SYBASE triggers generated by TOT. 3 refs.
- Research Organization:
- Fermi National Accelerator Lab. (FNAL), Batavia, IL (United States)
- Sponsoring Organization:
- DOE/ER
- DOE Contract Number:
- AC02-76CH03000
- OSTI ID:
- 6053641
- Report Number(s):
- FNAL-TM-1707; ON: DE91007257
- Country of Publication:
- United States
- Language:
- English
Similar Records
An overview of the human genome database platform-Sybase
The IRMIS object model and services API.