The single-table data often reach hundreds of millions of records, and records will increase with time.
而单表的数据量往往会达到上亿的记录,并且记录数会随着时间而增长。
In single-table inheritance, there is a single database table that contains columns for both base and derived classes.
在单表继承中,一个数据库表同时包含基类和派生类的列。
Listing 1 shows a schema for the single table database.
清单1显示了单表数据库的模式。
TPH: Map an Entity hierarchy to a single table.
TPH:映射一个实体层次到单表。
Inheritance is limited: with ActiveRecord, I'm forced to use a mapping strategy called single table inheritance (see Resources), which is not always optimal.
继承也受到限制:使用ActiveRecord时,我被迫使用单表继承映射策略,而该策略并不总是最佳选择。
Before you can start with the actual analysis, you need to combine the four tables into a single table. This single combined table should contain the following columns.
在您可以开始实际分析以前,您需要把这四个表合并成一个单一的表。
In this test, the EJB entity represents a single row in the database table.
在这个测试中,EJB实体表示数据库表中的一个单一行。
An XISCAN plan if only a single index is defined on the table and it is of type XML.
一个XISCAN计划,前提是只对表定义了一个单一的索引并且其类型为XML。
You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
你可以添加sql函数,WHERE和JOIN语句到视图中,并且在视图中显示的数据就像数据来自一个单一的表。
Due to the large amount of data in the audit log table, a single INSERT statement will usually fail because the data per transaction exceeds the log file size of the database system.
因为审核日志表格里有大量的数据,单独的insert语句通常会失败,这是因为每个事务的数据超过了数据库系统里的日志文件的容量。
Much of the power of the relational model comes from the fact that the relational table is the single data structure that represents homogeneous collections of data.
关系模型的大部分功能都来自于这样一个事实:关系表是代表同质数据集合的单一数据结构。
Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义,所以不会影响查询性能。
Note: in Listing 14, the SALES_FACT table is populated in a single transaction, which will require a large amount of disk space for logging.
注意:在清单14中,sales_fact表是通过单独一个事务填充完成的,这需要占用大量的磁盘空间来记录日志。
High Performance Unload can recover data from single table failures or accidental table drops from full, incremental, delta, and merged backups.
HighPerformance Unload可以从完全备份、增量备份、delta备份和合并备份中恢复单个表格故障或意外表格删除中的数据。
This single value is a locator to the transition table, which the procedure USES to access the transition table columns.
这个单值是转换表的定位器,存储过程用它来访问转换表的列。
For a single, simple, survey, you could probably place all of the information from each question into a field in a single table.
对于单个的、简单的问卷调查,您可以将每个问题的所有信息放到单个表的一个字段中。
But our form is not limited to working within a single table; a single form can display and edit data for many tables through relation objects.
但我们的表单不仅限于在单个表中工作;单个表单可以通过关系对象为多个表显示和编辑数据。
With extended indicator support, a single program can be used for all incoming update transactions against a single table based on a common key.
使用扩展指示符支持,单个程序可以基于一个公共键用于单个表的所有更新事务。
Recover from single table failures or accidental table drops by extracting a single table from a backup for restoration
通过从备份中提取单个表执行恢复,可恢复单个表故障或意外的表删除
They are limited, though, in that they work on only a single table and not across multiple tables through relationships.
但它们受到限制,只能在一个表上工作,不能通过关系跨多个表工作。
In this scenario, you could use a heterogeneous update to update the ORDER and ORDER_ITEMS table in a single database operation.
在这个场景中,可以使用异构更新在一个数据库操作中更新order和order_items表。
Listing 1 shows a script that creates a table that has a single XML column.
清单1中的脚本创建只含一个xml列的表。
If an XML document is too large to fit on a single page in a table space, DB2 splits the document into multiple regions which are then stored on multiple pages.
如果XML文档太大,一个表空间中的一个页面容纳不下,那么DB 2就将该文档划分成多个区域,然后将它们分开存储到多个页面上。
The following code for a JSP page invokes the table tag to display the Employee table (single line of code displayed on multiple lines for viewing convenience)
JSP页中的下面代码调用表格标记以显示Employee表(为了方便观看,将一行代码显示为多行)
Finally, note how the single row VALUES clause is used in the return statement to return the end result as a single-row table.
最后,注意在return语句中使用了单行的values子句,以便将最后的结果以单行的表的形式返回。
With a UNION ALL view, you are provided information from all branches of the company as if the information were coming from a single table.
有了UNIONALL视图,就有了来自所有分公司的信息,而这些信息看起来像是在一个表中。
For this purpose, I'm using DB2 V9 to store and query XML data about business partners, which I'll maintain in a single partners table.
为此,我将使用DB 2v9来存储和查询关于业务伙伴的XML数据,将在一个partners表中维护该数据。
This new command allows you to collect statistics and build an index in a single pass of the base table, instead of two passes with the previous implementation of these features.
这条新命令允许您在对基表的一次扫描中收集统计数据,并构建索引,而不像这些特性的以前实现那样需要进行两遍扫描。
Each container can only belong to a single table space, but a table space can have many containers.
每个容器只能属于一个表空间,但是一个表空间可以拥有许多容器。
For the single, integrated table, the command is the same except for the table (and optionally the index) name.
对于添加了空间列的源表,命令是相同的,只是表名(可能还有索引名)不一样。
应用推荐