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.