Invention Grant
- Patent Title: Column constraints based on arbitrary sets of objects
- Patent Title (中): 基于任意对象集的列约束
-
Application No.: US11395652Application Date: 2006-03-31
-
Publication No.: US08214354B2Publication Date: 2012-07-03
- Inventor: Eugene Inseok Chong , Souripriya Das , George Eadon , Jagannathan Srinivasan
- Applicant: Eugene Inseok Chong , Souripriya Das , George Eadon , Jagannathan Srinivasan
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
Techniques for using arbitrary sets of objects to constrain objects in database systems. The constraint set of objects is associated with the constrained object in the database system and the database system will perform an operation which adds an object to the constrained object only if the object being added belongs to the constraint set. In a preferred embodiment, the techniques are employed to obtain constraint sets of terms from ontologies which are then used to constrain columns containing those terms. An implementation of the techniques makes a materialized view out of the objects in the constraint set and uses the materialized view to define a referential integrity constraint on the constrained column.
Public/Granted literature
- US20070233641A1 Column constraints based on arbitrary sets of objects Public/Granted day:2007-10-04
Information query