经常看到网上有人在问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.
也许这就是它和普通索引的不同吧。