Within You and About You: Getting Started with interMedia Text

Paper
Presentation

Abstract

Oracle8i’s interMedia Text provides a set of methods and extensions to standard SQL that can be used for searching text and documents. Unlike Oracle ConText, an add-on product available with Oracle7, interMedia Text fully integrates most search-related tasks into the familiar database environment. With it, effective searches through SQL queries become possible, and index creation and management becomes more intuitive.

This document explores, with the aid of examples, all of the steps involved in building an interMedia Text search-enabled database. It will provide general considerations for table creation, methods for loading data into tables, tasks involved with creating text indexes on tables, examples of search queries, and issues surrounding text index maintenance. Special attention will be paid to the use of large objects (LOBs) as it relates to document management for the purpose of searching.

Year Venue Title
1999 Oracle Open World Within You and About You: Getting Started With interMedia Text
2000 ECO Within You and About You: Getting Started With interMedia Text
2000 IOUG-A Live Within You and About You: Getting Started With interMedia Text
2000 MAOP Within You and About You: Getting Started With interMedia Text
2000 NYOUG Within You and About You: Getting Started With interMedia Text
2000 SDOUG Within You and About You: Getting Started With interMedia Text