Skip to main content

Posts

Showing posts with the label Transaction

Introduction to Couchbase for Oracle Developers and Experts: Part 8: Transactions

Six thousand years ago, the Sumerians invented writing for transaction processing -  Gray and Reuter Transaction is a set of read and write actions consisting of Unprotected actions on the transient state outside the transaction statement scope and state (e.g. storage allocations, dictionary management) Protected change the persisted data, actions must be reflected in transaction outcome Real actions using sensors and actuators, once done, cannot be undone. Transaction Examples ORACLE Couchbase Oracle automatically starts a multi-statement transaction for every new statement. So, issuing BEGIN WORK or START TRANSACTION is unnecessary BEGIN WORK, START TRANSACTION are all synonymous and start a multi statement transaction.  – Transaction begins automatically INSERT INTO customer(cid, name, balance) VALUES(4872, “John Doe”, 724.23); INSERT INTO customer(cid, name, balance) VALUES(1924, “Bob Stanton”, 2735.48); COMMIT; START TRANSACTION; INSERT INTO customer VALUES(“cx4872”, {“c...