cplusDBAction 4.2 Copyright addoit GmbH 2009
As you can
see in Picture 1: DBMS
Architecture, there is no tight coupling between the user (mostly
programs/database layers) and DBMS (Database Management System). These two
mostly communicate over a channel like TCP sockets or pipes, sending pure SQL
sequences like DML, DQL and DDL. Most of these sequences are runtime generated.
Because the SQL sequences are not a part of the command set of the C++
language, they will only be interpreted and executed on the DBMS. A C++
compiler cannot parse the SQL sequences at compile time because they consist of
simple string data (characters).
The
software developer has the responsibility to keep the RDBMS (Relational
Database Management System) schema synchronized with his database access layer.
Every change of the DB schema requires efforts from the software developer as
well as from the QA department in order to ensure that none of the older and
obsolete DDL, DQL and DML statements are sent to the DBMS.
Picture 1: DBMS Architecture
Related Topics