The Unstructured Data Analytics Option extends the capabilities of Sybase IQ to allow storage, retrieval, and full text searching of binary large objects (BLOBs) and character large objects (CLOBs) within the Sybase IQ database.
Users must be specifically licensed to use the Unstructured Data Analytics functionality described in this product documentation.
As data volumes increase, the need to store large object (LOB) data in a relational database also increases. LOB data may be either:
Unstructured – the database simply stores and retrieves the data, or
Semistructured (for example, text) – the database supports the data structure and provides supporting functions (for example, string functions).
Typical LOB data sources include images, maps, documents (for example, PDF files, word processing files, and presentations), audio, video, and XML files. Sybase IQ can manage individual LOB objects containing gigabytes (GB), terabytes (TB), or even petabytes (PB) of data.
By allowing relational and unstructured data in the same location, Sybase IQ lets organizations access both types of data using the same application and the same interface. The full text search capability of Sybase IQ supports text archival applications (text analytics) in handling unstructured and semistructured data.