Sybase IQ license approach

[Former Member]

Hi all,

Sybase IQ  licensed by Cores and additional options. In 2014 standard physical processor will include 12-14 cores. In 2015  maybe  20, and so on.

In big IQ installation you also will pay for partitioning ,  each node in MultiPlex, and ability to use BLOB and CLOB fields.

Are you ready to pay for this?

SAP HANA licensed  by  data volumes. Partitioning, nodes, BLOBs, CLOBs - all include in licenses.

What do you think about?

Product Editions

SAP Sybase IQ is available in several product editions.

Edition	Description
Enterprise Edition	Supports all options and features. Optional features require additional licenses that are purchased separately.
Small Business Edition	Supports most of the functionality available in the Enterprise Edition, but does not support multiplex or any optional features.
Single Application Server	Provides the same functionality as the Small Business Edition, but is restricted to use in a one- or two-machine environment.
Evaluation Edition	Supports all options and features available in the Enterprise Edition for a 30-day evaluation period.
Express Edition	Supports all options and features available in the Evaluation Edition. Unlike the Evaluation Edition, the Express Edition does not expire, but does restrict the size of all IQ main dbspaces, permit other incremental license options, and cannot be deployed in a production environment.

Optional Features

SAP Sybase IQ provides significantly faster query performance than traditional database environments. Additional product options extend the power of SAP Sybase IQ to meet specific performance, scalability, security, availability, and manageability requirements.

• Unstructured Data Analytics
  The Unstructured Data Analytics option (IQ_UDA) supports binary large object (BLOB) and character large object (CLOB) storage and retrieval.  - By Cores.
• Advanced Security
  The Advanced Security Option (IQ_SECURITY) protects your environment against unauthorized access.
• Multiplex Grid
  The Multiplex Grid Option lets you add nodes to a multiplex environment, enabling a highly scalable shared disk grid technology that allows. - By nodes.
• Very Large Database Management
  The Very Large Database Management Option (IQ_VLDBMGMT) lets you logically partition very large data sets into smaller subsets. - By TBs.
• In-Database Analytics—Partner Solution Options
  This option provides a versatile, high performance C++ Application Programming Interface (API) that allows users to extend the analytical capabilities of SAP Sybase IQ by plugging in externally built C++ functions. These external C++ functions operate in proximity to the data stored in SAP Sybase IQ and are often executed in a highly parallelized fashion, thereby providing high efficiencies in performance, usability, and total cost of ownership.

• InDatabase Analytics Option
  The InDatabase Analytics Option is a new license type that enables customers to build, deploy and run their own C/C++ User-Defined Functions (UDF). Unlike previous releases, this option is available to all SAP Sybase IQ customers and no longer requires SAP Sybase certification.

[Former Member]

So if you want to use IQ - you must pay for:

When want to using - BLOB, CLOB - fields. For every CPU Core.

When want to adding node(-e) in cluster - option MultiPlex. For every node.

When want to using tables partitioning - option VLDB. For every TB.

Very expensive approach for XLDB.

Is there any plans to remove this strange limitations in IQ?

[Former Member]

Vertica.

Vertica is licensed by the raw TB.

No limitation for CPU Cores, Nodes, etc.

SAP HANA.

HANA is licensed by the RAM.

No limitation for CPU Cores, Nodes, etc.