Any RDBMS must have the software mechanisms to achieve the following important requirements of an information management system :
-
Data must be read and modified in a consistent fashion
-
Data concurrency of a multi-user system must be maximized
-
High performance is required for maximum productivity from the many users of the database system
|
Concurrency control - simultaneous access of the same data by many users
-
must ensure data integrity for concurrent updates, inserts, deletes and queries of the same data from many users
-
as little interference as possible among concurrent transactions must be achieved and destructive interactions must be prevented.
|
|
Oracle resolves such issues by using various types of locks and a multi-version consistency model based on the concept of a transaction
|
