________ is used to ensure that the integrity of the database is maintained under any circumstances.
2
New cards
simultaneous access
Record locking prevents ________ to the same record.
3
New cards
ACID
________ stands for Atomicity, Consistency, Isolation, Durability.
4
New cards
5
New cards
What is data capture?
Data capture is the process of collecting data and inputting it into a database.
6
New cards
What are the two methods of data capture?
The two methods of data capture are manual and automated.
7
New cards
What are some examples of automated data capture methods?
Some examples of automated data capture methods are smart card readers, barcode readers, scanners, optical character recognition, optical mark recognition, magnetic ink character recognition, and sensors.
8
New cards
What is EDI?
EDI stands for Electronic Data Interchange, which is the computer-to-computer exchange of documents.
9
New cards
What is ACID?
ACID stands for Atomicity, Consistency, Isolation, and Durability, which are used to ensure the integrity of a database.
10
New cards
What is record locking?
Record locking is a technique used to prevent simultaneous access to the same record in a database.
11
New cards
What is serialisation?
Serialisation is a technique used by the database management system to prevent deadlocks from arising.
12
New cards
What is redundancy?
Redundancy is the duplication of hardware in different geographical areas to mirror every transaction that happens on the main database.