oracle中text是什么意思,ORACLE TEXT是什么

经常看到网上有人在问ORACLE TEXT到底是个什么东西，我上网搜了一下，确实相关的信息和资料比较少。以前看CONCEPTS的时候记得里面有简单的介绍过，刚才去查阅了一下果然有，贴出来放在这里，供大家参考。

Overview of Oracle Text

Oracle Text indexes any document or textual content to add fast, accurate retrieval of

information to internet content management applications, e-Business catalogs, news

services, job postings, and so on. It can index content stored in file systems, databases,

or on the Web.

Oracle Text allows text searches to be combined with regular database searches in a

single SQL statement. It can find documents based on their textual content, metadata,

or attributes. The Oracle Text SQL API makes it simple and intuitive to create and

maintain Text indexes and run Text searches.

Oracle Text is completely integrated with the Oracle database, making it inherently

fast and scalable. The Text index is in the database, and Text queries are run in the

Oracle process. The Oracle optimizer can choose the best execution plan for any query,

giving the best performance for ad hoc queries involving Text and structured criteria.

Additional advantages include the following:

■ Oracle Text supports multilingual querying and indexing.

■ You can index and define sections for searching in XML documents. Section

searching lets you narrow down queries to blocks of text within documents.

Oracle Text can automatically create XML sections for you.

■ A Text index can span many Text columns, giving the best performance for Text

queries across more than one column.

■ Oracle Text has enhanced performance for operations that are common in Text

searching, like count hits.

■ Oracle Text leverages scalability features, such as replication.

■ Oracle Text supports local partitioned index.

Oracle Text Index Types

There are three Text index types to cover all text search needs.

■ Standard index type for traditional full-text retrieval over documents and Web

pages. The context index type provides a rich set of text search capabilities for

finding the content you need, without returning pages of spurious results.

■ Catalog index type, designed specifically for e-Business catalogs. This catalog

index provides flexible searching and sorting at Web-speed.

■ Classification index type for building classification or routing applications. This

index is created on a table of queries, where the queries define the classification or

routing criteria.

Oracle Text also provides substring and prefix indexes. Substring indexing improves

performance for left-truncated or double-truncated wildcard queries. Prefix indexing

improves performance for right truncated wildcard queries.

个人感觉吧，其实就是一种索引。呵呵，有点像废话哦！

It can find documents based on their textual content, metadata, or attributes.

也许这就是它和普通索引的不同吧。