Features
Sybase IQ delivers answers to your users’ questions 10 to 100 times faster than traditional data warehouse technologies, regardless of the number of users or queries. Ad hoc query results are returned in seconds and minutes, instead of hours or days with traditional transactional technologies. And because Sybase IQ can load data in real-time with virtually no impact on performance, your users can efficiently act based on current information to make the best-informed decisions possible.
Sybase IQ’s reduced development time, overhead, storage costs, and maintenance requirements, combined with faster data loads and blazingly fast query response times result in an ROI you have previously only dreamed about.
Answers in the Blink of an Eye
We know you need answers now—regardless of how much data you need to analyze. Regardless of how much data is in your warehouse or reporting system. Regardless of how many users are running queries. Opportunity is a perishable commodity. With Sybase IQ, transactional data can be quickly imported into your analytical system, putting current information in the hands of your users. That means faster decisions and a serious competitive edge.
The Scalability and Flexibility You Require
Sybase IQ was designed and built from the ground up to scale seamlessly from very small to very, very large. It has been thoroughly audited and tested for:
- Thousands of users and queries
- Dozens of nodes and hundreds of CPUs across multiple server generations
- Over 155 Terabytes of input data
Scalability is simply not an issue. You can start small and grow large or start large and grow massive.
All at a Dramatically Lower Total Cost of Ownership
We know you are not looking for a solution at any price. We understand that every IT expenditure must add positive, measurable business value without incurring enormous added expense today or over time. Here, too, Sybase IQ is tuned to your requirements:
Storage Savings/Compression
Sybase IQ compresses input data by as much as 70%. This provides a major reduction in storage costs versus a conventional transactional-based data warehouse or reporting system. In an audited benchmark by TPC auditor Francois Raab, Sybase IQ loaded 155 Terabytes of input data and compressed it into a 55 Terabyte data warehouse. Using a traditional relational database, the same 155 Terabytes would explode to 500 to 1,000 Terabytes.
Reduced Maintenance Costs
By eliminating the need to tune for every query and devote scarce time and resources to adding new fields and managing everyday data growth, Sybase IQ eliminates data overhead and reduces maintenance and its attendant costs.
Accelerated Deployment
Since Sybase IQ is architected from the ground up to support reporting and analytics, it takes only a fraction of the time to deploy, compared to traditional databases. With Sybase IQ, there is no need to re-engineer the database for analytics. That means faster results for your organization and reduced IT resource project costs.
Leverage Your Existing Investments
Like all Sybase technology, Sybase IQ is built on open standards, ensuring easy integration and interoperability with your existing enterprise IT assets.
Revolutionizing the World of Reporting and Business Intelligence
Sybase IQ has revolutionized the world of reporting and analytics—offering unprecedented speed, storage efficiency, and reduced maintenance and hardware costs. With it, data warehousing and reporting projects are routinely deployed successfully, within budget, and on time.
With Sybase IQ, you can analyze customer profitability, market penetration, sales effectiveness, and operational efficiency. Sybase IQ has put real-time analytics and reporting within the reach of any size enterprise.
Continue reading Technical Overview »