SAP Sybase IQ
Very Large Database Management Option
SAP Sybase IQ provides significantly faster query performance than traditional database environments.
Additional product options extend the power of SAP Sybase IQ to meet specific performance, scalability, security, availability, and manageability requirements. The Very Large Database Management Option (IQ_VLDBMGMT) lets you logically partition very large data sets into smaller subsets.
Very Large Database Management (VLDB) enhances the manageability of very large data sets, to partition data logically in a range of values, and to partition data in logical groups of objects called table spaces.
Range partitioning lets you work at a higher level of granularity with the data in your analytics environment by defining manageable subsets that are relevant for a particular set of queries. Tablespaces also let you define more manageable sets of data and treat them as separate databases when ease of administration or other factors require some data be isolated.
The VLDB option provides:
- Range partitioning for greater precision and granularity of data
- Shortened backup and restore cycles
- Logical partitioning for enhanced manageability
- Simplified configured and managed Information Lifecycle Management