
doi: 10.2172/6053641
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.
Design, Data Base Management, And Information Science, Computing, Management 990300* -- Information Handling, 99 General And Miscellaneous//Mathematics, Diagrams
Design, Data Base Management, And Information Science, Computing, Management 990300* -- Information Handling, 99 General And Miscellaneous//Mathematics, Diagrams
| selected citations These citations are derived from selected sources. This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | 0 | |
| popularity This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network. | Average | |
| influence This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | Average | |
| impulse This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network. | Average |
