A transaction is a series of one or more operations on
database-related objects, data, or both.
Transactions provide the following benefits:
- Ensure integrity among multiple operations by allowing all or
none of the operations to take effect. You accomplish this by starting
a transaction, performing operations, and then executing either a
commit or a rollback (also called an abort).
- Provide a means of canceling completed work for a series of operations
that fail before finishing.
- Provide a consistent view of data to users, in the midst of changes
by other users. The combination of create and delete transaction IDs
associated with each data row plus IBM® Netezza® internal
controls ensure that after a transaction begins, new transactions
or ones that have yet to be committed do not affect the view of the
data.