Sybase® IQ Text Technologies
Sybase IQ has long been able to store large text files in binary and character large-object fields. While other DBMSes share this capability, Sybase IQ is unique among enterprise-grade, analytically focused systems in its provision of text analytics functions. These functions index and search text fields and facilitate integrated analysis of database-stored text and data. They position users to exploit embedded advanced analytical functions to support data mining of text sourced information and lay the groundwork for enhancements planned for subsequent Sybase IQ releases.
Further, Sybase provides options for Web-data acquisition and cleansing and for handling of text in a wide variety of binary formats. In data warehousing and analysis of numerical data, sourced from enterprise operational and transactional systems, roughly 80% of effort will typically go into data preparation: data acquisition, cleansing, and structuring for analysis. Similar figures apply in work with text-sourced data. Availability of a comprehensive technology set — text-data acquisition, processing, storage, and access — speeds time to business insights whether obtained via data mining, BI reports and dashboards, or search.