List the RDBMSs that are supporting parallel operations / Parallel processing enabled RDBMSs / List of RDBMSs that are providing parallelism
List of RDBMSs that support parallel operations
RDBMS
|
Developer
|
Description
|
Sybase
|
·
It is a relational model database server product.
·
Commonly known as Sybase DB.
·
Available for Unix and Windows.
·
Since version 11.5, ASE has supported intra-query
parallelism.
|
|
Clustrix, Inc.
|
·
They are the developer of NewSQL database.
·
Clustrix offers a scale-out SQL database that lets
you simply add more nodes to your cluster as demand grows.
·
ClustrixDB employs massively parallel processing
(MPP) across its distributed cluster to parallelize and distribute SQL
queries, and uses all available resources of the cluster to accelerate the
queries.
|
|
IBM
|
·
IBM employed MPP to parallelize queries.
·
Shared Nothing Architecture is used.
·
DB2 can use two different methods for achieving query
parallelism: I/O or CPU.
|
|
EXASOL
|
·
EXASolution is an in-memory, column-oriented RDBMS.
·
It is a parallelized RDBMS runs on cluster of
standard hardware servers.
·
Shared nothing architecture is used.
·
Massively Parallel Processing (MPP)
·
Highly scalable.
|
|
Available under BSD license.
|
·
Written in Java
·
Fully mutithreaded
|
|
Informix Dynamic Server
|
IBM
|
·
Uses Parallel Database Query (PDQ) feature to run
queries in parallel.
·
PDQ along with table
fragmentation feature works well.
·
Uses combination of shared memory and shared nothing
architecture
|
Microsoft
|
·
By default, SQL Server will use all available CPUs
during query execution
·
Massively Parallel Processing
·
Shared nothing architecture
|
|
MonetDB Developer team
|
·
Open source
·
Column-oriented DBMS
·
Designed for multi-core parallel execution on
desktops
|
|
Oracle Corporation
|
·
Relies on Shared everything architecture
·
Oracle can flexibly parallelize almost all operations
in various ways and degrees, independent of the underlying data layout without
overloading the system.
·
Massively Parallel Processing
|
|
PostgreSQL Global Development Group
|
·
Postgres currently supports full parallelism in client-side code
·
Implements intraquery parallelism with threads.
·
Still in process to a complete parallelism support
like Oracle or DB2.
|
|
SAP (Systems, Applications & Products
in Data Processing)
*world’s 3rd largest software
company
|
·
It supports inter-query and intra-query parallelism
·
It can assign multiple threads to a single request,
thus achieving intra-query parallelism.
·
Each request can run on a single thread and execute
on a single processor, thus achieving inter-query parallelism
|
|
Public type company
|
·
Teradata RDBMS is designed for parallelism
·
The virtual processor (VPROC) is the basic unit of
parallelism
·
Teradata PT (Teradata Parallel Transporter) provides
parallelism support for data warehouse.
·
Teradata PT supports Pipeline, Data, and Multiple
parallelism
|
No comments:
Post a Comment