luh databases

Question 1

Client server database

Answer 1

Provide databases for multiple clients, concurrent access problems

Question 2

Concurrent Access Problem solutions

Answer 2

Record Locks
Serialisation
Timestamp ordering
Commitment ordering

Question 3

Record Locks def

Answer 3

locking a record to all other users until the first user is finished. other users cannot modify or access the field until it is done

Question 4

Serialisation definition

Answer 4

Requests from others are placed in a queue and sequentially executed.

Question 5

Timestamp ordering

Answer 5

Each request is executed sequentially based on timestamps

Question 6

Commitment Ordering

Answer 6

Algorithm is used to work out optimal order of command executions. Algo minimises the issues from occurring within the DB