Best way to structure a database where one row has to map to many rows in another table?
最好的结构数据库的一行映射到另一个表中的多行?
Suppose you have a bunch of records in a table, and in another table, you analyze all those records.
假设你有一个表中的一些记录,和另一个表中的所有记录,你分析。
Set the number of rows to generate as a ratio to the number of rows that are generated in another table.
以相对于在另一个表中所生成行数的比率形式设置要生成的行数。
Make sure any foreign keys in a table (that is, keys that link a record to a record in another table) are properly indexed.
确保一个表中的任何外键(即链接记录到另一个表中的记录的键)的索引得到合理编制。
You can create relationships between your tables in a database diagram to show how the columns in one table are linked to columns in another table.
可以在数据库关系图中的表间创建关系,以显示某个表中的列如何链接到另一表中的列。
Purge: in some recent history tables, every few days the entire table is dropped and recreated because data is now available in another table with a longer history.
清洗:在某些最近历史表中,每过一些天就删除整个表,并重新创建表,数据将放在有更长历史的另一个表中。
In another room, he saw on a table a sword and a loaf of bread, which he also took.
在另一个房间里,他看到桌子上有一把剑和一条面包,他也收了起来。
In one corner stood a table and a chair, and in another the grandfather's bed.
一个角落里放着一张桌子和一把椅子,另一个角落里放着爷爷的床。
One robot will probably teach another to play table tennis in the future.
将来,一个机器人可能会教另一个机器人打乒乓球。
If your host has communicated successfully with another host, it's likely that there is an entry in the ARP table.
如果您的主机曾经与另一个主机成功地通信,那么在arp表中很可能有相应的条目。
Imagine you are transferring money from one account to another. Each account balance is represented by a row in a database table.
假设您正在从一个账户向另一个账户进行转账个账户差额由数据库表中的某一行来表示。
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.
外键是在一张表中出现的一个或多个数据属性;它可以是另一张表的键的一部分,或者干脆碰巧就是另一张表的键。
The structure of the document is displayed in a collapsible tree hierarchy in one pane, while any attributes or element bodies are displayed in a table in another pane.
文档的结构在一个窗格中以可折叠的树层次结构显示,而任何属性或元素主体在另一个窗格的表中显示。
In this example, the submit page is redirected to another JSP that displays the results of the updated table.
在我们的例子中,提交页面后自动转到另一个显示数据表更新结果的JSP页面上。
You need to define a partner reference in a rule group when a rule set or a decision table invokes another component.
当规则集或决策表调用另一个组件时,您需要在规则组中定义伙伴引用。
If a concept occurs multiple times in the original text row, there will be another row created in the target table, which points to the same original entry.
如果一个概念在原始文本行中出现多次,那么目标表中将创建另一个行,该行指向相同的初始条目。
Additionally, one Node may refer to another Node, in much the same way that an object references another object or a row in one database table references a row in another database table.
此外,一个结点可以引用另一个结点,与在一张数据库表中一个对象引用了另一个对象、一行或是引用了另一张数据库表中的一行类似。
Often you will see the leak unit in one row of the table to be a leak container in another row within the same table.
通常,您会看到表的一行中的泄漏单元是同一个表中另一行内的泄漏容器。
In other words, you cannot put one table in one database and another in a second database.
换句话说,您不能把一个表放在一个数据库中而另外一个表放到另一个数据库中。
A JOIN in SQL is simply a way of saying that a field in one table must correspond to another field in a different table.
SQL中的JOIN只是简单说明一个表中的字段必须对应于另一个表中的另一字段的方法。
Another potential problem is the local predicate on the table reference CUST_ORDER_HEADER (COHE) in the inner sub-query (see also in Figure 9).
另一个潜在问题是内部子查询中CUST_ORDER_HEADER (COHE)表引用上的本地谓词(见图9)。
An easier way to create a table copy in another database.
在另一个数据库中创建表拷贝的简便方法。
Creating a table copy in another database by using a nickname.
使用别名在另一个数据库中创建表拷贝。
In a data cell in a table on the report, add another Text field.
在报告表格的数据单元中,添加另一个Text区域。
Invites can now run from one entry in the user table to another, and have an additional column for when the invite is deemed to have been rejected by force of apathy.
现在,可以从用户表中的一位用户向另一位用户发出邀请,另外的一个列用于记录什么时候可以认为另一方对此邀请不感兴趣而拒绝?
In this case, the association information can be recorded by creating another table that stores the association PO_Cust.
在此例中,可以通过创建另外一个存储关联PO_Cust的表来记录关联信息。
Listing 2 is another stylesheet excerpt that demonstrates the keep properties in a blind table with FOP.
清单2摘录了另一个样式表,它演示了使用FOP的隐形表中的keep特性。
You can easily attach and detach the partitions using the DB2 alter table command to move the data from one table (production table) to another table (history table) in the same database.
您可以很容易使用DB 2altertable命令来附加和分离分区,从而将数据从一个表(生产表)移动到同一个数据库的另一个表(历史表)中。
For an overall comparisons, the following table show how they fare with one another in backup and restore space.
为了进行总体的对比,下面的表对比MySQL和DB 2Express - c在备份和恢复方面的差异。
Finally, you put the results into another DB2 table. The job diagram is shown in Figure 41.
最后,将结果放入另一个db2表。
应用推荐