最后,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.
在我们的例子中,这些指示器表示数据库对象(如别名或服务器)集的聚合状态。
They represent an aggregate state of a set of database objects, in our case, nicknames or servers.
这样就将更多的空间留给了其他内存集,例如数据库共享内存。
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.
平面文件 是指存储在文件系统上的任何文件,它与更为复杂的文件集(如结构数据库中的文件)相对。
The term flatfile refers to any file stored on a file system, as opposed to a more complex set of files, such as those in a structured database.
有了一个更大的数据库,更广泛的数据集,那么对进程中何种差异将对结论产生重大影响的猜想,就能对其进行相互检测。
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.
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.
数据库分组(工作集)。
每个数据库有一个数据库共享内存集。
应用程序组共享内存集没有列出,因为它是从数据库共享内存集中分配的。
Application group Shared memory set is not listed because it is allocated from the database Shared memory set.
如果书的题目或文本包含当前数据库的字符集以外的字符会怎样?
What about books whose titles or text contain characters outside the current database's character 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.
应用推荐