IQ Unique Advantages

Sybase IQ offers several unique advantages over a traditional relational database management system (RDBMS):

• Faster. Sybase IQ was architected for reporting, not transactions. It has a column-based structure, as opposed a row-based structure, along with patented indexing technology that allows Sybase IQ to deliver ad-hoc query performance up to 100 times faster than traditional RDBMSs.
• Less Expensive. Sybase IQ also has sophisticated compression algorithms that reduce storage needs anywhere from 30 to 60 percent. Independently audited tests have confirmed that to store 155 Terabytes of raw input data, Sybase IQ required 55 Terabytes of physical storage. OLTP databases are row-based, with additional indexes (data about the data) that explode the data storage requirement. In this example, 200-500 Terabytes of physical storage would be required by an OLTP solution. OLTP databases are for transactions, NOT large searches through Terabytes of data.

• Easier. Sybase IQ is easier to maintain than traditional databases and does not require time- and resource-intensive tuning to obtain excellent performance.
• More Scalable. Sybase IQ offers near-linear user and data scalability to support 100s and 1,000s of users and Terabytes of data.