但真正的数据库应用程序通常具有多个相关表。
But real database applications usually have multiple interrelated tables.
“相关表的比率”列中指定信息。
确认了已成功创建了相关表后,请在完成对话框上单击ok。
After checking that the tables were created successfully, click OK on the completion dialog.
“相关表的比率”列将自动填充这两个表之间的当前比率。
Ratio to Related table column is filled automatically with the current ratio between the tables.
“相关表”列,再单击向下箭头,然后单击要指定比率的表。
Related table column, click the down arrow, and then click the table to which you want to specify a ratio.
记住,触发器是与表相关的,所以我们需要选择相关表的模式。
Remember, triggers are associated with tables, so we need to choose the schema of the associated table. Again go ahead and choose the DB2ADMIN schema
映射与前面的关联很相似;你将找到一个与每一个类同名的相关表。
The mapping is quite similar to the previous relation; you will find a table corresponding to each class with an identical name.
更重要的是,您知道当对相关表执行DML操作时这些规则如何保护数据完整性吗?
More importantly, do you know how these rules work to safeguard data integrity when DML operations are performed against tables that are related?
注意:在分析数据库中,规则执行或列分析过程中创建的相关表是不能自动移动的。
Note: the associated tables that are created during the execution of rules or column analysis in the analysis database are not moved automatically.
用于创建新Flight的搭建的HTML页面为所有的相关表提供了组合框,如图1所示。
The scaffolded HTML page for creating a new Flight, shown in Figure 1, offers combo boxes for all of the related tables.
OLTP查询中很少需要选择查找表作为需要相关表上的索引来支持联接的主查询表。
It is rare in an OLTP query for the lookup tables to be selected as the primary query tables requiring an index on the dependent table to support the join.
在数据库关系图内,每种关系都带有三种不同的功能出现:终结点、线型和相关表。
Within a database diagram, each relationship can appear with three distinct features: endpoints, a line style, and related tables.
但是在您定义RI时,要记住,当对相关表执行dml操作时,需要一些规则来保护数据完整性。
But when you define ri constraints, keep in mind that there are rules in place to safeguard data integrity when DML operations are performed against related tables.
文中介绍了API井底温度的数据采集方法和新的API注水泥、挤水泥温度相关表。
API data collecting method of bottom temperature and a new table of cementing and squeeze cementing temperature were recommended in this paper.
在数据库建模方面,遵循本系统预计实现的功能选择数据库相关表的字段,从而实现三维堆场的驱动。
In aspect of database modeling, the fields of tables have been selected according to function of visual yard, in order to drive 3d yard.
默认情况下,相关表通过使用内部联接进行联接,该内部联接基于包含联接列中匹配信息的行创建结果集。
By default, related tables are joined using an inner join that creates a result set based on rows containing matching information in the join columns.
数据库为一个表格的主键生成值(通过扩展,为相关表生成外主键),从而将程序从这项任务的重担中解放出来。
Having the database generate values for the primary key for a table (and by extension, any foreign key values for related tables) eliminates the burden from the application from having to do so.
注意,按键值相关的表可以嵌套,如清单5中所示,或者由嵌入在文档中的链接引用为相关表名称上的属性。
Note that tables related by key can be nested, as in Listing 5, or referenced by a link embedded within the document as attributes on the related table name.
设计器同时也产生一个填充查询,它封装了查询相关表的Select语句并且在类型化数据集中以同名方法实现。
The designer also generates a Fill query, which wraps the table's SELECT statement and is implemented as a method of the same name on the typed DataSet.
引用完整性是一种规则体系,这些规则可确保相关表中各行间关系的有效性,并确保不会意外删除或更改相关的数据。
Referential integrity is a system of rules that ensure relationships between rows in related tables are valid and that you do not accidentally delete or change related data.
为了准确采集井底温度,API于1984年成立了一个由13个固井专家组成的研究小组,经8年研究建立了新的注水泥温度相关表及温度测量方法。
A new table relating cementing temperature and a new temperature measuring method were established by an API group of 13 cementing experts organized in 1984 through 8 year continuous efforts.
一个业务术语表不但应该包含商定的数据元素定义,还应该包含与这个元素相关联的任何变体或依赖项。
A business glossary should contain not only the agreed-upon definition for a data element, but any variations or dependencies associated with that element.
尝试使用每个框架特有的方法与相关的表进行交互。
Try to use each frameworks particular way of interacting with related tables.
在将相关的表组成一个逻辑单位时,会用到模式。
如果计费系统事实表包含项目数量、支付的金额、到期金额,其相关的维度表可能包含产品信息、客户信息、以及时间或日期信息。
If a billing system fact table contains item quantity, amount paid, and amount due, its related dimension tables might include product information, customer information, and time or date information.
业务流程数据库:是一种特定于部署目标的数据库,缺省名称是BPEDB,其中包含与业务流程编排相关的表。
Business process database: a deployment target-specific database with a default name of BPEDB, containing the tables related to business process choreography.
使用事实表的键,而不是使用相关维度表的键,是一个更有效的创建Transformer度量指标数据源的方法。
It will be more efficient to create a measures data source in Transformer that takes its keys from the actual fact table rather than from its related dimension tables.
这些异构批处理更新允许在到服务器的一次网络行程中更新所有相关联的表。
These heterogeneous batch updates enable all associated tables to be updated in one network round trip to the server.
Q:如何计算已分区表(或者任何相关的表)的表大小和索引大小?
Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
而且,需要指定与该触发器相关的表的名字。
Also, specify the table name that is associated with the trigger.
应用推荐