英语释义

1. klaberjass

片语

oracle clob字段长度

blob clob触发器

clob blob实现大字段

Convert long to clob我的问题出在哪

turfary泥炭田

clob fieldclob字段

Tango Chino Clob阿根廷探戈传播机构

private Clob describe对此学生的描述

Virtual CLOB虚拟CLOB

TEXT clob其它类型

英汉例句

• the purchase order (po) is stored as a clob in the relational database (as opposed to being shredded).

  采购订单（po）在关系数据库中存储为clob（而不分割）。

• and although internally the xml is stored in a hierarchical (tree) format, logically in the database table it appears to be stored in a single column (like a clob or blob).

  另外，尽管xml在内部存储为层次化（树）格式，但是它看起来像是存储在数据库表的单一列中（就像clob或blob）。

• an easy way to identify this problem is to temporarily use clob types, which have no size restrictions, as target columns.

  识别该问题的简易方法是临时使用clob类型作为目标列，它没有任何大小限制。

• this is because clob inserts do not benefit as much from parallelism as xml column inserts.

  这是因为clob插入从并行性中的获益不如xml列插入多。

• only a blind full document retrieval, which again ignores the internal xml structure, can quickly read xml documents from clob columns.

  只有盲目、全面的文档检索（这会再次忽略内部xml结构）能够快速从clob列读取xml文档。

• notice that inserting data to an xml column is no different from inserting into any clob column.

  注意插入数据到xml列中与插入数据到任何clob列中没有区别。

• since clob inserts use direct writes, the file system cache is not needed and is pure overhead.

  因为clob插入使用直接写入的方式，所以无需文件系统缓存，而仅有纯开销。

• while clob inserts were about twice as fast as xml inserts in our single-user tests ( figure 1), they are more than twice as slow in our multi-user test (207%).

  虽然clob插入的速度在单用户测试中是xml插入的两倍（图1），但是它们在多用户测试中却慢了两倍(207%)。

• this comparison is interesting because for a certain class of today's xml applications, clob columns are a commonly choice for xml storage.

  这种比较是很有趣的，因为对于当今相当多的xml应用程序来说，clob列是xml存储最常用的选择。

• in summary, clob storage offers good performance for insert and full document retrieval, typically at the cost of poor search and extract performance.

  总之，clob存储为插入和全文档检索操作提供了优秀的性能，这通常是以搜索和提取性能下降为代价的。

• the other common technique is to simply dump your xml document inside a clob column in the database.

  另一种常见的技术是直接把xml文档转储到数据库的clob列中。

• the result of the function is returned as a clob (character large object) data type that can hold up to 1 mb of data.

  函数的结果会以clob（字符型大型对象）数据类型的形式返回，可容纳1mb的数据。

• it is simply a test to see whether this xml document can be safely inserted as a char, varchar, or clob into the database without resulting in data integrity loss.

  它只是一个测试，看是否可以安全地将这个xml文档作为char、varchar或clob插入到数据库中，而不会损失数据完整性。

• inserting the same xml data into a clob column takes approximately half the time (53%).

  向clob列插入相同的xml数据约占用一半的时间(53%)。

• side tables can avoid much of the xml parsing for clobs and can often make clob queries 100 times faster or more.

  索引表能够避免许多针对clob的xml解析，这通常能够使clob查询速度快100倍或更多。

• you already know that this adds significant overhead to clob inserts, but the side tables can be efficiently searched and joined with the main table containing the clobs.

  您已经知道这会给clob插入增加巨大开销，但是这也会使索引表被有效地搜索，并和包含clob的主表结合。

• clob data types have an inherent code page equal to the database code page, so there is an implicit code page conversion of the reply to the sql world during the serialization.

  clob数据类型的代码页自然地等于数据库代码页，所以在串行化期间对sql的回复有一个隐式的代码页转换。

• however, file system caching can help read operations on clob columns if no xml parsing is involved.

  然而，如果不涉及xml解析，那么文件系统缓存能够帮助提高对clob列的读操作。

• gone are the days of storing xml data as a clob or shredding to relational tables.

  将xml数据存储为clob或将其分割为关系表的时代已经过去。

• in this case you could store xml just as well in varchar or clob columns, which may give you performance advantages for full-document insert and retrieval operations.

  在本例中，将在varchar或clob列中存储xml，对于全文档插入及检索操作而言，这将给您带来一定的性能优势。

• without file system caching, this overhead is mitigated by the fact that xml columns are buffered in the db2 buffer pool and clob columns are not.

  在没有文件系统缓存的情况下，xml列在db2缓沖池进行缓沖而clob列则不是，从而可降低开销。

• if you allow file system caching for the dms table space containers ( figure 2), the xml insert performance improves slightly while the clob inserts suffer.

  如果您允许dms表空间容器使用文件系统缓沖（图2），那么xml插入性能仅有少量改进，而clob插入性能却会下降。