Sybase IQ Gains Beefier Analysis Capabilities - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Software // Information Management
03:43 PM
Connect Directly

Sybase IQ Gains Beefier Analysis Capabilities

Analytic database graduates from marts to enterprise data warehouse needs through massively parallel processing, distributed querying, and an API for unstructured data.

8 Big Data Deployments In Detail
(click image for larger view)
Slideshow: 8 Big DataDeployments In Detail
More data, more data types, more queries, and more users. Sybase says it can handle it all with Sybase IQ 15.3, an upgraded analytic database released late last week.

An upgrade path is particularly important for IQ since the database has been around for more than a decade and is in use by more than 2,000 customers. Since data stores among these customers and potential new customers are now growing into the hundreds of terabytes, version 15.3 is aimed at improving scalability and performance with a PlexQ massively parallel processing (MPP) option. PlexQ supports a grid of CPU processing power--deployed on third-party, commodity hardware--that's said to deliver 12 times faster performance compared with existing IQ deployments.

Like other column-store databases (like HP Vertica and ParAccel), Sybase IQ has been used mostly for focused, data-mart-style deployments. Competition has led these and other vendors to add features to support broader, enterprise data warehouse-style deployments covering more data, more queries, and more users.

To handle diverse analyses, 15.3 adds distributed processing capabilities that execute queries across multiple CPUs in a PlexQ grid. The feature is said to automatically balance workloads, but to ensure fastest-possible processing for essential queries, PlexQ also includes a Logical Servers feature that lets administrators virtualize and assign clusters of server capacity to specific users, departments, or queries.

A key difference between Sybase IQ and most other MPP-capable products is that it remains a shared-everything, rather than shared-nothing environment. The downside of shared everything is that processors can compete to access the shared pool of storage (usually a storage-area network), and that contention can degrade query performance. David Jonker, product marketing manager for Sybase IQ, said the upside of the shared-everything approach is that it's more flexible in terms of the types of queries that can be optimized.

"In the shared-nothing approach, you have to commit partitioning and storing the data on certain nodes, so all the machines don't have access to all the data," Jonker said. "With shared-everything, you can get all your machines querying the SAN and returning the results of a specific query."

Organizations making use of big data are often exploiting previously underused data, including unstructured information. Thus, Sybase IQ 15.3 adds a multimedia API that lets users analyze images, audio, video, and other multimedia content alongside structured information. For example, Jonker said insurers are analyzing structured claim data alongside ultrasound images, accident photographs, and scanned documents to detect fake or duplicated documents and patterns of fraud.

In short, Sybase has broadened the analysis possibilities for new and existing customers with 15.3, providing more data headroom, flexibility to add new data, and scalability to support more queries and users. IQ already has deployments with as much as a petabyte of user-accessible data (before compression in the database) and as many as 3,000 users, according to Jonker. Once deployed, PlexQ will increase those top-end specs, he said.

The 15.3 upgrade is available immediately. PlexQ is an optional feature that includes distributed query processing and logical server management capabilities. Prices were not disclosed.

The economies of storage networking have changed dramatically, especially in the options available for small and midsize enterprises. We analyze SME responses to our 2011 State of Enterprise Storage Survey and discuss which techs will best serve these businesses. Download our report now. (Free registration required.)

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

11 Things IT Professionals Wish They Knew Earlier in Their Careers
Lisa Morgan, Freelance Writer,  4/6/2021
Time to Shift Your Job Search Out of Neutral
Jessica Davis, Senior Editor, Enterprise Apps,  3/31/2021
Does Identity Hinder Hybrid-Cloud and Multi-Cloud Adoption?
Joao-Pierre S. Ruth, Senior Writer,  4/1/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Successful Strategies for Digital Transformation
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll