US4918593A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Relational database system
Assignee: Wang Laboratories Inc
•
Filing: 1987-01-08
•
Granted: 1990-04-17
•
Expires: 2007-01-08
Abstract
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.
Inventors
- 👤 Val J. Huber
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-24 20:52
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/23; G06F16/2365; G06F16/28; G06F16/284
Claims Analysis
Total Claims: 16
Claim 1
Independent Claim
142 words
In a relational data base system including data dictionary means, a first base table and a second base table, each of which has at least one user-defined row defined in the data dictionary in such fashion that the first base table and the second base table are referenced and referencing, and operational means responsive to data base operation commands and to the data dictionary for performing operations on the rows, means for maintaining a dependence between a first user-defined field in a row in one of the base tables and a row in the other of the base tables comprising: dependence defining means in the data dictionary for defining the dependence; and means in the operational means responsive to the dependence defining means for reestablishing the dependence as defined in the dependence defining means whenever a data base operation alters the row.
Claim 2
Dependent Claim
142 words
In a relational data base system including data dictionary means, a first base table and a second base table, each of which has at least one user-defined row defined in the data dictionary in such fashion that the first base table and the second base table are referenced and referencing, and operational means responsive to data base operation commands and to the data dictionary for performing operations on the rows, means for maintaining a dependence between a first user-defined field in a row in one of the base tables and a row in the other of the base tables comprising: dependence defining means in the data dictionary for defining the dependence; and means in the operational means responsive to the dependence defining means for reestablishing the dependence as defined in the dependence defining means whenever a data base operation alters the row.
Claim 3
Dependent Claim
50 words
In the dependence-maintaining means of claim 1 and wherein: the dependence defining means further includes condition defining means for defining a condition to which the dependence is subject; and the dependence reestablishing means is further responsive to the condition defining means and reestablishes the dependence as determined by the condition.
Claim 4
Dependent Claim
107 words
In the dependence-defining means of claim 2 and wherein: the condition defining means includes executable condition code for testing whether the condition exists and result indicating means for indicating the result of an execution of the condition code and the dependence reestablishing means responds to the condition defining means by executing the condition code before altering the row, determining a first result from the result indicating means, altering the row, again executing the condition code, determining a second result from the result indicating means, comparing the first and second results, and reestablishing the dependence when the comparison indicates that the alteration of the row affected the condition.
Claim 5
Dependent Claim
60 words
In the dependence-maintaining means of claim 1 and wherein: the one base table is referenced by the other base table; the dependence-defining means defines the user-defined field as containing an aggregate value representing a characteristic of certain rows in the other base table; and the dependence reestablishing means recomputes the aggregate value whenever a data base operation changes the characteristic.
Claim 6
Dependent Claim
20 words
In the dependence-maintaining means of claim 4 and wherein: only the dependence-reestablishing means changes the value of the user-defined field.
Claim 7
Dependent Claim
51 words
In the dependence-maintaining means of claim 4 and wherein: the dependence defining means further includes condition defining means for defining a condition to which the dependence is subject; and the dependence reestablishing means is further responsive to the condition defining means and recomputes the aggregate value as determined by the condition.
Claim 8
Dependent Claim
108 words
In the dependence-defining means of claim 6 and wherein: the condition defining means includes executable condition code for testing whether the condition exists and result indicating means for indicating the result of an execution of the condition code and the dependence reestablishing means responds to the condition defining means by executing the condition code before altering the row, determining a first result from the result indicating means, altering the row, again executing the condition code, determining a second result from the result indicating means, comparing the first and second results and recomputing the aggregate value when the comparison indicates that the alteration of the row affected the condition.
Claim 9
Dependent Claim
38 words
In the dependence-maintaining means of claim 7 and wherein: the aggregate value is a count of the certain rows; and the dependence reestablishing means recomputes the count by incrementing or decrementing the count as indicated by the comparison.
Claim 10
Dependent Claim
67 words
In the dependence-maintaining means of claim 7 and wherein: the aggregate value is a sum of the values of a second user-defined field in each of the certain rows; and the dependence reestablishing means recomputes the sum by adding the difference between the value of the second user-defined field before the alteration and the value of the second user-defined field after the alteration to the aggregate value.
Claim 11
Dependent Claim
32 words
In the dependence-maintaining means of claim 6 and wherein: the value of the condition is dependent on the value of a second user-defined field in the rows of the other data base.
Claim 12
Dependent Claim
26 words
In the dependence-maintaining means of claim 6 and wherein: the value of the condition is dependent on a value defined by the relational data base system.
Claim 13
Dependent Claim
39 words
In the dependence-maintaining means of claim 4 and wherein: the aggregate value is a count of the certain rows; and the dependence reestablishing means recomputes the count whenever a data base operation changes the number of the certain rows.
Claim 14
Dependent Claim
56 words
In the dependence-maintaining means of claim 4 and wherein: the aggregate value is a sum of the values of a second user-defined field in each of the certain rows; and the dependence reestablishing means recomputes the sum whenever a data base operation changes the value of the second user-defined field in any of the certain rows.
Claim 15
Dependent Claim
80 words
In the dependence-maintaining means of claim 1 and wherein: the one base table is referenced by the other base table; the dependence defining means defines a copydown field in each row of the other base table as containing a copy of the current value of the user-defined field; and the dependence reestablishing means copies the current value of the user-defined field into the copydown fields of the rows whenever a data base operation changes the value of the user-defined field.
Claim 16
Dependent Claim
20 words
In the dependence-maintaining means of claim 14 and wherein: only the dependence-reestablishing means changes the value of the copydown field.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1993-04-16 | 1993-10-16 | 1994-04-17 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 1997-04-16 | 1997-10-16 | 1998-04-17 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2001-04-16 | 2001-10-16 | 2002-04-17 | $7700.00 | Window Closed / Lapsed |