4 years ago (2015-06-18)  Algorithm language |   First to comment  36 
post score 0 times, average 0.0

 This is the EX9 of the SSD7 practice. It is expected that the extreme guests will write a series. The update frequency will be synchronized with the 2013 level progress of the NWPU database system experimental class.Click the tab or search "SSD7" on this site to get the updated SSD7 answer.Previous Exercise: SSD7_Exam2 [Normalization, E-R Mapping]

The following uses the test results on MySql:

Part I: Test Database Transaction Submit and Rollback

Almost all commercial DBMS software will support rollback before committing the transaction, which is very useful for ensuring transaction atomic characteristics.You can use the rollback command to undo part of the operation.This part of the exercise will familiarize you with the rollback and commit commands.

Rollback.txt:

"rollback.txt:"

Part II Testing Transaction Isolation Level

PostgreSQL supports two transaction isolation levels.Complete the following exercises to familiarize yourself with PostgreSQL support for isolation levels.

Isolation.txt:

"isolation.txt"

Part III Blocking and Deadlock

problem

"Part

Deadlock.txt

"deadlock.txt"
 

This article has been printed on copyright and is protected by copyright laws. It must not be reproduced without permission.If you need to reprint, please contact the author or visit the copyright to obtain the authorization. If you feel that this article is useful to you, you can click the "Sponsoring Author" below to call the author!

Reprinted Note Source: Baiyuan's Blog>>https://wangbaiyuan.cn/en/ssd7-ex9-affairs-programming-2.html

Post comment

Style

No Comment

登录

Forget password?

您也可以使用第三方帐号快捷登录

切换登录

注册

TW