Sybase's (Dublin, CA) IQ Analytics Server was the first of
the column-store DBMS systems. It is available as a
stand-alone DBMS and as a data warehouse appliance.
Sybase also correctly positions Sybase IQ as a
performance-capable tool for data marts as well as data
warehouses.
Strengths
Sybase IQ achieves data compression ranging from two
to five times compression, depending on the structure of
the data. Because analytics typically makes use of fewer
columns but larger numbers of rows, Sybase IQ performs
very well for analytic applications. The company has been
consistently winning POCs with analytic applications, on
occasion, with a performance of 100 times greater. This
makes Sybase IQ an extremely desirable DBMS platform
for an analytic data mart to optimize and enhance an
organization's overall data warehouse architecture. Over
the past two years, Sybase has increased its Sybase IQ
engineering FTEs by more than 70%, as well as its
marketing/sales staffing — demonstrating significant
commitment.
Sybase IQ: 数据仓库技术的领导者