Consider a banking application where there is a very large account table for one of the dimensions.
考虑一个银行应用程序,其中针对一个维度有一个极其大型的帐户表。
In preparation for the celebration, a straw mat is placed on the table, along with a candle holder with seven candles, one black, three red, and three green.
在准备庆祝活动时,桌子上放着一张草席,还有一个蜡烛架,上面有七支蜡烛——一支黑的,三支红的,还有三支绿的。
They stood there on the table for more than 20 minutes before one finally fell over.
在最后一个倒下之前,它们在桌子上立了20多分钟。
At mealtimes, no one sits at the dining table for their food.
吃饭时,没有人坐在餐桌前吃饭。
Also note that in this window, you can specify multiple tables, but for simplicity, only choose one table.
同时注意,在此窗口中,您可以指定多个表,但为了简单起见只选择了一个表。
The first approach would be to have one data element table for each type of data elements.
第一种方法是为每一种类型的数据元素准备一个数据元素表。
In the initial star schema above, the fact table contains one row for each keyword occurrence.
在前面的初始星型模式中,对于每次的关键词的出现,事实表都包含一行。
You can choose to have one such dimension table for each standard category, such as subject-description, country, and organization.
可以选择为每个标准类别使用一个这样的维表,例如主题描述、国家和组织。
If you have more than one table, you can then either create multiple mappings files (one for each table) and add multiple elements, or create multiple mappings in one file and add one element.
如果您有多个表,您即可以创建多个映射文件(每个表一个),以及添加多个元素,也可以在一个文件中创建多个映射,并且添加一个元素。
You should create one or more USER temporary table spaces for storing data of temporary tables.
您应当创建一个或多个USER临时表空间来存储临时表的数据。
You see in Figure 5 that one table is used for each of these types of features.
在图5中可以看到,对于以上每种类型的特性,都有一个表。
The approach generally fits well with a data warehouse system since all data is in one table without the need for table joins.
这种方法通常比较适合数据仓库系统,因为所有数据都在一张表里,不需要做表连接。
You have a database table for trails and another one for locations.
有了一个针对赛道的数据库表和另一个针对地点的数据库表。
SYSCAT.COLDIST contains entries for a certain table only if distribution statistics have been collected for at least one of its columns.
仅在收集了一个表中至少一个列的分布统计信息时,SYSCAT.COLDIST 才会包含关于该表的条目。
Use a created global temporary table (CGTT) for per-session storage of the baseline data (use one CGTT per table function).
使用为基线数据的每会话存储创建的全局临时表(CGTT)(对于每个表函数,使用一个 CGTT)。
For instance: How does one query a table with a billion rows?
例如:怎样查询一个十亿行的表?
For our second strategy (one table per class hierarchy), you'll have to define your integrity using check constraints.
对于第二个策略(每个类层次结构一个表),您必须用检测约束定义您自己的完整性。
A fly-catching clock, pest-control lampshade (above) and mouse-eating table all together make for one hungry living room.
能捉苍蝇的时钟、能除虫的灯罩(上图)以及能吃老鼠的桌子,这可真是一间饥肠辘辘的客厅啊。
For a single record of the primary table, only one record will be retrieved from the non-primary tables.
对于主表的每条记录,只从非主表中检索一条记录。
It maintains a list file that has one HTML table row for each Purify run so far, in reverse chronological order.
它维护了一个到目前为止对每个Purify运行都有一个html表格行的文件列表,反之则是按照时间顺序的。
After you create the table, you use one insert statement for each entry in your toppings array.
创建表后,需要对浇头数组中的每个条目使用一条insert语句。
The Replication Center always creates a new nickname for a non-DB2 target table even if one or more nicknames already exist for the table.
ReplicationCenter总是为非db2的目标表创建一个新的别名,即使该表已经存在一个或多个别名。
In other words, for each article there may be more than one description in the ArticleDescription table, one for each language supported (see Figure 1 in Part 1).
换句话说,对于每个商品,在articledescription表中可能都不止一个描述,而且每个都有一种支持语言(参阅第1部分中的图1)。
To achieve best compression results, DB2 uses two separate compression dictionaries, one for relational columns and one for the XML Data Area of the table.
为了取得最好的压缩效果,DB2使用两个单独的压缩词典,一个用于关系列,另一个用于表的XMLDataArea。
The second table (xmlrpdb.atom_site) contains one relational row for each atom coordinate (i.e., for each
第二个表 (xmlrpdb.atom_site)包含了每个原子坐标的一个关系行(即,PDBML文档中的每个
It's also optimized for full table scans (one of the most common-and most time-consuming-business intelligence query access patterns).
它还针对完全表扫描(一个最常见—也最耗时—的商业智能查询访问模式)进行了优化。
For example, in our department table below, we use one XML document per department (medium granularity).
例如,在下面的部门表中,我们为每个部门使用一个XML文档(中等粒度)。
For table Spaces containing more than one table, when DB2 acquires locks on a table, that lock does not affect access to segments of other tables.
对于包含多个表的表空间,当DB 2取得用于某一个表的锁时,这个锁不会影响对其他表的段的访问。
In this case, I use the PHP code to create a series of tags-one for each page in the table.
在本例中,我使用PHP代码创建了一系列标记—一个标记用于表格中的一个页面。
There is however one level of association: each table space will be assigned to one process that is solely responsible for processing all the data in that table space.
然而数据页之间还是有一定的关联:每个表空间将被指定给一个单独负责处理该表空间中所有数据的进程。
应用推荐