Sybase IQ is the data store for the enterprise data warehouse. It is an optimized analytics server designed specifically to deliver faster results for business intelligence, data warehouse and reporting solutions on any standard hardware and operating systems.
The features of Sybase IQ are:
Speed
Column-based architecture for low I/O and fast
retrieval.
Query parallelism per node.
Query speed 10X – 100X faster than traditional row-based DBs.
Economy
Supports all standard hardware platforms/disk technologies.
Patented Data Compression
(reduces storage needs up to 90%)
Configurable tablespaces.
Manageability
Range partitioning
Index advisor utility guides index selection for top performance
XML & GUI-based query plan generator for diagnostics
Versatile GUI-based admin console for server management.
Power
One-touch multiplex grid configuration
High performance from any schema
SQL logic deployable via 3GL, stored procedures, or cursors
Supports hundreds or thousands of users & petabytes of data.
Flexibility
Independent compute power and storage capacity scalability
On-the-fly schema changes without query blockage or downtime
Handles structured and unstructured data
Works with industry-leading BI ISV products.
Information Availability
Multi-node loading
Enhanced large table loads
Direct loads from clients
No impact to query performance while loading.
Security
Password authentication/encryption for data-in-flight
