Methods for minimizing conflicts in an optimistic concurrency database access scheme are described. The method provides users or software processes with cache copies of database records and tracks which data items in the cache copy were modified and whether they were read, or read before ever being modified. A decision is then made using this information as to whether the current transaction can be committed to the database. The inventive scheme engrafts intelligence to the commitment decision process and accommodates many transactions which prior art schemes consider as conflicting. Consequently, the inventive method increases throughput in such systems.
展开▼