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.
在与一个数据库分区组相关联的表空间中,每个表的分区键可以确定表是否是并置的。
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.
一种就是维护操作和数据仓库的键的转换表。
One is to maintain a translation table of operational and data warehouse keys.
您需要根据应用程序的业务流程,确定用正确的分区键划分哪些表。
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.
当将数据分解成多个具有外键关系的表时,这尤其重要。
This is important when data is decomposed into multiple tables having foreign key relationship.
新键将出现在表中的所有现有键的后面,默认名称为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.
TP只对那些包括表分区键列的查询有利。
TP will only benefit those queries that include the table partitioning key column.
了解关系数据库、数据模型、惟一键、主键、外键和表联结。
Learn about relational databases, data models, unique keys, primary keys, foreign keys, and table joins.
当希望获得图像时,就用它的键从注册表中访存。
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.
这些表的键通常包含人员编号。
These tables usually have a personnel number as part of their key.
通常表分区键是基于时间的列。
Usually the table partitioning key will be a time-based column.
应用推荐