SAP Sybase IQ provides in-database analytics in three ways:
native built-in analytics, native UDF plug-in analytics, and external UDF plug-in analytics.
As a developer, you can enable complex analysis of big data by providing analytics as
external UDFs.
- Native built-in analytics – Examples of native in-kernel analytics include OLAP, and full-text search.
The CUME_DIST function is one example of a built-in ANSI
SQL OLAP built-in aggregate function.
- Native UDF plug-in analytics – Using out-of-process shared libraries, you can develop text
analytics solutions. By developing out-of-process in-database
UDFs, you minimize the security and robustness risks inherent in running
user-defined code in-process. See Unstructured Data Analytics
for LOB documentation.
- External UDF plug-in analytics – Use Java UDFs, table UDFs, and Table Parameterized Functions (TPFs) to
develop out-of-process analytics solutions for big data.