clob

clob

美 [klɒb]  英 [klɒb]

  • n.泥炭田
  • 网络字符大对象;字符大型对象;大文本

英汉解释

n.
1.
泥炭田

例句

This article compares its performance with that of character large object (CLOB) and shredded XML storage.

本文比较pureXML技术字符对象CLOB分解XML存储性能

This comparison is interesting because for a certain class of today's XML applications, CLOB columns are a commonly choice for XML storage.

这种比较有趣因为对于当今相当XML应用程序来说CLOBXML存储常用选择

I decided to use CLOBs (Character Large Objects) with a modern RDBMS to save these documents.

决定使用新型RDBMS支持CLOB字符对象CharacterLargeObject保存这些XML文档

Storing the PO as a CLOB allows you to use the DOM in the application code to retrieve the relevant information.

PO存储CLOB可以应用程序代码使用DOM检索相关信息

Since the RDBMS supported a Java API to insert and retrieve CLOBs, this was a very easy task.

因为RDBMS支持JavaAPI插入检索CLOB所以非常轻松任务

The parameter type used for XML documents in all the stored procedures is CLOB.

所有存储过程用于XML文档参数类型CLOB

Only a blind full document retrieval, which again ignores the internal XML structure, can quickly read XML documents from CLOB columns.

只有盲目全面文档检索再次忽略内部XML结构能够快速CLOB读取XML文档

This overhead does not exist when reading full XML documents from a CLOB where the XML is already stored in text form.

CLOBCLOBXML本来就是文本形式存储读取完整XML文档存在开销

Selecting an XML column from a table also serializes its result into a CLOB.

一个选择一个XML导致结果串行化为一个CLOB

Inserting the same XML data into a CLOB column takes approximately half the time (53%).

CLOB插入相同XML数据占用一半时间(53%)。

The CLOB data type is defined as a character large object capable of storing characters up to 2, 147, 483, 647 long.

CLOB数据类型定义最多能够存储2,147,483,647字符字符对象

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

识别问题简易方法临时使用CLOB类型作为目标没有任何大小限制

Notice that inserting data to an XML column is no different from inserting into any CLOB column.

注意插入数据XML插入数据任何CLOB没有区别

Note that XQUERY, by default, serializes its result set into a CLOB.

注意默认情况XQUERY结果串行化为一个CLOB

This is because CLOB inserts do not benefit as much from parallelism as XML column inserts.

因为CLOB插入并行性获益不如XML插入

Since logically the XML column appears the same as a VARCHAR, CLOB, or BLOB column, the INSERT statements are also similar.

因为从逻辑上XMLVARCHARCLOBBLOB相似所以INSERT语句也是相似

Since CLOB inserts use direct writes, the file system cache is not needed and is pure overhead.

因为CLOB插入使用直接写入方式所以无需文件系统缓存开销

As expected, the elapsed insert time for both CLOB and XML columns is approximately linear in the number of documents inserted.

正如CLOBXML占用插入时间插入文档线性比例

Another case is when you want to store a document in a database as a string or a Character Large Object (CLOB) without parsing it.

另外一种情况不用解析文档作为字符串字符对象(CharacterLargeObject,CLOB)存储数据库

Many database systems allow you to store XML data as CLOBs or "shred" the data into relational tables.

许多数据库系统允许XML数据存储CLOB格式数据分解关系

Gone are the days of storing XML data as a CLOB or shredding to relational tables.

XML数据存储CLOB分割关系时代已经过去

There is a code page conversion to the SQL world if the value is serialized into a CHAR, VARCHAR, or CLOB type that is not FOR BIT DATA.

如果串行化为不是FORBITDATACHARVARCHARCLOB类型那么一个SQL世界代码转换

The purchase order (PO) is stored as a CLOB in the relational database (as opposed to being shredded).

采购订单PO关系数据库存储CLOB分割)。

The other common technique is to simply dump your XML document inside a CLOB column in the database.

一种常见技术直接XML文档转储数据库CLOB

Even if the Chinese or Russian documents were inserted as BLOBs, they cannot be serialized as CLOBs or CHAR-types without giving this error.

即使BLOB形式插入中文俄文文档这些文档仍然不能串行化为CLOBCHAR类型而不产生错误

Smart large objects consist of character large object (CLOB) and binary large object (BLOB) data types.

智能对象包括字符对象CLOB对象BLOB数据类型

The above comparison shows the extreme impact of having a CLOB column, even a very short one.

前面比较展示使用CLOB虽然非常带来巨大影响

You can choose to make the underlying storage a CLOB column, a VARCHAR column, or files within the file system.

选择CLOBVARCHAR文件系统文件用作基础存储

Figure 3 shows that the increased workload intensity hurts CLOB performance drastically.

3显示增加工作负载密度大大影响CLOB性能

However, file system caching can help read operations on CLOB columns if no XML parsing is involved.

然而如果涉及XML解析那么文件系统缓存能够帮助提高CLOB操作

Prior to the DB2 9 release, XML data was either stored intact as a character large object (CLOB) or shredded to relational tables.

DB29之前XML数据要么作为字符对象CLOB原样存储要么分解关系

A response message is returned as character LOB (CLOB) if issued by the server.

如果服务器发出响应消息作为字符LOBCLOB返回

Redirect the file into PDSQL using the operator, and pipe through a grep command, looking for CLOB fields.

利用定向运算符文件重新定位PDSQL通过grep命令导入查找CLOB

Side tables can avoid much of the XML parsing for CLOBs and can often make CLOB queries 100 times faster or more.

索引能够避免许多针对CLOBXML解析通常能够使CLOB查询速度快100更多

This means that XML is either stored in files, stored wholesale in database CLOBs, or shredded into distinct columns.

意味XML可以存储文件或者大量存储数据库CLOB或者解析分离

The system generates a list of all of the CLOB fields found in the defect table (see Table 2).

系统产生所有CLOB字段一个列表这些字段defect参见2)。

It scales with the database, and XML-specific optimizations give it better performance than CLOBs.

数据库进行扩展并且特定XML优化使得具有CLOB更好性能

At present, stored procedures and user-defined functions do not have support for XML as a parameter, but they can easily be passed as CLOBs.

目前存储过程用户定义函数支持XML作为参数但是容易作为CLOB传递XML

Figure 5 shows the query performance (elapsed time) of all five test queries for both pureXML and CLOBs.

5显示pureXMLCLOB进行全部5测试查询查询性能占用时间)。

The larger messages should be read or received as CLOB.

消息应该CLOB形式读取接收