Transaction processing

Suppose several people are simultaneously trying to reserve the last few seats on an aeroplane, what could happen?

What can be used to transfer data between computer systems?

What are the potential problems with manual data entry?

What is a single logical operation in a database known as?

• Transaction

• operation
• transaction
• command

How do we search, filter and retrieve data stored in a database?

What does ACID stand?

What is the purpose of ACID in a database?

• The purpose of ACID in a database is to ensure reliable processing of transactions and maintain data integrity.
• To store data in a non-volatile format.
• To allow multiple users to edit the same data simultaneously.
• To improve database speed and performance.

What are the potential issues with a multi user database? Give an example in your answer.

​ (a)   ensures that ​ (b)   do not overlap in time and therefore cannot ​ (c)   with each other or lead to updates being lost. Serialisation techniques include: ​ (d)   ordering and ​ (e)   ordering

• Serialisation
• transactions
• interfere
• Timestamp
• Commitment
• Commencement
• Time Critical
• Adjust
• Records

Describe the technique used for time stamp ordering: