| "PL/SQL User's Guide and Reference, Version 1.0," Part 800-V1.0, Oracle Corp., 1989. |
....opinion as to the value of this. 4.3 Other Multi Version Systems There are other models of multiversioning. Some commercial products maintain versions of objects but restrict Snapshot Isolation to read only transactions (e.g. SQL 92, Rdb, and SET TRANSACTION READ ONLY in some other databases [MS, HOB, ORA]; Postgres and Illustra [STO, ILL] maintain such versions long term and provide timetravel queries) Others allow update transactions but do not provide first committer wins protection (e.g. Oracle Read Consistency isolation [ORA] Oracle Read Consistency isolation gives each SQL statement the ....
.... Rdb, and SET TRANSACTION READ ONLY in some other databases [MS, HOB, ORA] Postgres and Illustra [STO, ILL] maintain such versions long term and provide timetravel queries) Others allow update transactions but do not provide first committer wins protection (e.g. Oracle Read Consistency isolation [ORA]) Oracle Read Consistency isolation gives each SQL statement the most recent committed database value at the time the statement began. It is as if the start timestamp of the transaction is advanced at each SQL statement. The members of a cursor set are as of the time of the Open Cursor. The ....
"PL/SQL User's Guide and Reference, Version 1.0," Part. 800-V1.0, Oracle Corp., 1989.
No context found.
"PL/SQL User's Guide and Reference, Version 1.0," Part 800-V1.0, Oracle Corp., 1989.
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC