G - Physics – 06 – F
Patent
G - Physics
06
F
354/229
G06F 12/16 (2006.01) G06F 7/00 (2006.01) G06F 12/00 (2006.01) G06F 17/30 (2006.01)
Patent
CA 1290856
ABSTRACT Apparatus used in a relational data base system to maintain a dependence between a user-defined field in a row of one base table and the state of a set of rows in another base table. There are three kinds of dependent fields: a count field which contains a count of the rows in the set, a sum field which is the sum of a field in the rows of the set, and a base copy down field, which is a field in the rows of the set which contains a copy of a value in a field in the row of the one base table. The two base tables make up a referenced-referencing pair and the row from the one table has a primary key which is used as a foreign key in the set of rows of the other base table. The apparatus consists of components in the data dictionary which define the user-defined dependent field and the nature of the dependence, including any conditions thereon, and components in the data base system's run time system for maintaining the dependence. Each time the state of a row in the referencing base table is altered, the run time system uses the data dictionary to determine whether there is a user-defined dependent field, and if there is, what kind of dependent field it is. Code in the run time system then reestablishes the dependence as required for the altered row.
555990
Smart & Biggar
Wang Laboratories Inc.
LandOfFree
Relational database system does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Relational database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Relational database system will most certainly appreciate the feedback.
Profile ID: LFCA-PAI-O-1178272