Sybase IQ 15.3 data management

IQ 15.3 aims to overcome the user scalability, application workload and dataset limitations of the current generation of enterprise data warehouse solutions.

It has a shared-everything MPP architecture that scales to support real-time access to thousands of users, multiple mixed workloads and large datasets.

It dynamically balances query workloads across nodes on the grid for parallel processing of complex analytics at speeds claimed to be 10 to 100 times faster than traditional data warehouses.

Enterprises can run complex analytical models and algorithms within the database, eliminating the need for data mining algorithms inside business logic and accelerating overall performance of complex queries.

It also supports the analysis of unstructured data often used in business workflows, such as proprietary document formats, emails and web content and enables fast analysis of unstructured multi-media data within the database, further unifying disparate analysis within a business analytics information platform.

Features include: grid-based MPP framework; distributed query processing; ability to group physical servers in a PlexQ grid into virtual clusters to optimise analytic workloads; built-in web services API and Ruby-on-Rails language driver; multimedia API; InfoPrimer module for loading data into Sybase IQ through extract, load, and transform methodology, web-based administration and monitoring interface uses Control Center to simplify operational tasks for DBAs and provides a thin client interface for ease of Sybase IQ administration.