北邮-数据库系统原理(英文)-3-15.pptVIP

* 8 * 8 * 9 * 9 * 10 * 10 * * * * * * * * * * * * * * * * * 10 * * * * * Database System Concepts - Chapter3 SQL - * A transaction is a sequence of queries and update statements on DB, executed as a single, and are started implicitly and terminated by one of commit work（提交）or rollback/abort work In most database systems, one SQL statement that executes successfully is automatically committed, and is treated as a single transaction In SQL:1999, a transaction can be defined by  begin atomic S1 S2 … Sn end For more details about transactions, refer to Chapter15 3.10.5 Transactions E.g Account_transfer transaction BEGIN_TRANSACTION read (amount_A); amount_A:= amount_A -50; if amount_A 0 then then begin print(‘insufficient funds’) ROLLBACK end else begin write (account_A ); read (amount_ B ); amount_ B := amount_ B + 50; write (amount_ B ); COMMIT T2 end /* ROLLBACK: 撤销之前对loan_A 的修改，恢复loan_A 的原值，并立即结束事务，不再执行其后的各操作 the C program is as follows EXEC SQL BEGIN DECLARE SECTION int amount; char cn; char cc; EXEC SQL END DECLARE SECTION amount := input-from-screen-by-users EXEC SQL declare c cursor for select customer-name, customer-cityfrom depositor, customer, accountwhere depositor.customer-name = customer.customer-name  and depositor account-number = account.account- number and account.balance :amount END-EXEC EXEC SQL open c END-EXEC EXEC SQL fetch c into :cn, :cc END-EXEC EXEC SQL close c END-EXEC shared variable Database System Concepts - Chapter3 SQL - * Appendix A Syntax Definition of Select Clause The Select clause is defined