The output of our disconnected JoinRowSet object correctly parallels the data we obtained when we performed our server side database JOIN query (compare to Table 3).
非连接对象JoinRowSet的输出与我们在服务器端执行join查询得到的数据完全一致(与表3比较)。
What you see here is a join in which the inner performs database modifications.
这里您看到的是一个连接，内表在其中执行数据库修改。
Before the join begins, the database server first applies filters if there are any, and then sorts the rows for each table on the join column.
连接开始之前，如果有筛选器，那么数据库服务器首先会应用它们，然后对连接列上每个表中的行进行分类。
In the probe phase, the database server reads the other tables in the join and applies filters if any.
在探测阶段，数据库服务器将读取连接中的其他表，如果存在筛选器，就应用它们。
These maps simply join the correct place in the database to the field of the object that you require.
这些映射只是将数据库中的正确位置与您请求的对象的字段连接起来。
But before we do, this, we will demonstrate the ability of being able to disconnect from the database to perform an offline join operation.
但是在这样做之前，我们先来演示一下断开与数据库的连接然后执行离线连接操作的能力。
If there is an index on the join column, the costs will be significantly less; otherwise the database server must perform table scans for all tables, both outer and inner tables.
如果连接列上有一个索引，那么其成本会相当低；否则，数据库服务器就必须对所有表(外部和内部表)执行表扫描。
This means you can get all the benefits of typical SQL join queries without the burden of predefining their relationships in the database layer.
这意味着您能够获得典型的SQL联合查询的所有好处，但又不需要在数据库层预定义它们的关系。
As a database developer, you usually join the customer table to the contact table and treat the customer as the main table.
作为数据库开发人员，您通常将客户表与联系方式表连接，并将客户表视作主表。
Another strategy to improve the collocation of the join is to replicate smaller dimensional tables on each database partition.
改善合并并置的另一个策略是复制每个数据库分区上的较小的表。
DB2 can then choose to perform the join or subquery at the database partition where the data is stored, instead of having to move data between database partitions.
于是DB 2就可以在存储数据的数据库分区上执行连接或子查询，而不必在数据库分区之间移动数据。
When organizational changes are made or new personnel join or retire this identity database can be centrally managed and any organizational change can automatically trigger an event.
当发生组织修改或新人员加入或有人离开时，这个身份数据库能够集中管理，而且任何组织结构上的修改都能够自动地触发一个事件。
The number of rows retrieved from the outer table after the database server applies any table filters is small, and the inner table has an index that can be used to perform the join.
在数据库服务器使用所有表筛选器之后，从外部表检索出的行数将很少，而内部表具有一个可用于执行连接的索引。
The SQL JOIN statement has long been in the toolkit of database programmers, allowing you to combine the data contained in two or more relational database tables based upon a common attribute.
数据库编程人员对SQLJOIN语句的使用由来已久，通过该语句可以基于相同的属性将两个或更多关系数据库表中的数据组合到一起。
It will also make use of this same primary key to perform JOIN operations when accessing the database.
在访问数据库时，它还会利用同一主键执行join操作。
In a star join plan, the database server pushes down keys from a dimension table to filter the fact table at the same time as it builds the hash table on the dimension table.
星型连接计划中，数据库服务器在维度表中构建散列表的同时从维度表中下推键来过滤事实表。
They're considerably slower than a join on a relational database, but, as a result, it is much harder to create a query that overwhelms the data store.
这要比关系数据库上的连接慢得多，因此很难创建一个让数据存储超负荷的查询。
One big advantage of a native XML database is that it can run queries that combine (or join, in SQL parlance) information contained in multiple XML documents.
原生XML数据库一个很大的优点是，可以运行能够将包含在多个 XML 文档中的信息组合在一起的查询（或者按SQL 的说法称为联结）。
Change the Join Table separator to an underline (" _ ") and change the name of the database schema.
将JoinTable分隔符更改为一个下划线(“_”)并更改数据库模式(schema)的名称。
Later, we? Ll see how the JoinRowSet function performs the same data-combining operation that our database server side JOIN operation did.
之后我们将看到JoinRowSet函数如何执行与数据库服务器端join操作相同的数据组合操作。
Using the JoinRowSet in your applications properly can offload the stress placed upon a database server that a JOIN operation would normally impose.
通过在应用程序中适当地使用 JoinRowSet，可以减轻数据库服务器上由JOIN 操作带来的负担。
Now that we have reviewed what our JOIN operation does on the server side, let? S see how the JoinRowSet makes a JOIN possible on the client side while being disconnected from the database server.
我们已重温了JOIN操作在服务器端的行为，现在来分析joinrowset如何在断开与数据库服务器的连接的客户端执行join操作。
The join strategies employed by the database system
数据库系统所采用的连接策略。
The Oracle (+) outer and cross join syntax is directly mapped to the DB2 database product.
Oracle(+)外连接和交叉连接语法被直接映射到DB 2数据库产品。
Views in CouchDB are created on demand and can be used to aggregate, join, and report on documents in the database.
在CouchDB中可以根据需求创建视图，并使用它在数据库中聚合、连接和报告文档。
Traditional analytics and database methods are excellent at handling data that can easily be represented in rows and columns and manipulated by commands such as select and join.
在处理那些可用行和列表示且通过命令(比如select和jion)操作的数据时，传统的分析和数据库方法表现非常优秀。
To ensure the database is normalized (see Note 1), a new table SUBJECTS_SUBSCRIPTIONS will be created to join the SUBJECTS and SUBSCRIPTIONS tables.
为了确保数据库是规范化的(参见注1)，创建一个新的表subjects_subscriptions来连接SUBJECTS和subscriptions表。
Distributing both tables by hashing on their join key (pdb_id) also ensures that all atom rows for a given PDBML document are stored in the same database partition as the PDBML document itself.
通过对上述两个表的连接键(pdb_id)进行散列处理来分布两个表也能确保给定pdbml文档中所有原子行均能作为本身的PDBML文档存储在相同的数据库分区中。
In a database, three tables represent m: m relationships: the two tables you'd expect (Book and Author), and a third join table (BookAuthor).
在数据库中，用三个表表示m： m关系：前两个表您已经知道了(Book和Author)，第三个是一个连接表(BookAuthor)。
Columns in the join clauses in fact table of star schema database.
星型数据库的事实表中join子句中的列。
应用推荐