4.10.5 Client Server Databases

Question 1

Define Client Server Database.

Answer 1

A system that provides simultaneous access to the database for multiple clients.

Question 2

Define Commitment Ordering.

Answer 2

A type of timestamp ordering that also takes into consideration the precedence of each transaction over other simultaneous transactions.

Question 3

Define Integrity.

Answer 3

The idea of keeping a database consistent by ensuring that any changes made to data or relationships associated wintertime a table are accounted for in all the linked tables.

Question 4

Define Record Locks.

Answer 4

A technique used to prevent simultaneous access to data in a database by locking a record when it is being edited or updated. Otherwise, inconsistencies may arise in the database.

Question 5

Define Serialisation.

Answer 5

A technique used to preserve integrity by only allowing one transaction to be processed at a time on a client server database.

Question 6

Define Timestamp Ordering.

Answer 6

A technique to handle concurrent access by executing transactions from multiple users based on the value of their associated timestamp. Each transaction receives a timestamp whenever it begins.