Lecture #8 “Introduction into Relational Databases”

Hi there!

You can find out here of “Introduction into Relational Databases” course.

[RDBMS] Lecture #8

Themes are below.

Transactions
Database Failure
UNDO / REDO lists for Recovery
ARIES Algorithm
2-Phase commit
Savepoint
Isolation Levels
Database Locks (Intent Locks, DeadLocks)
MVCC and 2PL
Precedence Graph

Please if you have some comments / questions or remarks , just let me know about it.

Thanks!

2-phase commit 2PL protocol ACID Algoritm ARIES Autocommit Commit Data visibility Database anomalies Database locks Database log Deadlocks Dirty reads anomaly exclusive locks HA topology Intent locks Isolation levels Lost update anomaly MVCC MySQL transaction MySQL XA transaction Non-repeatable read anomaly Oracle autonomous transaction Oracle transaction Phantom reads anomaly PostgreSQL prepared transaction PostgreSQL transaction Precedence graph Read committed Read skew anomaly Read uncommitted Redo list Redo recovery Repeatable read Rollback Savepoint Serializable Serialization anomaly shared locks System failure Transactions Undo list Undo recovery Wait-Die schema Wait-For graph Warning-locking protocol Wound-Wait schema Write skew anomaly

Leave a ReplyCancel Reply

You must be logged in to post a comment.