决定服务器锁锁定数据库的锁方案。
Locking scheme that determines which server locks which database.
在这种情况下，锁定数据库记录有优点也有缺点。
Having the database records locked in this case is a good thing and a bad thing.
根据研究需要进行数据清洗，获得804例患者的临床信息，锁定数据库。
Data were screened according to the requirements of the study, finally the clinical information of 804 cases was selected, and then the database was locked.
尽管如此，锁定数据库也可能是不好的事情，因为，打个比方，waldo夫人不能存取款。
However, having the database records locked is also a bad thing, because, for example, Mrs. Waldo can't access the money.
这样，您将能够存档或删除这些记录，而不必锁定数据库的活动实例表中的数据。
This allows you to archive or delete these records without having to lock the data in the active instance tables of the database.
与图1类似，事务 1（TX1）在读balance值 1000 时并没有锁定数据库的行。
Similar to Figure 1, Transaction 1 (Tx1) reads the balance value as 1000 without locking the row in the database.
尤其是有一两千万行数据的时候，每次修改模式、往数据库中添加索引都会数小时完全锁定数据库。
In particular, making schema changes or adding indexes to a database with more than 10-20 million rows completely locks the database for hours at a time.
如果MD b以事务的方式锁定资源(例如，它可以锁定数据库行)，则在批结束之前，这些资源将保持锁定。
If the MDB locks resources transactionally (for example, it may lock a database row), these resources will not become unlocked until the end of the batch.
在数据库中锁定数据有两个模型。
为了确定数据库中的哪些表具有页面级锁定以及需要修改为行级别锁定，我使用了一段sql脚本：genlockmod . sql(参见清单1)。
To determine which tables in a database have page-level locking and need to be modified to row-level locking, I use a helpful SQL script: genlockmod.sql (see Listing 1).
为了确定数据库中的哪些表具有页面级锁定以及需要修改为行级别锁定，我使用了一段sql脚本：genlockmod . sql(参见清单1)。
To determine which tables in a database have page-level locking and need to be modified to row-level locking, I use a helpful SQL script: genlockmod.sql (see Listing 1).
应用推荐