U.S. patents available from 1976 to present.
U.S. patent applications available from 2005 to present.

US Patent Application 20070043783 - Handling uniqueness constraints in a database system with versioned data

Application 20070043783 Filed on December 5, 2005. Published on February 22, 2007

Inventors

Assignee

US Class

707/201Coherency (e.g., same view to multiple users)

Attorney, Agent or Firm

International Class

G06F 17/30

Issued Patent Number:

7424495


Abstract text


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.

PatentsPlus Images
Enhanced PDF formats
loading...
PatentsPlus: add to cart
PatentsPlus: add to cartSearch-enhanced full patent PDF image
$9.95more info
 
Sign InRegister
Username  
Password   
forgot password?