Channels ▼


Sybase Aims To Redefine Massively Parallel Processing

Sybase has taken the wraps off its release of its Sybase IQ 15.3 beta release. This column-oriented DBMS specifically suited to data warehousing and BI now introduces the PlexQ Distributed Query Platform, a Massively Parallel Processing (MPP) architecture that accelerates highly complex queries by distributing work to many computers in a grid configuration.

Unlike shared-nothing MPP architectures, Sybase claims that PlexQ utilizes a shared-everything approach that dynamically manages and balances query workloads across all the compute nodes in a Sybase IQ MPP configuration. The PlexQ’s "automatic workload rebalancer" works to avoid contention among users for system resources, thereby providing predictable high performance for a spectrum of concurrent workloads.

In theory, this aggressive workload balancing surpasses typical shared-nothing MPP architectures with better concurrency, self-service ad-hoc queries, and independent scale out of compute and storage resources. Sybase states that with this architecture, "PlexQ can exceed Service Level Agreements (SLAs) through simple and flexible resource provisioning that allows nodes to be grouped together as unified images that can be assigned to different application profiles."

Director of analytics product management at Sybase Joydeep Das points out that Sybase IQ 15.3 PlexQ Distributed Query Platform solution offers what the company calls "extreme performance" to enable users to harness the power of multiple compute resources in a Sybase IQ PlexQ environment.

He also claims that this should empower system managers to cost effectively scale out Sybase IQ PlexQ nodes with any popular hardware as user data and query complexities increase. Finally, the platform features more architectural flexibility, which allows system managers to group subsets of compute resources as logical entities to respond to changing user requirements.

Related Reading

More Insights

Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.