Cisco CloudCenter: Get the Hybrid IT Advantage


Definition - What does Commit mean?

In a general sense, a commit is the updating of a record in a database. In the context of a database transaction, a commit refers to the saving of data permanently after a set of tentative changes. A commit ends a transaction within a relational database and allows all other users to see the changes.

Techopedia explains Commit

When a database system confirms that data has been saved, this must be an iron-clad guarantee. If not, there is a risk of data-integrity problems, in which there is uncertainty as to whether the available data is actually correct.

While this sounds simple, the reality is that database systems must offer also a degree of fault-tolerance. This means that the data must still be saved even in case of loss of some key components, i.e. disk failure. A good database system must also recover in case of sudden power loss and still roll-back or undo all uncommitted user changes or transactions. This is usually achieved by means of logging all transactions to a special file that will then be used in case data recovery is required.

Commits also serve another important function -- they serve as the determining points at which changed data is visible to other users. Say, a client’s address is being edited in a database system. Until the transaction is saved, other users who query the same client’s data should only see the address that was there before it was edited. Once committed, the new address permanently replaces the old one on disk, and any users now querying the data now view the changed address.

Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.