Sybase Iq

"Unlike virtually every other relational database product, Sybase IQ stores data tables as sections of columns of data rather than as rows of data. This has a number of advantages; if a search is being done for items matching a particular value in a column of data, only the storage objects corresponding to that data column within the table need to be accessed. A row-based database would have to read the whole table top to bottom.

Additionally, the column-based storage enables IQ to compress data efficiently on the fly; as each column is made up of a number of records of the same data type and size, compression can be very efficient and rapid. [1]

Sybase IQ has been tested to total data set sizes of one trillion rows and 155 terabytes of input data. The built-in compression reduced actual file storage requirements to only 55 terabytes"

Subject:	Column Oriented
Subject:	VLDB
Subject:	Data Warehousing
Vendor:	Sybase