Commit (data management)
In the context of computer science and data management, commit refers to the idea of making a set of tentative changes permanent. A popular usage is at the end of a transaction. A commit is the act of committing.
A COMMIT statement in SQL ends a transaction within a relational database management system (RDBMS) and makes all changes visible to other users. The general format is to issue a BEGIN WORK statement, one or more SQL statements, and then the COMMIT statement. Alternatively, a ROLLBACK statement can be issued, which undoes all the work performed since BEGIN WORK was issued. A COMMIT statement will also release any existing savepoints that may be in use.
In terms of transactions, the opposite of commit to discard the tentative changes of a transaction, a rollback.
See also
- Two-phase commit
- Atomic commit
References
- Transaction Processing Concepts and Techniques This course covers both the theoretical and pragmatic issues addressed by transaction processing systems. The premise of the course is that RPC is the key
- HP TransactionVision software - HP - BTO Software HP TransactionVision software provides business transaction monitoring that dramatically increases visibility into your customer-facing transactions.
- P of EAA: Transaction Script Most business applications can be thought of as a series of transactions. A transaction may view some information as organized in a particular way,
- Administrative Simplification: Transactions and Code Sets Do you have questions about the final transactions rule? About interpretation of final rule on transactions and code sets - Click below!
- TransAction Translators Limited-Certified Translation-Certified TransAction Translators Limited - Certified Translation, Certified Translator, English Translation, French Translation, German Translator.
- Transaction Control This article describes how to run local and distributed transactions in your Microsoft .NET applications.
- Database transaction - Wikipedia, the free encyclopedia A database transaction is a unit of interaction with a database management system or similar system that is treated in a coherent and reliable way
- Transaction Point TransactionPoint® the most powerful transaction management platform in the industry.
- Transaction World Magazine Official Web Site Washington Outlook:. Raised Transaction Volume = Raised Caution by Jim Romeo by Julie Miller. Transaction World Magazine, © 2000-2007. All Rights Reserved.
- Transaction Class (System.Transactions) Transactions namespace provides both an explicit programming model based on the Transaction class, as well as an implicit programming model using the
- Transaction Fees - PayPal PayPal lets you send money to anyone with email. PayPal is free for consumers, and works seamlessly with your existing credit card and current account.
- Skipjack Financial Services Skipjack Transaction Network. Skipjack offers a wide range of pre-built and custom online payment solutions for merchants of all sizes across dozens of
- Electronic Transaction Consultants Corporation · Toll System Electronic Transaction Consultants Corporation (ETC Corporation) is the toll industry’s most comprehensive resource for system integration, design,
- eBay Help: Transaction Problems and Protections Top Questions about Transaction Problems and Protections. 1. I didn't receive an item I paid for. Does eBay offer insurance?
- [RESOLVED] Transaction history unavailable. « Official Linden Blog The transaction history on the website is currently unavailable. The data is not lost, but only unavailable on the webpage. The technicians are currently
- Java Transaction API (JTA) JTA specifies standard Java interfaces between a transaction manager and the parties involved in a distributed transaction system: the resource manager,
