What is commit? - Definition from Whatis.com

Definition

commit

A commit is the final step in the successful completion of a previously started database change as part of handling a transaction in a computing system.

A rollback is the undoing of partly completed database changes when a database transaction is determined to have failed.

Related glossary terms: T-SQL (Transact-SQL), SQL (Structured Query Language), Collaboration Data Objects (CDO), OLE DB (OLEDB or Object Linking and Embedding Database), container, query, ACID (atomicity, consistency, isolation, and durability), fetch, DAO (Data Access Objects)

This was last updated in September 2005

Editorial Director: Margaret Rouse

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Dig Deeper

Manage, query SQL Azure Federations using T-SQL

Can SQL Azure help you manage “big data?” SQL Azure Federations enhances traditional partitioning, says Roger Jennings. Part 1 of this two-part series looks at using T-SQL to make federated tables.
Uncovering database file information with T-SQL metadata functions

Admins can use metadata functions to reveal detailed information about SQL Server files and filegroups, including file names, IDs and file properties.
Inspecting property settings with T-SQL metadata functions

There are plenty of other uses for SQL Server 2008 metadata functions beyond just the basics. This includes the ability to view object properties, such as columns and data types.

People who read this also read...

Show me more

Do you have something to add to this definition? Let us know.

Send your comments to techterms@whatis.com

Research More Tech Terms

Search thousands of tech definitions
Browse tech definitions
Browse Alphabetically:
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z
- #

Powered by WhatIs.com

File Extensions and File Formats

File Extension and File Formats List:

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
#

Powered by WhatIs.com

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- To glean value from ‘big data’ projects, it may take more than Hadoop
  
  Organizations will have to push beyond storage requirements and basic business intelligence tools to exploit big data, according to a Gartner analyst.
- On the go the way to go? Answer lies with building mobile BI business case
  
  According to a recent Gartner survey, mobile technology is the second most important priority for CIOs in 2012, but building the business case is easier said than done.
- Basic vs. complex: Companies walk the line on analytics best practices
  
  Businesses looking to build effective business intelligence and analytics programs have to toe the line between focusing on the basics and using new technology to build more complex BI systems.
Data Center
- Optimize data center virtualization with strategic capacity planning
  
  Use strategic capacity planning to future-proof your data center's virtualization efficiency and make the most of server hardware.
- Download the High Performance Comptuing E-Zine
  
  Get exclusive access to the High Performance Computing E-Zine, produced quarterly by the independent experts and analysts at SearchDataCenter.com
- Changes to z/OS 1.13 help Java adoption and boost mainframe capacity
  
  Updates to zFS, better Java performance and tweaks to z/OSMF make IBM's z/OS 1.13 a solid release for developers.
Data Management
- People, process issues offer path to improve data quality on the cheap
  
  An emphasis on educating end users and upgrading internal processes can help enterprises fix data quality problems without dropping a ton of cash, according to analysts.
- As data demands speed up, information management tools pave road ahead
  
  New research shows data virtualization, data governance and master data management initiatives provide higher levels of satisfaction with data quality and data integration.
- Bank of America IT exec: EIM drivers key to shaping project plans
  
  Enterprise information management programs should be molded around clear business objectives, says a senior information architect at Bank of America.
DataManagement UK
- Podcast: How to craft an effective MDM strategy
  
  In this podcast interview, Andy Hayler gives advice on how to create and implement an MDM strategy that is ruthlessly focused on business value.
- Jill Dyché: CEO big data focus good news and bad news for IT
  
  Jill Dyché, a data management expert, sees CEO interest and scepticism as both an opportunity and a threat. Avoid the big data 'gotchas', and don't mistake data warehousing for big data.
- Infostrada teams up with Roambi, mobile sports analytics at Olympics
  
  Dutch media sports information provider Infostrada has teamed up with mobile BI company Roambi to create an iPhone and iPad app for the Olympics. It will predict medal counts.
Oracle
- Implementing a Hyperion system in 3 weeks -- it can be done
  
  An Oracle Hyperion system implementation in three weeks? Yes, it can be done. Communications firm Neustar implemented Hyperion in less than a month and gained efficiencies in the process.
- Las Vegas expands its Oracle business intelligence horizons for better government transparency
  
  The city of Las Vegas underwent a three-year Oracle business intelligence project to bring more data to its employees and the public. The city's IT manager explains how it happened.
- Midmarket companies find JD Edwards upgrades a good fit
  
  At some point, your JD Edwards shop will have to decide whether to switch to a different product, upgrade or stay where you are. Learn what two other organizations did when working through JD Edwards upgrades.
Content Management
- Cimarex picks Accellion enterprise collaboration platform over SharePoint
  
  Cimarex Energy replaced its SharePoint system with Accellion’s enterprise collaboration platform for secure mobile file sharing and uses it to recruit graduate geology students.
- Paper originals still needed when using a document management system?
  
  Get expert advice on whether it’s necessary to keep paper or other forms of original materials once a company implements an electronic document management system.
- Out with old: Effective records management begins with losing useless data
  
  An effective records management program is one that not only knows what to keep – but which expired data can be removed to save time and money, said consultant Randolph Kahn.
Windows Server
- How P2V tools can help you choose between Hyper-V and VMware
  
  Hyper-V or VMware? The question's not going away, but migration planning products can help you give a more informed answer.
- Why Workflow may be PowerShell v3's most important feature
  
  Your task list is about to be reborn. Our expert explains how Workflow will help you now -- and how it will help guide Microsoft in the future.
- Test your System Center 2012 knowledge
  
  What's new in System Center 2012? See how much you know about a wide variety of topics in System Center.

All Rights Reserved, Copyright 2005 - 2012, TechTarget