IPT - 4 - Transaction Processing Systems
Transaction - ANS-Unit of work composed of multiple events that must all succeed or must all
fail
Data Integrity - ANS-A measure of how correct and accurately data reflects its source. The
quality of the data
Data Validation - ANS-A check, at the time of data collection, to ensure the data is reasonable
and meets certain criteria.
Data Verification - ANS-A check to ensure the data collected and stored matches and continues
to match the source of the data
Referential Integrity - ANS-Ensures all foreign keys (keys that are a primary key in a different
table) match a related primary key. No record in the current table can exist before records can
be added to the related table
Atomicity - ANS-All events must complete successfully or none at all.
Consistency - ANS-Ensures transactions take data from one consistent state and when the
transaction completes the data is left in that state.
Isolation - ANS-Transactions must process without interfering with or being influenced by other
transactions that are currently executing
Durability - ANS-Ensures that committed transactions are permanent.
Batch Processing System - ANS-Data is collected over time and then later all transactions are
processed together without user interaction
Real-time Transaction Processing System - ANS-Complete transactions immediately once they
are initiated.
Cheque Clearance - ANS-Paper based system prior to use of computers that were the main
method of exchanging funds over long distances.
Bill Generation - ANS-The processing of multiple bill transactions all at once
Backup - ANS-To copy files to a separate secondary storage device as a precaution in case the
first device fails or data is lost.
Transaction - ANS-Unit of work composed of multiple events that must all succeed or must all
fail
Data Integrity - ANS-A measure of how correct and accurately data reflects its source. The
quality of the data
Data Validation - ANS-A check, at the time of data collection, to ensure the data is reasonable
and meets certain criteria.
Data Verification - ANS-A check to ensure the data collected and stored matches and continues
to match the source of the data
Referential Integrity - ANS-Ensures all foreign keys (keys that are a primary key in a different
table) match a related primary key. No record in the current table can exist before records can
be added to the related table
Atomicity - ANS-All events must complete successfully or none at all.
Consistency - ANS-Ensures transactions take data from one consistent state and when the
transaction completes the data is left in that state.
Isolation - ANS-Transactions must process without interfering with or being influenced by other
transactions that are currently executing
Durability - ANS-Ensures that committed transactions are permanent.
Batch Processing System - ANS-Data is collected over time and then later all transactions are
processed together without user interaction
Real-time Transaction Processing System - ANS-Complete transactions immediately once they
are initiated.
Cheque Clearance - ANS-Paper based system prior to use of computers that were the main
method of exchanging funds over long distances.
Bill Generation - ANS-The processing of multiple bill transactions all at once
Backup - ANS-To copy files to a separate secondary storage device as a precaution in case the
first device fails or data is lost.
