Sybase IQ Technology Overview White Paper - Bloor Research
Fast facts
Sybase IQ is a column-based relational database that has been designed specifically for analytics and business intelligence applications. It can offer a number of very significant advantages within a data warehousing environment, including performance, scalability and cost of ownership benefits, when compared to conventional approaches.
Although the product has broad applicability, the company targets a number of primary markets. These include:
- Data warehouses for aggregators of data, typically those who offer multi-client data and analytics services.
- Advanced analytics—where there is a significant requirement to support complex and unpredictable queries, either as a data warehouse in its own right or as an analytics accelerator, where Sybase IQ is complementary to an existing warehouse.
- As a report accelerator, offloading high performance reports from operational databases or centralised data warehouses that perform too slowly to meet business needs.
- Applications where there are significant amounts of unstructured elements (for example, documents and images for insurance claims) and where very large quantities of data need to kept on-line—that may be subject to querying—for a considerable period of time.