Database Management Systems (Application Development)

Database Management Systems

Part 2: Application Development

Chapter 6. Database application development

embedded sql: use of SQL within a host language program (compile time)

SQL is set-oriented --> use cursors

dynamic sql: prepare and execute (run time)

ODBC, JDBC: API allow a single executable to access different DBMSs without recompilation. A driver translates ODBC/JDBC calls into DBMS-specific calls.

application, driver manager, drivers, data sources

stored procedures: CREAT PROCEDURE

Chapter 7. Internet applications

client-server architecture: thin/thick clients (part of business logic)

three-tier application architecture: data management, application logic, presentation