在这样的情况下，对加载操作的目标表中预先存在的数据的并发访问是非常重要的。
In circumstances such as this, concurrent access to pre-existing data in target tables of load operations is very important.
如果是在一个表中，那么您必须执行一次投影操作来过滤数据。
In the case of a table, you must do a projection operation to cull the data.
在这个过程期间，操作性数据是从一个产品源中获取以作为一个XML资源，映射到关系数据表中，并在数据仓库中得到标准化。
During this process, operational data is retrieved from a product source as an XML resource, mapped to relational data tables, and normalized in the data warehouse.
记住，完全数据库恢复将要求整个恢复操作具有排它性，而表空间的联机恢复将只要求表空间处于排它模式中。
Remember, a full database restore will require exclusive use for the entire restore operation, whereas online restore of a table space will only require that tablespace to be in exclusive mode.
使数据不一致的另一个操作是直接在rdbms表中更新记录。
The other operation that can make data inconsistent is when updates on records occur directly in the RDBMS table.
如果将一列添加到正在被访问的表中，DB 2仍然可以在不更改程序代码的情况下操作数据。
If you add a column to the table being accessed, DB2 can still manipulate the data without changing the program code.
在这个例子中，如果目标和源数据表有匹配的行，就实行更新操作。
In this example, and update occurs if the target and source have matching row.
但是切记，样式表应该对入站XML的结构进行操作，而不是对文档中的特定数据进行操作。
Keep in mind, though, that the stylesheet should operate upon the structure of the incoming XML, rather than the specific data in the document.
外部表对驻留在底层操作系统中的数据文件提供一个普通的表界面。
External tables provide a normal table interface to data files that reside in the underlying operating system.
现在大型电子数据表或大型电子文件可以在光盘里读取，还可以通过快捷操作把它们放到内存中。
Now, large spreadsheets or large documents could be read in from the disk and held in RAM memory for fast access and manipulation.
表函数允许您对非实际表（不是实际上的表）中的数据有效地使用关系操作和SQL。
Table functions enable you to efficiently use relational operations and the power of SQL on data that is not in an actual table.
其他想要并发访问相同表中的数据的应用程序不需要与数据库断开连接，并且可以继续进行该表中的读或写操作。
Other applications that want to access data in the same table concurrently do not need to disconnect from the database, and are free to pursue read or write operations in that table.
如果您已经在本系列教程的第3部分或第4部分中创建了数据库和表，则无需做任何操作。
If you've created the database and tables in Part 3 or Part 4 of this series, you don't need to do anything.
如果尚未这样做，请按照第3部分中关于创建数据库和表的说明进行操作。
If you haven't, please follow instructions on creating the database and tables in Part 3.
在随后的数据流操作中，您将使用一个连接操作符确保整个XML账户记录(包含在info列中)被填充到目标数据仓库表中。
In a subsequent data flow operation, you'll use a join operator to ensure that full XML account records (contained in the INFO column) are fed into the target data warehouse table.
在这里还可以做更多操作：例如，如果数据库中不存在表，则创建表。
More can be done here: create a table, for example, if the table doesn't exist in the database.
在复制处理期间修改源模式中的表可能会导致在复制操作之后目标模式中的数据不相同。
Changes to tables in the source schema during copy processing might mean that the data in the target schema is not identical following a copy operation.
优化器的操作基于数据表中的行数、数据表或索引使用的空间以及其他信息的相关统计数据。
The optimizer ACTS based on statistical data about the number of rows in a table, the use of space by a table or index, and other information.
然而，尽管基于哈希表的数据交换很简单并且切实可行，但它只适合应用于最简单的互操作场景中。
However, while exchanging a hash table is easy and supported out of the box, it is only appropriate to use in the most simple of interoperability scenarios.
JLINQ就是通过这种方式，在选中的数据表中，为执行CRUD操作而生成基于面向对象的类和接口。
This is where JLINQ generates the OO-based classes and interfaces required to perform the CRUD operations on the selected tables.
这些操作都属于数据库中的每个表。
These are the operations that pertain to each table in the database.
在1.0样式表中如果要大量处理时间数据，可能需要执行一些调用专门命名模板的操作。
If you have 1.0 stylesheets that manipulate time-oriented values extensively, you probably have some operations that are performed by calling specialized named templates.
在生产环境中，这通常是以LDAP实现的注册表、数据库或操作系统的功能。
In a production environment, this is typically the function of a registry implemented in LDAP, a database, or an operating system.
在复制处理期间修改源模式中的表可能会导致在复制操作之后目标模式中的数据不相同。
Changes to tables in the source schema during copy processing may mean that the data in the target schema is not identical following a copy.
在这个场景中，可以使用异构更新在一个数据库操作中更新order和order_items表。
In this scenario, you could use a heterogeneous update to update the ORDER and ORDER_ITEMS table in a single database operation.
若acct表更新失败，没有任何机制可以回滚到对trade表的更新操作，从而造成数据库中的数据不一致。
Should the update to the ACCT table fail, there would be no mechanism to roll back the insert to the TRADE table, resulting in inconsistent data in the database.
DB 2设置要运行的脚本(在步骤1中或者按本系列第一篇文章中的步骤操作时)，并为DB 2数据库中的帐户组合信息创建目标表。
The DB2 set up script that you ran (either in step 1 or when following the steps in the first article of this series) created a target table for account portfolio information in your DB2 database.
我们将面临在两种选择之间进行抉择：是在一个编辑器中维护一个文档及其标记的多个副本效率高呢还是维护在同一数据上操作的多个样式表高效？
The choice becomes one of "Is it more efficient to maintain multiple copies of a document together with markup in an editor or to maintain multiple stylesheets that operate on the same data?"
配置好BdpConnection组件之后，便可以开始编写对SAMPLE数据库中的表进行select操作的SQL命令。
Once you configure the BdpConnection component, you can start to write SQL commands to select tables from the SAMPLE database.
对于Windows操作系统，将从注册表中的ANSI编码页设置推导出数据库的编码页。
For Windows operating system, the database code page will be derived from the ANSI code page setting from the registry.
应用推荐