Brief architectural overview of several RDBMS

   The following article provides brief architectural overview of several relational database management systems (Oracle 11g, Microsoft SQL Server, PostgreSQL, DB2 and MySQL) derived on the basis of different sources.

The subject of database system implementation can be divided roughly into three parts:

  • Storage management: how secondary storage is used effectively to hold data and allow it to be accessed quickly;

  • Query processing: how queries expressed in a very high-level language such as SQL can be executed efficiently;

  • Transaction management: how to support transactions with the ACID properties.