这个命令清除整个事务表。
这些数据将初始化事务表、脏页表和打开文件表,以便它们能够用于恢复过程。
This data initializes the transaction table, dirty pages table, and open file table so they can be used in the recovery process.
Merge在数据仓库环境(etl)中特别有用,将其中的事务表合并到更大的仓库表中。
Merge is especially useful in data warehouse (ETL) environments where transaction tables are merged with bigger warehouse tables.
该系统具备多种领域知识的概念分层表示功能、事务表编制功能,实现了知识发现的基本功能。
The system is capable of the concept hierarchy knowledge representation for various domain-knowledge and of making transaction table.
只有在两条 SQL语句都能够成功更新表的情况下,事务才会得到成功调用。
This transaction can only be called successful if both SQL statements were able to update the table successfully.
注意:在清单14中,sales_fact表是通过单独一个事务填充完成的,这需要占用大量的磁盘空间来记录日志。
Note: in Listing 14, the SALES_FACT table is populated in a single transaction, which will require a large amount of disk space for logging.
TPC - c基准使用一小组事务和表来模拟一家分销企业,该企业有一个产品销售周期。
The TPC-C benchmark simulates a distribution enterprise with a product sales cycle using a small set of transactions and tables.
对于非压缩ccd表,所有事务都生成新的行。
For non-condensed CCD tables, all transactions generate new rows.
影响个别行和表的简单查询和事务,以及修改基本的字段类型可能不会产生错误。
Simple searches and transactions affecting single rows and single tables, and modification of basic field types should not cause any errors.
他们没有建立严格的事务规则,而是把数据库表推到最简,索引只用来引用,发生实际的数据库读操作的时候才施加数据过滤。
Instead of a strict transaction protocol, they made the database tables canonical and used the indexes only for references and reapplied filters to the actual database reads.
例如,按照事务日期列分段的销售表,每个月都将添加新的行来存储当月的销售数据。
For example, a sales table fragmented by transaction date column such that new rows are added each month to store current month sales data.
当出现表空间脱机以及对没有被写入硬盘的事务补偿日志记录时,就可能触发这种状态。
The state is triggered by conditions that result from a table space going offline and compensation log records for a transaction not being written.
表2描述了CICS镜像任务最后所得到的ECI调用类型和事务范围。
Table 2 describes the resulting ECI call types and the transactional scope of the CICS mirror task.
使用扩展指示符支持,单个程序可以基于一个公共键用于单个表的所有更新事务。
With extended indicator support, a single program can be used for all incoming update transactions against a single table based on a common key.
当执行大量更新时,更新之前,在整个事务期间锁定整个表(使用SQLLOCKtable语句)。
When performing many updates, lock the entire table for the duration of the transaction before updating (using the SQL lock table statement).
通过考虑这些目标,产生了表6所示的事务组合。
By combining and applying these objectives, the transaction mix shown in Table 6 was produced.
另外,应用程序间可能会发生更多死锁(因为它们都等待数量有限的表锁),这会导致事务被回滚。
Additionally, there may be more deadlocks between applications (because they are all waiting on a limited number of table locks), which will result in transactions being rolled back.
如果可能,最好对DB2事务日志和DB 2表空间使用不同的磁盘控制器。
If possible, it's even better if you are able to use different disk controllers for DB2 transaction logs and DB2 table Spaces.
Percolator通过“快照隔离”实现了遵从ACID的跨行及跨表事务,从而满足多线程在多台服务器上对文档库进行转换操作的需求。
Percolator was designed to provide cross-row, cross-table ACID-compliant transactions via " snapshot isolation" since many threads on many machines need to transform the repository.
下面的例子显示RS次要服务器上stores_demo中的customer表不可用,而且该事务已经被应用。
The example below shows that customer table in stores_demo at RS secondary server is not available and that transaction has been applied.
一旦更新完成,解锁这个表并使用logger()记录这个事务。
Once the update is completed, the table is unlocked and this transaction is logged with logger().
数据库的表和日志以及WebSphere的事务日志包括在相同的一致性分组中。
The tables and logs of the database and the transaction logs of WebSphere do need to be included in the same consistency group.
SQLAzure的基础是关系数据库模型、提供了对约束、事务、临时表以及存储过程的完整支持。
SQL Azure is based on the relational database model, complete with constraints, transactions, temporary tables, and stored procedures.
事务属性的可能值及其描述在表1中列出。
The possible values for the transaction attribute and their descriptions are provided in Table 1.
在这些情况下,当执行事务时,更新表,创建文档及IDoc。
In these cases, when transactions are executed, tables are updated, documents and IDocs are created.
这意味着如果事务最终回滚,记录将从audittable表中移除。
This means that if the transaction ends with a rollback, the record is removed from the auditTable table.
不过在这个示例场景中不支持该选项,因为Roslyn在她的Oracle实例中创建表,这意味着她没有在事务中包含表创建DDL。
For the example scenario, however, this option is disabled, because Roslyn is creating tables in her Oracle instance, which means she cannot include the table creation DDL in a transaction.
例如,假设在事务数据库中存在名为customer _ trans的表。
For example, assume you have a table called customer_trans in your transactional database.
这需要在将来自事务系统的数据加载到数据仓库表中之前,对其进行转换。
This requires that the data from the transactional system be transformed before being loading into the warehouse table.
ccd表通过关联的跟踪机制暴露数据,以便准确地描绘源表的事务历史。
CCD tables expose data with an associated tracking mechanism to accurately portray a transactional history of the source table.
应用推荐