Update constraints in transactions which may abort
AssigneeAT&T Corp.
InventorsTimothy G. Griffin, Howard W. Trickey
Life of this patent
Estimating the term…
Abstract
A technique which may be used in a transaction which updates a data set when the data set is subject to constraints and includes operations which may abort. The technique produces an update constraint which may be tested before the data set is altered to determine whether the constraints will be satisfied if the data set is altered. The update constraint of the technique indicates whether the constraints would be satisfied if the transaction could not abort. The update constraint is checked at the application level, while the constraints which cause an operation to abort are checked at the system level. An application of the update constraint to a relational data base embedded in a telephone switch is disclosed.
Claims10
Apparatus for generating code for a transaction on a set of data, the transaction being subject to constraints and the apparatus comprising:
- a transaction description which describes operations performed in the transaction, the operations including at least one operation which may abort without affecting the set of data;
- a constraint specification which specifies the constraints to which the transaction is subject;
- and
- code generating means responsive to the transaction description and the constraint specification for generating the code, the code generating means including
- means for generating code for an update constraint which indicates whether the constraints would be satisfied if the transaction could not abort and which is executed prior to any operation which may abort.
A method of making apparatus for performing a transaction on a data set, the transaction being subject to constraints and involving an operation which may abort,
- the method comprising the steps of:
- computing from the constraints and a description of the transaction which describes Operations of the transaction an update constraint which indicates whether the constraints would be satisfied if the transaction could not abort;
- and
- generating code which is executed during the transaction and which determines whether the update constraint is satisfied.
A method of performing a transaction on a set of data which alters the set of data, the transaction being subject to constraints, the method including the step of altering the data, and the step of altering the data involving an operation which may abort,
- the method having the improvement comprising the step of:
- prior to performing the step of altering the set of data, testing an update constraint which, when satisfied, indicates whether the constraints would be satisfied if the transaction could not abort, and not altering the set of data if the update constraint is not satisfied.
A data base system for performing transactions on a set of data, the transactions being subject to constraints and the data base system including means for updating data, the means for updating data performing an operation which may abort without affecting the set of data, and the database system having the improvement comprising:
- means for ensuring integrity of the set of data by testing an update constraint which, when satisfied, indicates that the constraints would be satisfied if the operation could not abort and indicating to the means for updating whether the update constraint is satisfied,
- the means for updating altering the set of data only if the update constraint is satisfied.
Dependencies are inferred from the claim text.