Data processing: database and file management or data structures – Database design – Database and data structure management
Reexamination Certificate
2011-01-18
2011-01-18
Mofiz, Apu M. (Department: 2161)
Data processing: database and file management or data structures
Database design
Database and data structure management
C707S803000, C707S804000
Reexamination Certificate
active
07873671
ABSTRACT:
According to the preferred embodiments, a database relationship constraint is defined for a first column that specifies a set of allowable values for the first column that depend on a set of data values in a second column that may be of a different type than data in the first column. In a first embodiment, a database relationship constraint specifies allowable values for one column in a database table based on one or more data values in a different column in the same database table. In a second embodiment, a database relationship constraint specifies a set of allowable values in a first column based on one or more data values in a second column in a different database table. In both cases, the data in the second column may be of a different type than data in the second column.
REFERENCES:
patent: 5680614 (1997-10-01), Bakuya et al.
patent: 6351742 (2002-02-01), Agarwal et al.
patent: 6463429 (2002-10-01), Geppert et al.
patent: 7171408 (2007-01-01), Zuzarte
patent: 7272591 (2007-09-01), Ghazal et al.
patent: 2003/0078923 (2003-04-01), Voss et al.
patent: 2005/0131913 (2005-06-01), Barsness et al.
Oracle, Data Integrity, 1996, pp. 1-16.
Carole Goble, Integrity Constraints in Oracle 8i, Feb. 23, 2001, pp. 1-7.
Advance Table Techniques, pp. 1-11.
“Constraints and Triggers”, pp. 1-3, http://www.cs.toronto.edu/db/courses/db2/constraints.html.
US patent application filed Dec. 11, 2003, U.S. Appl. No. 10/733,752; “Database Range Constraint that is Dynamically Limited by Data in the Database”.
Barsness Eric Lawrence
Santosuosso John Matthew
International Business Machines - Corporation
Martin Derek P.
Martin & Associates LLC
Mofiz Apu M.
Nguyen Cindy
LandOfFree
Database relationship constraint does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Database relationship constraint, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database relationship constraint will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2671365