|
Sybase IQ
|
- Column-oriented architecture accelerates complex queries and reduces storage requirement
- Architected to handle large numbers of concurrent users
- Open architecture with flexible scalability using commodity hardware
- Enterprise-class functionality and strong track record in analytics
|
|
Traditional Databases
|
- Designed to handle transactions, not analytics
- Poor reporting and analytics performance with traditional OLTP architecture
- Requires numerous indexes, summaries and aggregates, resulting in data bloat and necessitating significant administrative overhead
|
|
Appliances
|
- Hardware-based brute force approach
- Customers are locked into a proprietary architecture which requires sizable investment and ongoing costs
- Only scales in monolithic units
- Weaker performance with heavy concurrent usage
|
|
Alternative Column-Based Solutions
|
- Lacking in product maturity
- Not enterprise-class: deficiencies in mixed workload handling, query optimization, security, and disaster recovery functionality
- Few customers and underdeveloped product ecosystem
|