Data processing: database and file management or data structures – Database design – Data structure types
Patent
1996-08-07
1999-05-04
Black, Thomas G.
Data processing: database and file management or data structures
Database design
Data structure types
707 10, 707104, G06F 1730
Patent
active
058999930
ABSTRACT:
A method and apparatus are disclosed for enabling a constraint without prohibiting updates to the constrained data during the validation portion of the enablement process. A constraint is first enforced. While the constraint is being enforced, the pre-existing data are inspected to determine whether the constraint is valid. Because the constraint is in force for all changes to the data during the validation process, the constraint will be enabled if the pre-existing data conforms with the constraint. A serialization value is stored in the constraint definition. Whenever the constraint definition is changed, the serialization value is changed. The serialization value of a constraint definition is recorded before validating the constraint. After validating the constraint, the serialization value in the constraint definition is compared to the recorded serialization value to determine whether the constraint definition was changed during the validation process.
REFERENCES:
patent: 5029233 (1991-07-01), Fujisaki
patent: 5133068 (1992-07-01), Crus et al.
patent: 5226158 (1993-07-01), Horn et al.
patent: 5303368 (1994-04-01), Kotaki
patent: 5386557 (1995-01-01), Boykin et al.
patent: 5446652 (1995-08-01), Peterson et al.
patent: 5485607 (1996-01-01), Lomet et al.
patent: 5517014 (1996-05-01), Iijima
patent: 5546579 (1996-08-01), Josten et al.
patent: 5551046 (1996-08-01), Mohan et al.
patent: 5577231 (1996-11-01), Scalzi et al.
patent: 5677997 (1997-10-01), Talatik
patent: 5758351 (1998-05-01), Gibson et al.
Robert Jenkins, Constraints and Oracle Server, Oracle Magazine Interactive, May 7, 1996.
Bruce M. Horowitz, A Run-Time Execution Model for Referential Integrity Maintenance.
Roberta J. Cochrane, Hamid Pirahesh, Nelson Mattos, Integrating Triggers and Declarative Constraints in SQL Database Systems, Proceedings of the 22.sup.nd International Conference on Very Large Data Bases, Bombay, India, Sep. 1996.
L. Gallagher, X3H2 SQL Change Proposal X3H2-86-164, Nov. 24, 1986, pp. 1-17.
IBM BookManager BookServer Copyright 1989, 1995 IBM Corporation; Littp://TS.adm.ilstu.edu:80/cgi-bin/bookmgr./cmd/Shelves/DSNSHOB4 (IBM DB2) (Mar. 24, 1997).
Black Thomas G.
Coby Frantz
Oracle Corporation
LandOfFree
Method and apparatus for achieving an enforced and valid constra 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 and apparatus for achieving an enforced and valid constra, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for achieving an enforced and valid constra will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1867220