Invention Grant
- Patent Title: Generating source code for creating database triggers
-
Application No.: US15087141Application Date: 2016-03-31
-
Publication No.: US10678774B2Publication Date: 2020-06-09
- Inventor: Peter Sramka
- Applicant: Toshiba Global Commerce Solutions Holdings Corporation
- Applicant Address: JP Tokyo
- Assignee: Toshiba Global Commerce Solutions Holdings Corporation
- Current Assignee: Toshiba Global Commerce Solutions Holdings Corporation
- Current Assignee Address: JP Tokyo
- Agency: Coats + Bennett, PLLC
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/23 ; G06F16/22 ; G06F16/901

Abstract:
A computing device obtains information associated with creating a plurality of database triggers. The computing device processes this information to determine a list of foreign keys that directly link a plurality of database tables. At least two of these database tables, however, are not directly linked. Therefore, the computing device uses the list of foreign keys to generate an indirect table path that indirectly links these two database tables through one or more intermediary tables. So linked, the computing device can automatically generate the source code for creating the plurality of database triggers to verify the integrity of the data stored in all of the plurality of database tables.
Public/Granted literature
- US20170286474A1 Generating Source Code for Creating Database Triggers Public/Granted day:2017-10-05
Information query