Multi-version Concurrency Control (MVCC)
ElevateDB has multiple ways to manage processes and locking independent of the user. Row locks and table locks have different protocols. When getting a row for updating, the set protocol is pessimistic and locks that row. Optimistic locking protocol can be used when the row changes are sent back to the table and thus the row needs to be locked.
Row locks are not used until the row is inserted if the transaction takes the action. Updating or deleting the row will only be allowed if the row targeted is not in use.
TEDBSession, TEDBEngine, TEDBTable, TEDBDatabase, TEDBScript, TEDBStoredProc, and TEDBQuery are all components. Users can create sessions (both local and remote), configure, and then access a path in the database to a catalog. The catalog contains tables, constraints, and functions.
https://www.elevatesoft.com/products?category=edb
https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=starting_configuring_server
Elevate Software, Inc.
2006