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 07ed45899a3a45e884a7be60b7bb1af2.pngA 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 07ed45899a3a45e884a7be60b7bb1af2.pngUsed for OLTP applications with a high frequency of relatively simple transactions, that can hold all their data in memory

Primary database modelRelational DBMS 07ed45899a3a45e884a7be60b7bb1af2.pngKey/Value like access via memcached API

DB-Engines Ranking 07ed45899a3a45e884a7be60b7bb1af2.pngmeasures the popularity of database management systems57b022532c14d991413ae42a96131919.png

DeveloperPivotal Software Inc.Oracle 07ed45899a3a45e884a7be60b7bb1af2.pngsince 2010, originally MySQL AB, then SunVoltDB Inc.

Initial release200519952010

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

License 07ed45899a3a45e884a7be60b7bb1af2.pngCommercial or Open SourceOpen Source 07ed45899a3a45e884a7be60b7bb1af2.pngApache 2.0Open Source 07ed45899a3a45e884a7be60b7bb1af2.pngGPL version 2. Commercial licenses with extended functionallity are availableOpen Source 07ed45899a3a45e884a7be60b7bb1af2.pngAGPL for Community Edition, commercial license for Enterprise, AWS, and Pro Editions

Cloud-based only 07ed45899a3a45e884a7be60b7bb1af2.pngOnly available as a cloud servicenonono

DBaaS offerings (sponsored links) 07ed45899a3a45e884a7be60b7bb1af2.pngDatabase 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 07ed45899a3a45e884a7be60b7bb1af2.pngfor development

Data schemeyesyesyes

Typing 07ed45899a3a45e884a7be60b7bb1af2.pngpredefined data types such as float or dateyesyesyes

XML support 07ed45899a3a45e884a7be60b7bb1af2.pngSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yes 07ed45899a3a45e884a7be60b7bb1af2.pngsince Version 4.2yes

Secondary indexesyesyesyes

SQL 07ed45899a3a45e884a7be60b7bb1af2.pngSupport of SQLyesyes 07ed45899a3a45e884a7be60b7bb1af2.pngwith proprietary extensionsyes 07ed45899a3a45e884a7be60b7bb1af2.pngonly 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 07ed45899a3a45e884a7be60b7bb1af2.pngnot officially supported

Go

Java

JavaScript 07ed45899a3a45e884a7be60b7bb1af2.pngNode.js

PHP

Python

Server-side scripts 07ed45899a3a45e884a7be60b7bb1af2.pngStored proceduresyesyes 07ed45899a3a45e884a7be60b7bb1af2.pngproprietary syntaxJava

Triggersyesyesno

Partitioning methods 07ed45899a3a45e884a7be60b7bb1af2.pngMethods for storing different data on different nodesShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL FabricSharding

Replication methods 07ed45899a3a45e884a7be60b7bb1af2.pngMethods for redundantly storing data on multiple nodesSource-replica replicationMulti-source replication

Source-replica replicationMulti-source replication

Source-replica replication

MapReduce 07ed45899a3a45e884a7be60b7bb1af2.pngOffers an API for user-defined Map/Reduce methodsyesnono

Consistency concepts 07ed45899a3a45e884a7be60b7bb1af2.pngMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency

Foreign keys 07ed45899a3a45e884a7be60b7bb1af2.pngReferential integrityyesyes 07ed45899a3a45e884a7be60b7bb1af2.pngnot for MyISAM storage engineno 07ed45899a3a45e884a7be60b7bb1af2.pngFOREIGN KEY constraints are not supported

Transaction concepts 07ed45899a3a45e884a7be60b7bb1af2.pngSupport to ensure data integrity after non-atomic manipulations of dataACIDACID 07ed45899a3a45e884a7be60b7bb1af2.pngnot for MyISAM storage engineACID 07ed45899a3a45e884a7be60b7bb1af2.pngTransactions are executed single-threaded within stored procedures

Concurrency 07ed45899a3a45e884a7be60b7bb1af2.pngSupport for concurrent manipulation of datayesyes 07ed45899a3a45e884a7be60b7bb1af2.pngtable locks or row locks depending on storage engineyes 07ed45899a3a45e884a7be60b7bb1af2.pngData access is serialized by the server

Durability 07ed45899a3a45e884a7be60b7bb1af2.pngSupport for making data persistentyesyesyes 07ed45899a3a45e884a7be60b7bb1af2.pngSnapshots and command logging

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

User concepts 07ed45899a3a45e884a7be60b7bb1af2.pngAccess controlfine grained access rights according to SQL-standardUsers with fine-grained authorization concept 07ed45899a3a45e884a7be60b7bb1af2.pngno 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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值