CLOB

Dynamic text elements are most often used to display CLOB data type values .

动态文本元素经常用来显示CLOB数据类型值。

Research of Optimum Query Technology on Clob Big Segment in Oracle Database

Oracle数据库中Clob大字段的查询优化技术研究

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

在所有存储过程中，用于XML文档的参数类型是CLOB。

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

前面的比较展示了使用CLOB列（虽然非常短）带来的巨大影响。

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

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

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

本文比较了pureXML™技术与字符型大对象（CLOB）和分解式XML存储的性能。

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

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

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

向CLOB列插入相同的XML数据约占用一半的时间（53%）。

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

智能大对象包括字符大对象（CLOB）和二进制大对象（BLOB）数据类型。

All these technologies make a significant improvement in the speed of querying the big Clob field and satisfy the user 's needs .

使查询Clob字段速度得到了明显的提高，最终满足了用户的需要。

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

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

By the transaction technology , the problem of inserting CLOB data with large text into oracle database was solved with oracle client .

并且通过数据库的事务技术解决了.NET中用ORACLECLIENT插入CLOB大文本的问题。

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

将po存储为clob，则可以在应用程序代码中使用dom来检索相关信息。

The response time of querying the Clob field in a mass-data database is one of the key technologies influencing the database usage .

在数据量达到几十万的数据库中查询Clob字段，其响应的时间是影响数据库应用的关键技术。

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

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

You 'll store the XML within the new Word format within the XML column rather than in a Character Large Object ( CLOB ) .

您将把新的Word格式中的XML存储在XML列中，而不是一个CharacterLargeObject（CLOB）中。

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

当从CLOB（在CLOB中XML本来就是以文本形式存储的）读取完整的XML文档时，不存在此开销。

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

您可选择将CLOB列、VARCHAR列或文件系统内的文件用作基础存储。

A fundamental difference between CLOB storage and pureXML processing lies in XML parsing and its significant impact on insert and query performance .

CLOB存储和pureXML处理之间的基本区别在于XML解析及其对插入和查询性能的巨大影响。

The result of the function is returned as a CLOB ( Character Large Object ) data type that can hold up to1 MB of data .

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

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

只有盲目、全面的文档检索（这会再次忽略内部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存储为插入和全文档检索操作提供了优秀的性能，这通常是以搜索和提取性能下降为代价的。

To assess the difference in query performance between XML and CLOB columns , five queries were designed to cover the following common search and retrieval cases

为了评估XML和CLOB列之间的查询性能差异，本文设计了5个查询来涵盖以下常见的搜索和检索情况

The results are omitted because the relative performance difference between CLOB and pureXML storage was similar to the single-user tests shown above .

因为CLOB和pureXML存储之间的相对性能差异类似于上述单用户测试，所以这里省略了测试结果。

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

正如所料，CLOB和XML列占用的插入时间和插入的文档数成线性比例。

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）存储在数据库中。

All table spaces were defined with the no file system caching option , except where otherwise noted ( for some of the CLOB storage tests )

全部表空间均使用nofilesystemcaching选项定义，除非另外声明（用于某些CLOB存储测试）

XQuery over XML data in XML type columns can be40 times faster than corresponding queries over CLOB columns which require XML parsing at query time .

XML类型列中XML数据的XQuery速度比CLOB的对应查询（需要在查询时进行XML解析）速度快了40倍。

You can see that pureXML queries can easily be20,30 or40 times faster than queries over XML in CLOB columns .

您可看到pureXML查询的速度可以很轻松地达到CLOB列中的XML速度的20、30或40倍。

Using character or binary large object ( CLOB or BLOB ) columns of tables to store the XML data intact in a relational database management system ( DBMS ) .

使用表的字符大对象（CLOB）或二进制大对象（BLOB）列在关系数据库管理系统（DBMS）中按原样存储XML数据。