1. What architectural components and subsystems comprise a modern RDBMS, and how do these components interact to support key functionalities such as query optimization, transaction management, indexing, and storage management across diverse workload types and access patterns ?