Client-Server Databases

• What does a client server database system provide?

  Simultaneous access for multiple clients
• How can concurrent access be controlled in a database?

  To preserve the integrity of the database
• What is server-side scripting?

  Instructions executed on the server
• What is client-server database architecture?

  A structure with many clients connected to a server
• What does DBMS stand for?

  Database Management System
• What is a concurrent request?

  Multiple requests made at once by users
• What can happen if concurrent requests are not handled appropriately?

  Updates can be lost
• What are the methods to control concurrent requests?


  • Record Locks: Locks data for write access
  • Serialisation: Allows one transaction at a time
  • Timestamp Ordering: Uses timestamps for transactions
  • Commitment Ordering: Prioritizes commands based on timing
• What is the purpose of record locks?

  To prevent other users from saving data
• What does serialisation ensure in a database?

  Transactions occur one at a time
• Who manages serialisation in a database?

  The Database Management System (DBMS)
• What does timestamp ordering indicate?

  The order transactions occurred in
• What do read and write timestamps represent?

  The last time a record was accessed
• What is the purpose of commitment ordering?

  To determine command priority and timing
• How does commitment ordering affect command execution?

  It considers priority and timing