LEI为自动生成和外键表的填充提供了一个功能。
LEI provides a function for the automatic generation and population of the external key table.
这些键值可以存储在现有的数据表中或者存储在单独创建的称作外键表的表中。
These keys can be stored in an existing data table or in a separately created table referred to as the external key table.
如果为实线,则当在外键表中添加或修改行时,DBMS将强制关系的引用完整性。
If the line appears solid, the DBMS enforces referential integrity for the relationship when rows are added or modified in the foreign-key table.
如果为点线,则当在外键表中添加或修改行时,DBMS不强制关系的引用完整性。
If the line appears dotted, the DBMS does not enforce referential integrity for the relationship when rows are added or modified in the foreign-key table.
如果在键表中包含该元素,则布尔值设置成获取characters方法中的元素数据。
If the element is contained in the keys table, a Boolean is set to catch the element data in the characters method.
当使用外键时(ei列被存储在它们自己的表中),可以在外键表中找到孤立的记录并将其转化为删除存根。
When external keys are in use (ei columns stored in their own table), we are able to find the orphaned record in the external key table and turn it into a deletion stub.
对所选择的表具有外键关系的所有表——以及来自所选表的所有外键表——将会在下面的图7中被可视化的显示出来。
All tables which have foreign key relationships to the selected table — and all foreign key tables from the selected table — will be visualized in the diagram illustrated in Figure 7, following.
外键是在一张表中出现的一个或多个数据属性;它可以是另一张表的键的一部分,或者干脆碰巧就是另一张表的键。
A foreign key is one or more data attributes that appear in one table that may be part of, or is coincidental with, the key of another table.
一个分区键由在表创建时定义的一个或多个列组成。
A partitioning key consists of one or more columns defined at table creation.
可以通过在脚本中修改那些您想要查询的注册表键以及要审计的机器,非常容易地调整您的审计过程。
You can easily tailor your auditing process by modifying in your script those registry keys that you want to query, and which machines you want to audit.
在与一个数据库分区组相关联的表空间中,每个表的分区键可以确定表是否是并置的。
The partitioning key for each table in a tablespace that is associated with a database partition group determines if the tables are collocated.
如果没有列能满足作为默认分区键的条件,则表在创建后就没有分区键,也就意味着这个表不能横跨一个以上的分区。
If no columns satisfy the requirement for a default partitioning key, the table is created without one, which means the table cannot span more than one partition.
很多大型的应用程序使用键管理器方法维护所有表的代理键。
Many large applications use the key manager method to maintain the surrogate keys for all tables.
您需要根据应用程序的业务流程,确定用正确的分区键划分哪些表。
Based on your application's business processes, you need to identify which tables to partition with the correct partitioning key.
或者,IT部门不希望您在计算机中安装旧版本的浏览器或修改注册表键。
Perhaps your IT department frowns upon you installing old browser versions on your computer or tweaking the registry keys.
物理数据或键的连续性对于表扫描或键-索引扫描的速度十分重要。
Contiguity of physical data or keys is important to the speed of table scans or key-index scans.
新键将出现在表中的所有现有键的后面,默认名称为NEW_ID。
The new key will appear in the table (with the default name NEW_ID) after all existing keys.
使用扩展指示符支持,单个程序可以基于一个公共键用于单个表的所有更新事务。
With extended indicator support, a single program can be used for all incoming update transactions against a single table based on a common key.
要检查表数据的完整性,您可以在表的数据行设置索引键,并将表的数据行关联到相关的LOB。
To check integrity of table data, you can index keys to table rows, and table rows to associated LOBs.
对于TP,设计决定包括选择用作表分区键的列和分区的数量。
For TP, design decisions include selecting the column to use as the table partitioning key and number of partitions.
在DPF环境中,根据CREATEtable语句中指定的分区键,表中的每个行被分布到一个分区上。
In a DPF environment, each table row is distributed to a database partition according to the distribution key specified in the CREATE table statement.
因此,如果源表在RI关系中为父表或子表,您需要捕捉外键定义并在移动表之后重新创建它们。
Therefore, if your source table was either a parent or child in an RI relationship, you need to capture the foreign keys definition and recreate them after the table is moved.
了解关系数据库、数据模型、惟一键、主键、外键和表联结。
Learn about relational databases, data models, unique keys, primary keys, foreign keys, and table joins.
在DB 2 9.7内有一个名为admin_move_table的新例程,可用来自动更改表的分区键,同时又能保持表对读写的完全可访问性。
A new routine in DB2 9.7 named ADMIN_MOVE_TABLE allows you to automatically change the partitioning key of a table while keeping the table fully accessible for reads and writes.
当希望获得图像时,就用它的键从注册表中访存。
When you want to get an image, you fetch it from the registry using its key.
维度表需要作为主键数据的通用键;这将作为事实表的外键。
A dimension table needs a generalized key as the primary key data; this becomes the foreign key in the fact table.
表中的外键维护着组间以及组内表之间的管理。
Foreign keys within tables maintain the relationship between intra-group and inter-group tables.
辅键与其它表中的主键对应。
The secondary keys correspond with primary keys in other tables.
星型连接计划中,数据库服务器在维度表中构建散列表的同时从维度表中下推键来过滤事实表。
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.
该定义中使用的列被称为表分区键列。
The columns used in this definition are referred to as the table partitioning key columns.
应用推荐