DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Informationen zu relationalen und NoSQL DatenbankmanagementsystemenEin Service von solid IT

DBMS > Datomic vs. Greenplum vs. Microsoft Azure Synapse Analytics vs. MongoDB vs. SingleStore

Vergleich der Systemeigenschaften Datomic vs. Greenplum vs. Microsoft Azure Synapse Analytics vs. MongoDB vs. SingleStore

Redaktionelle Informationen bereitgestellt von DB-Engines
NameDatomic  Xaus Vergleich ausschliessenGreenplum  Xaus Vergleich ausschliessenMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xaus Vergleich ausschliessenMongoDB  Xaus Vergleich ausschliessenSingleStore infoformer name was MemSQL  Xaus Vergleich ausschliessen
KurzbeschreibungDBMS mit Fokus auf der Abspeicherung von historischen Daten und 'point-in-time queries'. Es verwendet Fremdsysteme zur Speicherung der DatenAnalytic Database platform built on PostgreSQL. Full name is Pivotal Greenplum Database infoA logical database in Greenplum is an array of individual PostgreSQL databases working together to present a single database image.Elastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerEiner der meistverwendeten Document StoresMySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in one single table type
Primäres DatenbankmodellRelational DBMSRelational DBMSRelational DBMSDocument StoreRelational DBMS
Sekundäre DatenbankmodelleDocument Store
Spatial DBMS
Spatial DBMS
Suchmaschine infointegrated Lucene index, currently in MongoDB Atlas only.
Time Series DBMS infoTime Series Collections introduced in Release 5.0
Document Store
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomisst die Popularität von Datenbankmanagement- systemenranking trend
Trend Chart
Punkte1,70
Rang#138  Overall
#68  Relational DBMS
Punkte13,36
Rang#44  Overall
#28  Relational DBMS
Punkte20,66
Rang#36  Overall
#22  Relational DBMS
Punkte478,24
Rang#5  Overall
#1  Document Stores
Punkte7,04
Rang#61  Overall
#36  Relational DBMS
Websitewww.datomic.comgreenplum.orgazure.microsoft.com/­services/­synapse-analyticswww.mongodb.comwww.singlestore.com
Technische Dokumentationdocs.datomic.comdocs.greenplum.orgdocs.microsoft.com/­azure/­synapse-analyticsdocs.mongodb.com/­manualdocs.singlestore.com
EntwicklerCognitectPivotal Software Inc.MicrosoftMongoDB, IncSingleStore Inc.
Erscheinungsjahr20122005201620092013
Aktuelle Version1.0.6362, Jaenner 20226.7.1, April 20205.0.8, April 20227.6, November 2021
Lizenz infoCommercial or Open Sourcekommerziell infoLimitierte Edition gratisOpen Source infoApache 2.0kommerziellOpen Source infoMongoDB Inc.'s Server Side Public License v1. Prior versions were published under GNU AGPL v3.0. Commercial licenses are also available.kommerziell infofree developer edition available
Ausschließlich ein Cloud-Service infoNur als Cloud-Service verfügbarneinneinjanein infoMongoDB available as DBaaS (MongoDB Atlas)nein
DBaaS Angebote (gesponserte Links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • ScaleGrid for MongoDB: Fully managed hosting for MongoDB database on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
  • MongoDB Atlas: Global multi-cloud database with unmatched data distribution and mobility across AWS, Azure, and Google Cloud, built-in automation for resource and workload optimization, and so much more.
SingleStore Managed Service: The world's fastest, modern cloud database for both operational (OLTP) and analytical (OLAP) workloads. Available instantly with multi-cloud and hybrid-cloud capabilities
ImplementierungsspracheJava, ClojureC++C++C++, Go
Server BetriebssystemeAlle Betriebssysteme mit einer Java VMLinuxgehostetLinux
OS X
Solaris
Windows
Linux info64 bit version required
Datenschemajajajaschemafrei infoObwohl schemafrei haben Dokumente einer Collection dennoch häufig die selbe Strukturja
Typisierung infovordefinierte Datentypen, z.B. float oder datejajajaja infostring, integer, double, decimal, boolean, date, object_id, geospatialja
XML Unterstützung infoVerarbeitung von Daten in XML Format, beispielsweise Speicherung von XML-Strukturen und/oder Unterstützung von XPath, XQuery, XSLTneinja infoseit Version 4.2neinnein
Sekundärindizesjajajajaja
SQL infoSupport of SQLneinjajaRead-only SQL queries via the MongoDB Connector for BIyes infobut no triggers and foreign keys
APIs und andere ZugriffskonzepteRESTful HTTP APIJDBC
ODBC
ADO.NET
JDBC
ODBC
Proprietäres Protokoll basierend auf JSONCluster Management API infoas HTTP Rest and CLI
HTTP API
JDBC
ODBC
Unterstützte ProgrammiersprachenClojure
Java
C
Java
Perl
Python
R
C#
Java
PHP
Actionscript infoinoffizielle Driver
C
C#
C++
Clojure infoinoffizielle Driver
ColdFusion infoinoffizielle Driver
D infoinoffizielle Driver
Dart infoinoffizielle Driver
Delphi infoinoffizielle Driver
Erlang
Go
Groovy infoinoffizielle Driver
Haskell
Java
JavaScript
Lisp infoinoffizielle Driver
Lua infoinoffizielle Driver
MatLab infoinoffizielle Driver
Perl
PHP
PowerShell infoinoffizielle Driver
Prolog infoinoffizielle Driver
Python
R infoinoffizielle Driver
Ruby
Rust
Scala
Smalltalk infoinoffizielle Driver
Swift
Bash
C
C#
Java
JavaScript (Node.js)
Python
Server-seitige Scripts infoStored Proceduresja infoTransaction FunctionsjaTransact SQLJavaScriptja
TriggersBy using transaction functionsjaneinja infoin MongoDB Atlas onlynein
Partitionierungsmechanismen infoMethoden zum Speichern von unterschiedlichen Daten auf unterschiedlichen Knotenkeine infoBut extensive use of caching in the application peersShardingSharding, horizontal partitioningSharding infoPartitioned by hashed, ranged, or zoned sharding keys. Live resharding allows users to change their shard keys as an online operation with zero downtime.Sharding infohash partitioning
Replikationsmechanismen infoMethoden zum redundanten Speichern von Daten auf mehreren Knotenkeine infoBut extensive use of caching in the application peersSource-Replica ReplikationjaMulti-Source deployments with MongoDB Atlas Global Clusters
Source-Replica Replikation
Source-Replica Replikation infostores two copies of each physical data partition on two separate nodes
MapReduce infoBietet ein API für Map/Reduce Operationenneinjaneinjanein infocan define user-defined aggregate functions for map-reduce-style calculations
Konsistenzkonzept infoMethoden zur Sicherstellung der Konsistenz in einem verteilten SystemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyEventual Consistency
Immediate Consistency infobei jedem Schreibvorgang individuell einstellbar
Immediate Consistency
Fremdschlüssel inforeferenzielle Integritätneinjanein infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsnein infoNormalerweise nicht gebraucht, abgeschwächte Variante mit DBRefnein
Transaktionskonzept infoUnterstützung zur Sicherstellung der Datenintegrität bei nicht-atomaren DatenmanipulationenACIDACIDACIDMulti-document ACID Transactions with snapshot isolationACID
Concurrency infoUnterstützung von gleichzeitig ausgeführten Datenmanipulationenjajajajayes, multi-version concurrency control (MVCC)
Durability infoDauerhafte Speicherung der Datenja infousing external storage systems (e.g. Cassandra, DynamoDB, PostgreSQL, Couchbase and others)jajaja infooptional, enabled by defaultja infoAll updates are persistent, including those to disk-based columnstores and memory-based row stores. Transaction commits are supported via write-ahead log.
In-Memory Unterstützung infoGibt es Möglichkeiten einige oder alle Strukturen nur im Hauptspeicher zu haltenja inforecommended only for testing and developmentneinja infoIn-memory storage engine introduced with MongoDB version 3.2ja
Berechtigungskonzept infoZugriffskontrolleneinBenutzer mit feingranularem Berechtigungskonzept entsprechend SQL-StandardjaZugriffsrechte für Benutzer und RollenFine grained access control via users, groups and roles
Weitere Informationen bereitgestellt vom Systemhersteller
DatomicGreenplumMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseMongoDBSingleStore infoformer name was MemSQL
Specific characteristicsMongoDB’s application data platform provides developers a unified interface to power...
» mehr
SingleStore offers a fully-managed , distributed, highly-scalable SQL database designed...
» mehr
Competitive advantagesThe MongoDB platform can be used by developers building transactional, operational,...
» mehr
SingleStore’s competitive advantages include: Easy and Simplified Architecture with...
» mehr
Typical application scenariosInternet of Things and Time Series (Bosch, Jaguar Land Rover) Mobile (The Weather...
» mehr
Driving Fast Analytics: SingleStore delivers the fastest and most scalable reporting...
» mehr
Key customersADP, Adobe, Amadeus, AstraZeneca, Auto Trader, Barclays, BBVA, Bosch, Cisco, CERN,...
» mehr
IEX Cloud : Improves Financial Data Distribution Speed 15x with Singlestore DB Comcast,...
» mehr
Market metrics200+ million downloads, over 1.5M Atlas database clusters under management handling...
» mehr
Customers in various industries worldwide including US and International Industry...
» mehr
Licensing and pricing modelsMongoDB database server: Server-Side Public License (SSPL) . Commercial licenses...
» mehr
F ree Tier and Enterprise Edition
» mehr

Wir laden Vertreter der Systemhersteller ein uns zu kontaktieren, um die Systeminformationen zu aktualisieren und zu ergänzen,
sowie um Herstellerinformationen wie Schlüsselkunden, Vorteile gegenüber Konkurrenten und Marktmetriken anzuzeigen.

Zugehörige Produkte und Dienstleistungen
DrittanbieterNavicat for MongoDB gives you a highly effective GUI interface for MongoDB database management, administration and development.
» mehr

Percona: Database problems? Not on your watch.
Databases run better with Percona.
» mehr

CData: Connect to Big Data & NoSQL through standard Drivers.
» mehr

Wir laden Vertreter von Anbietern von zugehörigen Produkten ein uns zu kontaktieren, um hier Informationen über ihre Angebote zu präsentieren.

Weitere Ressourcen
DatomicGreenplumMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseMongoDBSingleStore infoformer name was MemSQL
DB-Engines Blog Posts

Snowflake is the DBMS of the Year 2021
3. Januar 2022, Paul Andlinger, Matthias Gelbmann

PostgreSQL is the DBMS of the Year 2020
4. Januar 2021, Paul Andlinger, Matthias Gelbmann

PostgreSQL is the DBMS of the Year 2018
2. Januar 2019, Paul Andlinger, Matthias Gelbmann

alle anzeigen

SingleStore: The Increasing Momentum of Multi-Model Database Systems
14. Februar 2022,  Akmal Chaudhri, SingleStore (sponsor) 

alle anzeigen

Erwähnungen in aktuellen Nachrichten

The Datomic Information Model
1. Februar 2013, InfoQ.com

The Architecture of Datomic
2. November 2012, InfoQ.com

Atomic Layer Deposition Equipment (ALD) Market Size, Geography Trends And Analysis of Leading Market Players 2022-2027|ASM International, Tokyo Electron, Lam Research – The Daily Vale
24. Mai 2022, The Daily Vale

Lucas Cavalcanti on Using Clojure, Microservices, Hexagonal Architecture and Public Cloud at Nubank
16. August 2021, InfoQ.com

Brazil's Nubank Acquires US Software Firm Cognitect
30. Juli 2020, Nearshore Americas

bereitgestellt von Google News

Pivotal Greenplum Analytic Database Adds Multicloud Support
18. September 2017, SDxCentral

Capitalizing on Analytics and AI at Dell Technologies
8. April 2021, CIO

Mature MADlib Moves Up Apache Development Chain
10. Oktober 2017, Datanami

Has the time finally come for PostgreSQL?
20. April 2018, ZDNet

Big Data Suite Goes Open Source
17. Februar 2015, CIO

bereitgestellt von Google News

Microsoft Releases Security Advisory for Azure Data Factory and Azure Synapse Pipelines | CISA
10. Mai 2022, US-CERT

Microsoft Touts IntelliJ IDE from JetBrains for Azure Development
29. April 2022, Visual Studio Magazine

Sponsored post: Consumers demand personalization. A unified data platform can help.
19. Mai 2022, TechCrunch

Vulnerability mitigated in the third-party Data Connector used in Azure Synapse pipelines and Azure Data Factory (CVE-2022-29972)
9. Mai 2022, IT Security News

Leading Global Logistics Company Completes Milestone in Data Platform Modernization with Datometry
18. Mai 2022, PR Newswire

bereitgestellt von Google News

Swelling losses haven't held back gains for MongoDB (NASDAQ:MDB) shareholders since they're up 78% over 3 years
23. Mai 2022, Simply Wall St

MongoDB: A Software Developers Perspective (NASDAQ:MDB)
28. April 2022, Seeking Alpha

MongoDB just opened a hybrid Philly office for its local employees
11. Mai 2022, Technical.ly

How to Set Up MongoDB Cluster in the Cloud for Free - MUO
12. Mai 2022, MakeUseOf

MongoDB's document-oriented model strikes a chord with developers
11. Mai 2022, SiliconANGLE News

bereitgestellt von Google News

SingleStore will measure your app's 'data intensity' – Blocks and Files
25. April 2022, Blocks and Files

SingleStore Leads Database Industry With Four Top Rated 2022 Awards From TrustRadius
12. Mai 2022, Business Wire

Storage facing trillion-row database apocalypse – Blocks and Files
28. April 2022, Blocks and Files

Real-time database startup Imply reaches unicorn status with $100M infusion
17. Mai 2022, TechCrunch

Real-time database platform SingleStore raises $80M more, now at a $940M valuation
8. September 2021, TechCrunch

bereitgestellt von Google News

Jobangebote

Sr. Backend Engineer .NET (REMOTE)
Railsbank, Houston, TX

Senior Business Intelligence Developer
IQuasar, Washington, DC

Data Scientist
Analytical Flavor Systems, Inc, Remote

Member of Technical Staff - Query Processing - Tanzu Greenplum Database - Opportunity for Working Remotely Washington, D.C.
VMware, Washington, DC

Member of Technical Staff – Greenplum Database Internals/Server - Opportunity for Working Remotely Palo Alto, CA
VMware, Palo Alto, CA

Member of Technical Staff - Query Processing - Tanzu Greenplum Database - Opportunity for Working Remotely Austin, TX
VMware, Austin, TX

Member of Technical Staff – Greenplum Database Internals/Server - Opportunity for Working Remotely San Francisco, CA
VMware, San Francisco, CA

Member of Technical Staff - Query Processing - Tanzu Greenplum Database - Opportunity for Working Remotely Detroit, MI
VMware, Detroit, MI

Support Engineer - Azure Synapse
Microsoft, Issaquah, WA

Energy / V2X Software Data Engineer - Azure Synapse/Snowflake - V2G
General Motors, Warren, MI

Cloud Engineer, Azure Consultant (Remote Possible)
Piper Companies, King of Prussia, PA

Energy / V2X Software Data Engineer - Azure Synapse/Snowflake - V2G
General Motors, Roswell, GA

Product Marketing Manager, Azure Synapse Analytics
Microsoft, Redmond, WA

MongoDB
State Tech, Remote

MongoDB Database Engineer (work from home)
Cigna, St. Louis, MO

Technical Lead - Full Stack (NodeJS, Angular, MongoDB, JS)
Irisidea TechSolutions Pvt Ltd, Remote

Jr. QA Analyst Trainee
SQA², Los Alamitos, CA

Software Test Engineer (entry-level)
Real-Time Technology Solutions, Remote

Software Engineer, Frontend - University Graduate
SingleStore, San Francisco, CA

Software Engineer, Frontend - University Graduate
SingleStore, Seattle, WA

REMOTE - ADVISOR, DATABASE ADMINISTRATOR -TEXAS
MAGRABBIT, Austin, TX

Software Engineer, Frontend - University Graduate
SingleStore, Raleigh, NC

Software Engineer II (backend)
AT&T, Boston, MA

jobs by Indeed



Teilen sie diese Seite mit ihrem Netzwerk

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Redis logo

The world’s most loved real‑time data platform.
Try free

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Präsentieren Sie hier Ihr Produkt