greenplum mysql 比较_Greenplum

Editorial information provided by DB-Engines

NameGreenplum  Xexclude from comparisonMySQL  Xexclude from comparisonVoltDB  Xexclude from comparison

DescriptionAnalytic Database platform built on PostgreSQL. Full name is Pivotal Greenplum Database A logical database in Greenplum is an array of individual PostgreSQL databases working together to present a single database image.Widely used open source RDBMSDistributed In-Memory NewSQL RDBMS Used for OLTP applications with a high frequency of relatively simple transactions, that can hold all their data in memory

Primary database modelRelational DBMS Key/Value like access via memcached API

DB-Engines Ranking measures the popularity of database management systems

DeveloperPivotal Software Inc.Oracle since 2010, originally MySQL AB, then SunVoltDB Inc.

Initial release200519952010

Current release6.7.1, April 20208.0.23 , January 202110.1, October 2020

License Commercial or Open SourceOpen Source Apache 2.0Open Source GPL version 2. Commercial licenses with extended functionallity are availableOpen Source AGPL for Community Edition, commercial license for Enterprise, AWS, and Pro Editions

Cloud-based only Only available as a cloud servicenonono

DBaaS offerings (sponsored links) Database as a Service

Providers of DBaaS offerings, please contact us to be listed.ScaleGrid for MySQL: Fully managed MySQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.

Implementation languageC and C++Java, C++

Server operating systemsLinuxFreeBSD

Linux

OS X

Solaris

WindowsLinux

OS X for development

Data schemeyesyesyes

Typing predefined data types such as float or dateyesyesyes

XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yes since Version 4.2yes

Secondary indexesyesyesyes

SQL Support of SQLyesyes with proprietary extensionsyes only a subset of SQL 99

APIs and other access methodsJDBC

ODBCADO.NET

JDBC

ODBC

Proprietary native APIJava API

JDBC

RESTful HTTP/JSON API

Supported programming languagesC

Java

Perl

Python

RAda

C

C#

C++

D

Delphi

Eiffel

Erlang

Haskell

Java

JavaScript (Node.js)

Objective-C

OCaml

Perl

PHP

Python

Ruby

Scheme

TclC#

C++

Erlang not officially supported

Go

Java

JavaScript Node.js

PHP

Python

Server-side scripts Stored proceduresyesyes proprietary syntaxJava

Triggersyesyesno

Partitioning methods Methods for storing different data on different nodesShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL FabricSharding

Replication methods Methods for redundantly storing data on multiple nodesSource-replica replicationMulti-source replication

Source-replica replicationMulti-source replication

Source-replica replication

MapReduce Offers an API for user-defined Map/Reduce methodsyesnono

Consistency concepts Methods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency

Foreign keys Referential integrityyesyes not for MyISAM storage engineno FOREIGN KEY constraints are not supported

Transaction concepts Support to ensure data integrity after non-atomic manipulations of dataACIDACID not for MyISAM storage engineACID Transactions are executed single-threaded within stored procedures

Concurrency Support for concurrent manipulation of datayesyes table locks or row locks depending on storage engineyes Data access is serialized by the server

Durability Support for making data persistentyesyesyes Snapshots and command logging

In-memory capabilities Is there an option to define some or all structures to be held in-memory only.noyes

User concepts Access controlfine grained access rights according to SQL-standardUsers with fine-grained authorization concept no user groups or rolesUsers and roles with access to stored procedures

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,

and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.

» more

ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure.

» more

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.

» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.

» more

Datadog: Improve MySQL performance by visualizing and identifying errors fast using granular, out-of-the-box dashboards.

» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources

GreenplumMySQLVoltDB