Sybase Delivers Sybase IQ 12.7

Sybase IQ 12.7 includes functionality that will enhance loading and ease of data migration from operational systems and analytics including additional online analytical processing (OLAP) functions.

Comments

* Much like other niche vendors like Netezza, Sybase IQ can only provide strong performance in a limited set of analytic scenarios: When the number of columns in a table that is queried are limited. As the number of columns increases, the database must reassemble rows, which results in slower performance compared with a large query in a row-based system.

Unlike Oracle, Sybase has two different databases, one for OLTP (ASE) and one for DW (IQ), which complicates an organization’s infrastructure. This added complexity is the same as having Teradata or Netezza in addition to Oracle for OTLP.