发明申请
US20070043783A1 Handling uniqueness constraints in a database system with versioned data
有权
在具有版本化数据的数据库系统中处理唯一性约束
- 专利标题: Handling uniqueness constraints in a database system with versioned data
- 专利标题(中): 在具有版本化数据的数据库系统中处理唯一性约束
-
申请号: US11295310申请日: 2005-12-05
-
公开(公告)号: US20070043783A1公开(公告)日: 2007-02-22
- 发明人: Sam Idicula , Nipun Agarwal , Ravi Murthy , Thomas Baby
- 申请人: Sam Idicula , Nipun Agarwal , Ravi Murthy , Thomas Baby
- 申请人地址: US CA REDWOOD SHORES
- 专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人地址: US CA REDWOOD SHORES
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A version history of each of a plurality of resources is stored in a table. The version history for each resource comprises a set of one or more values for the resource, wherein each value in the version history of a resource indicates the value that the resource had in a particular version of the resource. In response to a request to perform an operation that causes a given resource that is subject to a uniqueness constraint to have a particular value, it is determined whether the uniqueness constraint is violated based on whether any version of any resource other than the given resource has the particular value. The uniqueness constraint is determined to be violated if any version of any resource other than the given resource has the particular value. The uniqueness constraint is not violated by existence of a version of the given resource that has the particular value.
公开/授权文献
信息查询