4.1.19. Transaction processing

  • DBMS Multiuser system
    • Multiple terminals/clients
      • Single processor, client side execution
    • Single centralised database
      • Multiprocessor, server
      • Resolving many transactions simultaneously
  • Concurrency issue
    • Coverage by previous courses (e.g. COMS12100)
    • PL/SQL scripts (Transactions) as processes
  • Interleaved execution