Invention Grant
- Patent Title: Database relationship constraint
- Patent Title (中): 数据库关系约束
-
Application No.: US10793526Application Date: 2004-03-04
-
Publication No.: US07873671B2Publication Date: 2011-01-18
- Inventor: Eric Lawrence Barsness , John Matthew Santosuosso
- Applicant: Eric Lawrence Barsness , John Matthew Santosuosso
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Martin & Associates, LLC
- Agent Derek P. Martin
- Main IPC: G06F7/00
- IPC: G06F7/00

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.
Public/Granted literature
- US20050198048A1 Database relationship constraint Public/Granted day:2005-09-08
Information query