SAP IQ

SAP IQ (known also as Sybase IQ or Sybase IQ) is a columnar, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts.

SAP IQ bases its performance on columnar data engine, like many competing solutions.

SAP IQ

data types we support

Integral
bigint
int (integer)
smallint
tinyint
ubigint
uint
usmallint
decimal
decimal (numeric)
double (double precision)
float (real)
money
smallmoney
text
char
text
unichar (nchar)
unitext
univarchar (nvarchar)
varchar
Binary
binary
bit
timestamp
varbinary
Date/Time
date
datetime (bigdatetime)
smalldatetime
time (bigtime)
Large objects
image
text
unitext
Other
boolean
timespan