Archive | RDBMS

Debugging Transactional And Locking Issues in MySQL

Introduction Database transactions are a logical unit of work or a group of related changes executed against a database. Transactions enable us to execute reliable units of work against a database and recover in case of failures. Transactions are “all-or-nothing” i.e they enable us to either execute all changes within the logical group or have […]

Continue Reading
Database Systems & Subsytems

Architecture of a Relational Database Management System

Relational Database Management Systems (RDBMS) have been around for over 20 years. RDBMS were one of the first multi-server multi user systems developed. Although a number of alternatives exist an RDBMS is still widely used. It is still the de facto storage engine for most applications. RDBMS have greatly evolved over the past 30 years. […]

Continue Reading