数据库系统概念中文课件第2章.ppt

*/70 The Power of Recursion 递归的威力 cp99 有些查询，涉及传递闭包，必须用递归或迭代才能表达This can give only a fixed number of levels of managers Computing transitive closure 下页 最后结果称为 不动点 fixed point Rcursive views 需要单调性， 才收敛。 */70 Example of Fixed-Point Computation 不动点cp99 */70 Advanced SQL Features** 高级特征 cp101 Like （简单好用） Create a table with the same schema as an existing table: create table temp_account like account 迭代语句（能力强） select C.customer_name, num_accounts from customer C,  lateral (select count(*)  from account A  where A.customer_name = C.customer_name ) as this_customer (num_accounts ) */70 Advanced SQL Features (cont’d) 高级特征cp101 批处理 Merge construct allows batch processing of updates. Example: relation funds_received (account_number, amount ) has batch of deposits to be added to the proper account in the account relation merge into account as A using (select * from funds_received as F ) on (A.account_number = F.account_number ) when matched then update set balance = balance + F.amount */70 本章小结 Chapter 4: Advanced SQL SQL Data Types and Schemas Integrity Constraints Authorization Embedded SQL Dynamic SQL Functions and Procedural Constructs** Recursive Queries** Advanced SQL Features** */70 Any Question ? Thank you !!! 电子教案 under-developing . 请同学及时反馈意见（速度，内容，详略），以便改进 */70 ODBC 中间件，连接件 cp90 Open DataBase Connectivity(ODBC) standard standard for application program to communicate with a database server. application program interface (API) to open a connection with a database, 开放式连接 send queries and updates, 传送查询和更新 get back results. 得到结果 Applications such as GUI, spreadsheets, etc. can use ODBC */70 ODBC (Cont.) 2 cp90 Each database system supporting ODBC provides a “driver” library that must be linked with the client program. 支持ODSC的软件厂商提供自己的驱动程序 When client program makes an ODBC API call, the code in the library communicates with the server t