DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

IQ


SAP IQ ("Intelligent Query"), is a column-based relational database management system designed for business intelligence, data warehousing, and analytical workloads. It employs a column-store architecture to facilitate data compression and ad-hoc query processing.

Twitter
@SybaseIQ
Country of Origin
US
Start Year
1992
Former Names
Expressway 103, SAP Sybase IQ, Sybase IQ
Acquired By
Project Type
Commercial
Written in
C, C++
Embeds / Uses
SQL Anywhere
Inspired By
Model 204
Operating Systems
AIX, HP-UX, Linux, Solaris, Windows
License
Proprietary

Database Entry

IQ


SAP IQ ("Intelligent Query"), is a column-based relational database management system designed for business intelligence, data warehousing, and analytical workloads. It employs a column-store architecture to facilitate data compression and ad-hoc query processing.

History


The project started in the early 1990s as "Expressway 103" by a Massachusetts-based startup. After Sybase's acquisition of Expressway in 1994, they rebranded the system to "Sybase IQ". Development continues under SAP.

The system is credited with pioneering the commercialization of column-store databases.

Compression


Data Model


Indexes


Query Interface


Storage Model


Revision #7 Last Updated: