Table of tables: A database design tool for SYBASE

Technical Report · Fri Jan 04 04:00:00 EST 1991

DOI:https://doi.org/10.2172/6053641· OSTI ID:6053641

Brown, B C; Coulter, K; Glass, H D; Glosson, R; Hanft, R W; Harding, D J; Trombly-Freytag, K; Walbridge, D G.C.; Wallis, D B ^[1]; Allen, M E ^[2]

---

1. Fermi National Accelerator Lab., Batavia, IL (USA)
2. 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., Batavia, IL (USA)
• 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

Related Subjects

99 GENERAL AND MISCELLANEOUS
990300* -- Information Handling
DATA BASE MANAGEMENT
DESIGN
DIAGRAMS
MANAGEMENT