TPH: Map an Entity hierarchy to a single table.
TPH：映射一个实体层次到单表。
Listing 1 shows a schema for the single table database.
清单1显示了单表数据库的模式。
Application 1 (A1) selects rows from a single table in a cursor.
应用程序1 (A 1)在一个游标内从单独一个表选择行。
Up to this point, you have only selected columns for all rows in a single table.
到目前为止，只选择了单个表中所有行的列。
The SQL script used to build the single table for the application is in Listing 1.
用来为应用程序构建单个表的sql脚本在清单1中。
For this example, I wanted to keep the database simple, so there is only a single table.
对于本例来说，我想要让数据库尽量简单，所以数据库中只有一个表。
Users can freely mix and match storage of traditional SQL data and XML in a single table.
用户可以在一个表中自由地混合存储传统SQL数据和XML数据。
Here is an example of mapping a super class and a sub class using the single table strategy.
下面是一个使用单表策略映射超类和子类的示例。
The customer database has a single table which can be created by running the following script.
客户数据库只有一个表，该表可以通过运行以下脚本创建。
Each container can only belong to a single table space, but a table space can have many containers.
每个容器只能属于一个表空间，但是一个表空间可以拥有许多容器。
For our RIGHT hierarchy, we'll use a single table (TB_RIGHT) to store the entire class hierarchy.
对于我们的RIGHT层次结构，我们只使用一个表(tb_right)来保存整体类层次结构。
You maintain past, present, and future effective dates and their associated data in a single table.
您在一个表中维护过去、现在和未来的有效期和它们的关联数据。
The customer database has a single table that can be created by running the script shown in Listing 6.
客户数据库只有一个表，可以通过运行清单6中的脚本创建。
The database schema consists of a single table to store the Friend's information. It has three columns
数据库模式包含单个表，用于存储Friend的信息。
In the previous article (Part 2), you saw how you can pass a parameter to a single table in the report.
在前面的文章(第2部分)中，您会看到怎样向报告中的单个表格传递一个参数。
The previous example demonstrated how to modify multiple column values for a specific row in a single table.
上例演示了如何修改单个表中特定行的多个列值。
If after replacing these with a single table lock, the MAXLOCKS value is no longer exceeded, lock escalation stops.
如果用一个表锁替换这些行锁，将不再会超出maxlocks值，那么锁升级就会停止。
Figure 1 shows how to execute a scalar rule on columns that come from a single table from the analyzed data source.
图1展示了如何对来自所分析数据源的单个表中的列，执行标量规则。
Recover from single table failures or accidental table drops by extracting a single table from a backup for restoration
通过从备份中提取单个表执行恢复，可恢复单个表故障或意外的表删除
They are limited, though, in that they work on only a single table and not across multiple tables through relationships.
但它们受到限制，只能在一个表上工作，不能通过关系跨多个表工作。
Look at the simplest SQL data binding task: mapping an object that doesn't refer to any other objects to a single table.
最简单的SQL数据绑定任务：把没有引用其他任何对象的对象映射到一个表。
For a single, simple, survey, you could probably place all of the information from each question into a field in a single table.
对于单个的、简单的问卷调查，您可以将每个问题的所有信息放到单个表的一个字段中。
As a first example, consider a database schema consisting of a single table for a phone book application as shown in table 1.
看第一个简单的例子，考虑一个电话簿应用程序的由单个表组成的数据库模式，如表1所示。
Cache tables are similar to MQTs with the restriction that a cache table supports only non-aggregate queries over a single table.
缓存表类似于具有以下限制的MQT，即缓存表只支持单个表上的非聚集查询。
We can't, because the Rails model would have the meat of our object model in a single table, and that's not a realistic solution.
但我们却不能如此，因为Rails模型将会在单一表中拥有我们所有对象模型的实质内容，这不是一个可行的解决方案。
Note that here I'm just pulling data from a single table, but you can get as complex as Derby will allow in these SQL statements.
注意，在这里仅提取单个表中的数据，但是，您可以在这些sql语句中使用与Derby提供的一样复杂的功能。
It's quite typical for firms to store both relational and XML data in a single table, and our examples reference both types of columns.
公司在单个表中既存储关系数据也存储XML数据是很常见的情况，我们的示例引用了这两种类型的列。
With a UNION ALL view, you are provided information from all branches of the company as if the information were coming from a single table.
有了UNIONALL视图，就有了来自所有分公司的信息，而这些信息看起来像是在一个表中。
But our form is not limited to working within a single table; a single form can display and edit data for many tables through relation objects.
但我们的表单不仅限于在单个表中工作；单个表单可以通过关系对象为多个表显示和编辑数据。
DB2 is now a hybrid database in that it has the ability to store relational data and XML data in a single database, even in a single table.
现在的DB 2是一个混合型的数据库，因为它能够在一个数据库，甚至是一个表中储存关系数据和XML数据。
应用推荐