ConText and Other Options
Oracle Database 10g can handle data types such as relational data, object-relational data, XML, text, audio, images, video, and spatial data. These data types are stored as native types in the database, making the data searchable using SQL, even when different types are combined.
XML is treated as a native data type in the database. Oracle XML DB provides new capabilities for both content-oriented and data-oriented access.
Oracle introduced ConText and interMedia Text in versions prior to Oracle 9i, where data from tables, files, or URLs could be searched on. Starting with Oracle 9i, the whole concept was renamed “Oracle Text.” Oracle Text leverages scalability features such as replication and supports a local partitioned ...