提供行级安全。
Selective row-level audit (SRLA)
选择性行级审计(SRLA)
The first thing every contestant needed to do was change every table to row-level locking.
每位参赛者需要做的第一件事是将每个表更改为行级别锁定。
Some examples of RUNSTATS using Bernoulli row-level and system page-level sampling are as follows.
下面是一些使用贝努里(Bernoulli)行级和系统页级抽样的RUNSTATS例子。
The sampled pages are also prefetched, so this method would be faster than row-level Bernoulli sampling.
抽样页也是预取的,所以该方法将比行级贝努里(Bernoulli)抽样更快。
System page-level sampling is similar to row-level sampling, except that the pages are sampled and not rows.
系统页级抽样与行级抽样类似,除了抽样的对象是页面而不是行。
It returns the most recently committed version of the rows, even if another concurrent session holds an exclusive row-level lock.
即使另一个并发会话持有一个独占式行级锁,它仍然返回最近提交的行。
The Advanced Access Control Feature implements label-based access control (LBAC) to offer row-level and column-level protection.
AdvancedAccessControlFeature实现了基于标签的访问控制(LBAC),以提供行级和列级保护。
During an export operation, row-level locking is applied to the exporting table, which means that only one lock is held at a time.
在导出操作期间,行级别锁定应用于导出表(exportingtable),这意味着一次只持有一个锁。
WebSphere Process Server accesses its databases in multiple concurrent threads and USES row-level locking to ensure data consistency during its transactions.
WebSphereProcessServer通过多个并发线程访问其数据库,并使用行级锁定来确保其事务期间的数据一致性。
Some databases (such as SQL Server) allow you to disable the page-level locking in hopes that it won't escalate from a row-level lock to a table-level lock.
一些数据库(比如sqlServer)允许您禁用页面级锁,以期它不会从行级锁切换到表级锁。
There are little tricks one can do to increase concurrency, but if your applications need table-level or row-level locks, a DBMS will better suit your needs.
虽然有一些增加并发的技巧,但是,如果应用程序需要的是表级别或行级别的锁定,那么DBMS能够更好地满足您的需求。
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)。
This script will read the Informix system tables, find out which tables have page-level locking, and then generate another SQL script to change those tables to row-level locking.
此脚本将读取Informix系统表,找出哪些表具有页面级锁定,然后生成另一段sql脚本来将这些表更改为行级别锁定。
We can alter the matrix's "grain" or level of detail so that each row represents a single fact table (or cube) related to a business process.
我们可以改变矩阵的“粒度”或细节水平,使得每一行代表与一个业务流程相关的单个事实表(或立方体)。
After obtaining the row from the sheet, use the row to drill down to the cell level.
从工作表获取一行后,使用该行来向下钻取到单元格级别。
But the Dow Jones Industrial Average climbed back above the 9,000 level on July 23rd and London's FTSE 100 index rose for 11 trading days in a row to July 27th, equalling its best-ever run.
但道琼斯工业平均指数在7月23日时已重回9000点,伦敦富时100指数至7月27日之时,已连续11个交易日上涨,是史上最强劲的一波行情。
But the Dow Jones Industrial Average climbed back above the 9, 000 level on July 23rd and London's FTSE 100 index rose for 11 trading days in a row to July 27th, equalling its best-ever run.
但道琼斯工业平均指数在7月23日时已重回9000点,伦敦富时100指数至7月27日之时,已连续11个交易日上涨,是史上最强劲的一波行情。
But, row level sampling may produce more accurate statistics if relational data values are highly clustered.
但是,如果关系数据值是高度聚集的,那么行级抽样可以产生更精确的统计信息。
It does this by creating a compression dictionary of symbols which replace repeating data patterns at the row level.
实现方法是创建一个压缩的符号字典,取代行级重复数据模式。
Using this feature, data stewards can control read and write access for users and groups at the table column and row level.
借助这个特性,数据管理员可以在表的列和行级别控制用户和组的读写访问。
Available as a user extension (UX) in ext JS, you can now perform edits to a grid at the row level, as shown in Figure 1.
作为ExtJS中的用户扩展(UX),现在可以进行行级编辑,如图1所示。
The COUNT function is very useful to show at any level how many records make up each aggregated row in the summary table.
count函数非常有用,可以在任何级别显示汇总表中的每个汇总行由多少条记录组成。
Federated procedures with access level MODIFIES SQL DATA cannot be invoked inside triggers, dynamic compound statements, scalar, table, row functions, and methods.
在触发器、动态合成语句、标量、表、行函数和方法中不能调用具有访问级别MODIFIESSQLDATA的联邦过程。
LEVEL - the pseudo column LEVEL returns an integer value that represents the recursive step in the hierarchy at which the row was produced.
LEVEL—伪列LEVEL返回一个整数值,表示所生成行的分层结构中的递归步骤。
More database security: a new security feature called Label-Based access control (LBAC) allows you to control data access at the row and column level.
增强了数据库安全性:基于标签的访问控制(Label BasedAccess Control,LBAC)是一种新的安全特性,它使您可以在行和列的级别上控制数据访问。
The granularity of the content type is to the table level rather than the row level.
内容类型的粒度是表级别的而不是行级别的。
For MDC tables, the selection of BLOCKINSERT may improve the performance of INSERT operations by locking at the block level and avoiding row locks for INSERT operations.
对于mdc表,选择BLOCKINSERT可以提高INSERT操作的性能,因为使用的是块级的锁,避免了为INSERT操作使用行锁。
Row level sampling reads all data pages but considers only a percentage of the rows on each page, and therefore only a subset of the corresponding XDA pages.
行级的抽样读取所有数据页,但是只考虑每页上一定百分比的行,因此只包含相应xda页面中的一部分。
The second level of access control is Label-Based access control (LBAC), which can be at the row level, column level, or both.
第二级的访问控制是基于标签的访问控制(Label - Based Access Control,LBAC),这种控制可以发生在行级、列级或者同时发生在这两级。
应用推荐