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

本文探讨了数据库管理系统中应用程序的开发方法,包括嵌入式SQL的使用、动态SQL的准备与执行,以及通过ODBC和JDBC实现跨不同数据库管理系统(DBMS)的应用程序开发。此外,还介绍了三层架构在互联网应用中的实现方式,涵盖了客户端-服务器架构及业务逻辑的分布。
1386

被折叠的 条评论
为什么被折叠?



