Method for using an index as a workspace for deferred enforcemen

Details Method for using an index as a workspace for deferred enforcemen Method for using an index as a workspace for deferred enforcemen

1996-03-08

2000-08-15

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707201, 364554, G06F 1730

Patent

active

061050253

ABSTRACT:
The present invention provides a uniqueness-required index and a corresponding non-uniqueness count to support deferred uniqueness constraint enforcement. A uniqueness-required index stores duplicate occurrences of indexed data values that occur during statement or transaction processing. The non-uniqueness count associated with the uniqueness-required index provides a count of the number of indexed data values that occur more than once in the index. Where a non-uniqueness count is not equal to zero, a uniqueness constraint violation remains unresolved. Where an unresolved constraint violation exists at enforcement time, the effects of the processing are removed. A currently non-unique count can be used to represent the number of uniqueness-required indexes that are "currently non-unique". The currently non-unique count can be examined to determine whether there are any unresolved uniqueness constraint violations. Constraints can be enforced at the end of the processing of a statement, a transaction, or within a transaction at a savepoint.

REFERENCES:
patent: 4325120 (1982-04-01), Colley et al.
patent: 4498145 (1985-02-01), Baker et al.
patent: 4947320 (1990-08-01), Crus et al.
patent: 5133068 (1992-07-01), Crus et al.
patent: 5179660 (1993-01-01), Devany et al.
patent: 5386559 (1995-01-01), Eisenberg et al.
patent: 5440738 (1995-08-01), Bowman et al.
patent: 5495601 (1996-02-01), Narang et al.
patent: 5542078 (1996-07-01), Martel et al.
patent: 5551027 (1996-08-01), Choy et al.
patent: 5659728 (1997-08-01), Bhargava et al.
patent: 5696960 (1997-12-01), Bhargava et al.
patent: 5701454 (1997-12-01), Bhargava et al.
patent: 5717924 (1998-02-01), Kawai
patent: 5734592 (1998-03-01), Cox et al.
Paulley et al. "Exploiting Uniqueness in Query Optimization", Data Engineering, Proceedings of 1994 IEEE 10th In't Conf. on Data Engineering, p. 68-79, Feb. 1994.
Rennhackkamp, Martin "Unconventional Referential Constraints", DBMS, v6, n9, p. 55(6), Aug. 1993.
Bobrowski, Steve "Enforcing Data Integrity", DBMS, v6, n5, p. 67(4), May 1993.
Lunt et al. "The Seaview Security Model", IEEE Transactions on Software Engineering, v16, n6, p. 593-607, Jun. 1990.
Benedusi et al. "Maintenance and Prototyping at the Entity-Relationship Level: a Knowledge-Based Support", Software Maintenance, 1990 Conference, p. 161-169.

Affiliated with

Also associated with

Rating

Method for using an index as a workspace for deferred enforcemen does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for using an index as a workspace for deferred enforcemen, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for using an index as a workspace for deferred enforcemen will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2018259