fkarfaj at imamu . edu . sa
Introduction, Centralized Architectures; Client-Server Architectures; Parallel Systems; Distributed Systems; Network Types.
Transaction Concept, Transaction State, Implementation of Atomicity and Durability, Concurrent Executions, Serializability, Recoverability, Implementation of Isolation, Transaction Definition in SQL, Testing for Serializability.
Lock-Based Protocols, Timestamp-Based Protocols, Validation-Based Protocols, Multiple Granularity, Deadlock Handling, Insert and Delete Operations
Failure Classification, Storage Structure, Recovery and Atomicity, Log-Based Recovery, Shadow Paging, Recovery With Concurrent Transactions, Buffer Management, Failure with Loss of Nonvolatile Storage, Remote Backup Systems
Getting Started with Database Administration, Creating and Configuring an Oracle Database, Starting Up and Shutting Down, Managing Processes, Managing Memory, Managing Users and Securing the Database, Monitoring Database Operations, Managing Diagnostic Data
|1||Introduction, Course Logistics||Survey|
|3||Databases and Database Users||Quiz|
|4||Database System Concepts and Architecture||Quiz|
|5||Basic SQL||SQlite||Quiz 1 Quiz 2|
|6||Basic SQL II||Exam Review|
|7||Basic SQL III||Java|
|8||Transaction Processing||Quiz 1 Quiz 2|
|9||Concurrency control protocols||Quiz 1 Quiz 2|
|11||Database Administration and security|