最后,Pig是一个包括适用于Hadoop编程的高级语言的大型数据库集分析的平台。
Finally, Pig is a platform for large data set analysis that includes a high-level language for Hadoop programming.
它在数据库项目中发挥了令人吃惊的作用,尤其是用于将数据集从传统数据库集成到XML文档系统时。
It is surprisingly useful in database projects, especially for integrating data sets from traditional databases into XML document systems.
这比其他UNIX平台上可用的任何数据库共享内存集要少得多。
This is much less then any database Shared memory set available to other UNIX platforms.
这样就将更多的空间留给了其他内存集,例如数据库共享内存。
This leaves more room for other memory sets such as the database Shared memory.
如果将UDB配置为创建一个大于该值的数据库共享内存集,则请求将遭到失败。
If UDB is configured to create a database Shared memory set which is larger than this, the request will fail.
查找或查询操作还可以通过修饰后应用一个查询计划来自定义从数据库查询得到的实体集。
A find or query operation can be decorated to apply a fetch plan to customize the set of entities to fetch from the database.
注意,该语句指定UTF-8作为这个数据库的编码集。
Note the specification of UTF-8 as the codeset for the database.
它会在RAM中按照原样保存数据库返回的结果集。
It stores the result sets returned by the database in RAM, as is.
图2展示了数据库共享内存集内的各种内存池。
Figure 2 shows the various memory pools within the database Shared memory set.
有了一个更大的数据库,更广泛的数据集,那么对进程中何种差异将对结论产生重大影响的猜想,就能对其进行相互检测。
With a bigger databank and a wider range of data sets assumptions about what differences in processing make a big difference to the results could be checked against each other.
限制:由于物理ram只有1gb,数据库共享内存集只能映射到它在物理上可以使用的空间,即1gb +交换空间。
Limit: Because the physical RAM is only 1gb, the database Shared memory set can only map to what is physically available to it, which is 1gb + swap space.
我们不久后将看到如何使用SQLSELECT查询及运用FESI数据库访问扩展名的结果集。
We will see a little later how to work with SQL SELECT query and the result set using the FESI database access extension.
根据段的类型和大小,DB 2可以指定在象限4中创建段。数据库共享内存集仍然有大约1gb的限制。
Depending on the type and size of the segment, DB2 can specify to create it in quadrant 4. The database Shared memory set is still limited to approximately 1gb.
第一种是执行查询,从数据库获得完整的结果集,然后每次只向用户显示结果集中的一页。
The first is to execute the query, retrieve the entire result set from the database, and then simply display the results to the user one page at a time.
下一步,使用为应用程序构建逻辑的php类集打包数据库。
The next step is to wrap the database with a set of PHP classes that build the business logic for the application.
在执行产生大型结果集的数据库查询时,常常对结果进行分页,然后让用户在页面之间导航。
When database queries that produce large result sets are executed, it's common to break the result set into pages and then require the user to navigate among the pages.
限制:DB2发出的任何创建大于shmmax值(这里是2gb)的数据库共享内存集的请求都将失败,并返回一个outofmemorytype错误。
Limit: Any request by DB2 to create a database share memory set which is larger then the shmmax value (2gb in this case) will fail with an out of memory type error.
它支持两种最常见的数据库结果集分页类型(渐进式(sliding)和跳跃式(jumping)),并且允许对格式进行大量定制和显示页码和链接。
It supports the two most common types of database result set paging (sliding and jumping), and also allows extensive customization of the format and display of page Numbers and links.
例如,下列命令创建了数据库“spaindb”,使用代码集1252和地域ID34,这确定了Windows平台上用于西班牙语的代码页。
For example, the following command creates the database "spaindb" with code set 1252 and territory ID 34 which determine the code pages for Spanish on the Windows platform.
数据库表employee查询生成的结果集。
Assertion类型是DbUnit定义的定制类,可以进行特定于数据库结果集的额外断言。
The Assertion type is a custom class defined by DbUnit to facilitate additional assertions specific to database result sets.
例如,locklist是属于数据库共享内存集的一个内存池。
For example, the locklist is a memory pool that belongs to the database Shared memory set.
例如,locklist是属于数据库共享内存集的一个内存池。
For example, the lock list is a memory pool that belongs to the database Shared memory set.
数据库分组(工作集)。
每个数据库有一个数据库共享内存集。
如果书的题目或文本包含当前数据库的字符集以外的字符会怎样?
What about books whose titles or text contain characters outside the current database's character set?
应用程序组内存集是从数据库共享内存集中分配的。
The application group memory set is allocated from the database Shared memory set.
当从数据库拉出信息或在整理信息集时,就会发生这种情况。
This occurs when pulling information from the database or when collating a collection of information.
它直接建立数据库连接来执行数据库操作,如数据更新和结果集检索。
It establishes database connections directly to perform database operations such as data updates and result set retrieval.
如有必要,执行字符集到数据库代码页的转换。
Character set conversion into the database code page is performed if necessary.
应用推荐