These implementations mostly support communication over network protocols. MySQL supports connectors for Java (JDBC), PHP, Python. There are also vendor specific database connectors for an RDBMS such as MySQL. The Open Database Connectivity (ODBC) is a well-known database connector that an application can use to connect to almost any database. Database ConnectorsĪpplications connect to the database using a set of protocols called database connectors. Regardless, the logic for query processing remains the same be it an embedded database application, network application or a standalone application. The business logic interacts with the database server via network as per requirement. Generally, in a large database application, the RDBMS server is separated from the concern on the application by hosting the server in a remote location. Sometimes the database is contained within the embedded system as a slave to the host system. In such a case the database server becomes part of the client application or vice versa. In a standalone database application client communicates with the database via programmatic interfaces. Understanding RDBMSĪn RDBMS package is typically a database server that serves multiple clients via communication pathways under the aegis of network protocol such as such as socket, pipes etc. The article provides a glimpse of what goes behind the scene when a user submits a query until the result is obtained from the database.
They form the basic architecture of the RDBMS package. Modern RDBMS has built-in facility for memory management, file buffering, network communication support etc.
The complexity is almost akin to an operating system that functions in sync with many features almost in real time. The Relational Database Management System (RDBMS) is built with numerous complex algorithms and data structure just to store and retrieve information properly.