Upgrade to remove ads
Only $2.99/month

Transaction Processing Systems

Terms in this set (23)

Batch processing
where transactions are not processed in real-time but collected over some period of time then processed as a group or batch.
Data integrity
this is a measure of the completeness and accuracy of the data, that is, none has been altered or lost. The data should accurately reflect the object represented.
Data mining
the process of using analysis tools to find patterns and trends in data which has been warehoused.
Data verification
a check to ensure that the data collected and stored matches and continues to match the source of the data.
Data validation
a check, at the time of data collection, to ensure that data is reasonable and meets certain criteria. Examples of this includes range checks, masks, limited lists.
Data warehousing
the process of capturing and saving a copy of a transaction database for analysis purposes.
Enterprise system
a system that performs processes central to the overall operation of an organisation.
Radio frequency identifier (RFID) tags
these are placed on or in products to enable identification and tracking during production using radio waves.
Random access
the means by which selected data items can be retrieved without accessing all the other data items, thus allowing fast access times.
Real-time processing
when transactions are processed immediately upon the event occurring.
Restore
putting back files onto a computer after some problem has downed the system.
Sequential access
where data is accessed one record at a time from the first through to the end, such as on magnetic tape.
Transaction log
a file that records the actions performed by the DBMS and stores these for all transaction processed
Transaction processing
the system whereby transactions are processed either as soon as they are entered (real-time) or at a later time (batch)
Web-based TPS
those transactions performed over the internet.
Transaction
a unit of work composed of multiple events that must all succeed or must all fail. Events perform actions that create and/or modify data
Referential integrity
ensures all foreign keys in linked tables match a primary key in the related table.
ACID
atomicity, consistency, isolation and durability.
Backup
to copy files to a separate secondary storage devices as a precaution in case the first device fails or data is lost.
OLTP
online transaction processing
Management Information System
transforms data within transaction processing systems into information to assist in the management of business operations.
Decision support systems
like MIS, provides information to managers to assist the decision-making process.
Bias
an inclination or preference towards an outcome. This unfairly influences the outcome.
THIS SET IS OFTEN IN FOLDERS WITH...