Basic Data Warehouse Capabilities
Data warehouses has evolve over time, nowadays is common to have tables with billions of rows, to integrate unstructured data in the data warehouse and to program internal and external function in low level and powerful programming languages like C, C++ or Java.
SAP Sybase IQ has all these capabilities, they are offered as options requiring additional licenses.
In my humble opinion, SAP should include (at least as part of the SAP Sybase IQ enterprise license), options like Very Large Database Management (VLDB) that allow for table partitioning and on different dbspaces, unlimited storage capacity, Unstructured Data Analytics (UDA) that allow the storage of unstructured data and data mining and In-database Analytics Option that allow to program functions with C or C++.
These additions will empower SAP Sybase IQ developers/users to develop data warehouse and BI solutions better tailored to the current need of the business world.
This blog was originally posted on ARBIME on Sept. 11, 2013.
I would be happy if SAP/Sybase sales & consulting would stop pushing IQ as an OLTP system for big databases. I don't think many people in sales/consulting understand the difference between a DBMS and a Data Warehouse.
Very agree about SAP should include...
If you want to make IQ popular, be ready to get low cost license model. Rule - Less price - more clients.
Columnar epoch has began. (SAP HANA, Microsoft SQL, Oracle 12c and other) - be flexible or die.