The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better.

The product should add more business intelligence factors.

They should improve the backup options. There is no backup software support for Sybase IQ. You have to implement your own backup system. For large databases, you need to use disk backup solutions and it is very expensive.

Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups.

It is very hard to find which sessions cause a performance problem. It also has no resource manager to manage resources between consumers.

There could be more documentation and training.

Actually, it is not the product that needs revision but the company itself. Sybase IQ was bought by SAP. They use it, but they don't really advertise and push it correctly. So SAP IQ — from a company standpoint — is not really supported correctly. If they did more to support the product, it would be a more popular solution.

SAP IQ has not introduced more integration with Hadoop so the two products would act in a more tightly coupled way. This would be one of the more important features that they might add. The integration with Hadoop is important because it seems everybody is going towards Hadoop for big data. You also need a system that works well. Hadoop is fast, but SAP IQ is even faster. They each have advantages, so if you can combine them, that would be good. It will work out better for cost and extra storage.

• Admin UI
• Tuning parameters
• Maintenance tool
• UI

DR capabilities need to be improved. For instance, unlike SAP ASE, there is no ability to replicate from IQ to IQ.

Sales and marketing – I just want to elaborate on this a little bit more. The product itself is the best in the industry, which I liked and would like to work with again. IT has a lot less maintenance to support the database and query performance is best; it's very easy to use.

I think the universe should be part of the Sybase IQ tool set.

Yes. The room for improvement would be the marketing of the product, because this product is much better than advertised.

One of my colleagues was working with Adobe, where the Product Management team was using Hadoop. Hadoop was doing a performance test, let's say excessive performance, and X plus X was the performance improvement of the SAP IQ. Thus, SAP really has to really market this product very well because of its patented indexes. Because it's patented, the compression is even far better than SAP HANA. So, they have to improve it and its use, the RLV in memory solution. The RLV is there so they are currently using it just for keeping delta data. Instead, what I would recommend is, you have to take it into the next level and include it in memory data space and in memory database.

Training and marketing are two areas where improvements are needed.

The stability needs improvement. We’ve upgraded through multiple minor revisions because of issues where the database server would crash when attempting to answer a perfectly legal SQL query.

We're

Concurrency and functional error messaging.

Concurrency and functional error messaging.

Very few people are familiar with this technology, as training programs are very expensive.