SAP IQ is currently our bid data database. We have several schemas with billions of rows, and both Oracle and Sybase were a bit slower than we liked. Moving our Data to SAP IQ showed a distinct increase in performance when doing bulk inserts and aggregates of data. We only began implementing SAP IQ about a year ago, and in the first six months, we tested it more than used it. For the past six months, we have been using it and are happy with the results.

If you are loading massive datasets or aggregating huge relational datasets, SAP IQ is incredible. Loading 10 million rows in seconds is incredibly impressive.

We use this columnar relational database software in the business for the purpose of having a data warehouse and also a data mart that would store business data and enable users to run leverage these for intelligent and informed business decisions on a day to day basis. This is the main database that supports our data warehouse.

Does data compression very well, produces query results very quickly, ability to scale up as data volume/size grow in an organization, row level versioning is in memory and hence the speed. It is a very stable product for large enterprises. More detailed documentation on how to use this product in the initial stages would be really welcome.

We use it to warehouse data to log every customer action and call that flows through our network. It's also referenced for customer billing and is replicated across. We do have a mandated requirement to keep this data available for 7 years.

IQ itself solves the big issue of warehousing large amounts of data.

It is very well suited for large warehousing applications. It is less suited for databases that need to do computational work.