Data Warehousing with Sybase IQ

Sybase IQ - The high-performance, small footprint decision support RDBMS.

Project Overview - What is Sybase IQ and why is it needed?

Sybase IQ is a high-performance decision support RDBMS designed specifically for data warehousing. Sybase IQ has a small footprint, both in computing resources and in data warehouse budget.

Data warehousing has been a hot topic for more a couple of decades, however, to successfully implement a data warehouse that meets the performance requirements expected has been challenging for the majority of implementations. To make the lofty goal of providing complex query capability with high performance, Sybase IQ uses a column-based storage technology that is inherently faster than the industry standard RDBMS's.

Sybase positions IQ specifically as a data warehouse server which can be used in conjunction with any other RDBMS for reporting, data archiving, or business intelligence.

Sybase IQ makes the performance goals "low hanging" fruit for this implementation. We are upgrading Sybase IQ 12.6 to IQ 15.3 and implementing a basic reporting server for a client. See the upgrade section for details on this project.

Sybase IQ discussion - these sections detail our experiences:

• Sybase IQ 12.6 to IQ 15.3 upgrade
• Loading data to the IQ server
• Converting existing ASE 12.5.4 reports to IQ 15.3
• Performance tuning
  • Indexing
  • Partitioning
  • Multiplex
• Thinking in IQ - crossing over from ASE