索引下推使用下推键执行事实表外键索引的查询。
An index pushdown USES the pushed-down keys to perform index lookups on a foreign key index of the fact table.
但更大的麻烦是表外养老金和OPEB债务投下的巨大阴影。
But the bigger problem is the giant shadow cast by the pension and OPEB liabilities that are absent from balance sheets.
再者,与次贷危机相并行的,抵押贷款债券资产被储存在负债表外的合资企业。
Again, there are parallels with the subprime crisis, where mortgage-backed securities were warehoused in off-balance-sheet ventures.
在银行放贷增长的同时,通常由银行创办的表外管道所发行的商业票据却减少了。
That rise has come at the same time as a fall in commercial-paper issuance by off-balance-sheet conduits typically sponsored by Banks.
欧洲中央银行(ECB)是动作最快的,进行了几次在时间表外的“微调”动作。
The European Central Bank (ECB) was quickest to respond, with the first of a series of unscheduled “fine-tuning” operations.
正如惠特尼所示,这些表外数据难以置信地达到了所有表内总负债的三倍,总计2万亿美元。
As Whitney shows, these off-balance sheet numbers are an incredible three times the size of all on-balance sheet debt, totaling $2 trillion.
可是不然,一旦你算上了资产负债表外的放贷,2010年的总放贷量与2009年基本持平。
Instead, once you add in off-balance-sheet lending, the total for 2010 will be essentially unchanged from 2009.
这是第一次,巴塞尔iii将引进一个新的国际通用的杠杆率要求,包括金融机构资产负债表外的义务和风险暴露。
For the first time, Basel III will also be introducing a new, internationally applied, leverage ratio requirement that includes firms' off balance sheet commitments and exposures.
因此,如果源表在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.
创建了表、主键、外键,和索引。
Created the tables, primary keys, foreign keys, and indexes.
例如,日期表的外键对于一个文档的每个关键词不会重复。
For example, the foreign key to the date table is not repeated for every keyword of a document.
运行rakedb:migrate以创建SUBSCRIPTIONS表并将外键列添加到SUBJECTS 中。
Run rake db:migrate to create the SUBSCRIPTIONS table and add foreign key columns to SUBJECTS.
它们由逻辑数据模型转换而来,其中实体和关系转换为表、列、主键、外键以及约束。
They are transformations of logical data model where the entities and relationships are transformed into tables, columns, primary keys, foreign keys, and constraints.
如果使用的是MySQL,而且想要为表定义外键,则需要在从数据库中加载模式之后,编写代码定义这些字段。
If you're using MySQL and want to define foreign keys for a table, you'll need to define those fields in code after loading the schema from the database.
事实表可以根据一或多个外键过滤。
The fact tables can be filtered on one or more of their foreign keys.
给 Transformer建模师提供事实表中发现的外键。
Expose foreign keys found in fact tables to Transformer modelers.
通过在将fact表中的外键与dimension 表中的主键进行连接时采用like数据类型(例如 INT32 to INT32),可提高查询性能。
Query performance can be improved by leveraging like data types (i.e. INT32 to INT32) when joining foreign keys in a fact table to primary keys in a dimension table.
确保参照完整性(referential integrity,ri)关系中的依赖表拥有与外键匹配的索引。
Ensure dependent tables in a referential integrity (ri) relationship have indexes that exactly match the foreign key.
CheckOutRecord对象使用支持此模型的 CheckOutRecord表中的外键将特定的用户链接到保留的系统。
The CheckOutRecord object links a particular user to a reserved system using foreign keys in the CheckOutRecord table that backs this model.
了解关系数据库、数据模型、惟一键、主键、外键和表联结。
Learn about relational databases, data models, unique keys, primary keys, foreign keys, and table joins.
SQLObject允许将表之间的关系定义为外键。
SQLObject lets you define relationships among tables as foreign keys.
一个参数是描述数据库的关联数组集合:表名、列名、主键和外键。
One parameter is a collection of associative arrays that describe the database: table names, column names, primary keys, and foreign keys.
一般情况下,事实表中的外键不会出现在IBMCognosBI模型的事实查询主题中,如下图所示。
Typically, foreign keys found in the fact table are not presented in the fact query subjects in an IBM Cognos BI model as seen below.
索引扫描实际上是对父表进行主键查找,并完成外键约束验证。
The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.
可以通过使用内连接或外连接来连接两个表。
You join two tables by using an inner join or an outer join.
也可以使用系统编目视图来检索关于NOT NULL、惟一、主键、外键和表检查约束的信息。
You can also use the system catalog views to retrieve information about NOT NULL, unique, primary key, foreign key, and table check constraints. For example.
也可以使用系统编目视图来检索关于NOT NULL、惟一、主键、外键和表检查约束的信息。
You can also use the system catalog views to retrieve information about NOT NULL, unique, primary key, foreign key, and table check constraints. For example.
应用推荐