DBMS > MongoDB vs. PostgreSQL vs. ScyllaDB vs. TiDB vs. VoltDB
Vergleich der Systemeigenschaften MongoDB vs. PostgreSQL vs. ScyllaDB vs. TiDB vs. VoltDB
Redaktionelle Informationen bereitgestellt von DB-Engines | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Name | MongoDB Xaus Vergleich ausschliessen | PostgreSQL Xaus Vergleich ausschliessen | ScyllaDB Xaus Vergleich ausschliessen | TiDB Xaus Vergleich ausschliessen | VoltDB Xaus Vergleich ausschliessen | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Kurzbeschreibung | Einer der meistverwendeten Document Stores | Weit verbreitetes, allgemein einsetzbares Open Source RDBMS Entwickelt als objektorientiertes DBMS, im Laufe der Zeit um 'Standards' wie SQL erweitert | Cassandra and DynamoDB compatible wide column store | TiDB is an open source distributed SQL database that supports Hybrid Transactional/Analytical Processing (HTAP) workloads. It is MySQL compatible and features horizontal scalability, strong consistency, and high availability. | Verteilte In-Memory NewSQL RDBMS Verwendet für OLTP Applikationen mit einer hohen Frequenz an relativ einfachen Transaktionen, die alle Daten im Hauptspeicher halten können | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Primäres Datenbankmodell | Document Store | Relational DBMS mit objektorientierten Erweiterungen, z.B.: benutzerdefinierte Datentypen/Funktionen und Vererbung. Key/Value handling mit hstore Modul. | Wide Column Store | Relational DBMS | Relational DBMS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sekundäre Datenbankmodelle | Spatial DBMS Suchmaschine integrated Lucene index, currently in MongoDB Atlas only. Time Series DBMS Time Series Collections introduced in Release 5.0 Vektor DBMS currently available in the MongoDB Atlas cloud service only | Document Store Graph DBMS with Apache Age Spatial DBMS Vektor DBMS with pgvector extension | Key-Value Store | Document Store | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Website | www.mongodb.com | www.postgresql.org | www.scylladb.com | pingcap.com | www.voltdb.com | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Technische Dokumentation | www.mongodb.com/docs/manual | www.postgresql.org/docs | docs.scylladb.com | docs.pingcap.com/tidb/stable | docs.voltdb.com | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Entwickler | MongoDB, Inc | PostgreSQL Global Development Group www.postgresql.org/developer | ScyllaDB | PingCAP, Inc. | VoltDB Inc. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Erscheinungsjahr | 2009 | 1989 1989: Postgres, 1996: PostgreSQL | 2015 | 2016 | 2010 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Aktuelle Version | 6.0.7, Juni 2023 | 16.3, Mai 2024 | ScyllaDB Open Source 5.4.1, Jaenner 2024 | 8.1.0, Mai 2024 | 11.3, April 2022 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Lizenz Commercial or Open Source | Open Source MongoDB Inc.'s Server Side Public License v1. Prior versions were published under GNU AGPL v3.0. Commercial licenses are also available. | Open Source BSD | Open Source Open Source (AGPL), commercial license available | Open Source Apache 2.0 | Open Source AGPL für Community Edition, kommerzielle Lizenz für Enterprise, AWS und Pro Editionen | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Ausschließlich ein Cloud-Service Nur als Cloud-Service verfügbar | nein MongoDB available as DBaaS (MongoDB Atlas) | nein | nein | nein | nein | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DBaaS Angebote (gesponserte Links) Database as a Service Providers of DBaaS offerings, please contact us to be listed. |
|
| Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS | TiDB Cloud: Fully-managed TiDB Service. Bring everything great about TiDB to the cloud. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Implementierungssprache | C++ | C | C++ | Go, Rust | Java, C++ | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Server Betriebssysteme | Linux OS X Solaris Windows | FreeBSD HP-UX Linux NetBSD OpenBSD OS X Solaris Unix Windows | Linux | Linux | Linux OS X for development | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Datenschema | schemafrei Obwohl schemafrei haben Dokumente einer Collection dennoch häufig die selbe Struktur | ja | schemafrei | ja | ja | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Typisierung vordefinierte Datentypen, z.B. float oder date | ja string, integer, double, decimal, boolean, date, object_id, geospatial | ja | ja | ja | ja | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
XML Unterstützung Verarbeitung von Daten in XML Format, beispielsweise Speicherung von XML-Strukturen und/oder Unterstützung von XPath, XQuery, XSLT | ja specific XML-type available, but no XML query functionality. | nein | nein | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sekundärindizes | ja | ja | ja cluster global secondary indices | ja | ja | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQL Support of SQL | Read-only SQL queries via the MongoDB Atlas SQL Interface | ja Standard mit zahlreichen Erweiterungen | SQL-like DML and DDL statements (CQL) | ja | ja nur einen Teil von SQL 99 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
APIs und andere Zugriffskonzepte | GraphQL HTTP REST Prisma Proprietäres Protokoll basierend auf JSON | ADO.NET JDBC native C library ODBC streaming API for large objects | Proprietäres Protokoll compatible with CQL (Cassandra Query Language, an SQL-like language) RESTful HTTP API (DynamoDB compatible) Thrift | GORM JDBC ODBC Proprietäres Protokoll SQLAlchemy | Java API JDBC RESTful HTTP/JSON API | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Unterstützte Programmiersprachen | Actionscript inoffizielle Driver C C# C++ Clojure inoffizielle Driver ColdFusion inoffizielle Driver D inoffizielle Driver Dart inoffizielle Driver Delphi inoffizielle Driver Erlang Go Groovy inoffizielle Driver Haskell Java JavaScript Kotlin Lisp inoffizielle Driver Lua inoffizielle Driver MatLab inoffizielle Driver Perl PHP PowerShell inoffizielle Driver Prolog inoffizielle Driver Python R inoffizielle Driver Ruby Rust Scala Smalltalk inoffizielle Driver Swift | .Net C C++ Delphi Java JDBC JavaScript (Node.js) Perl PHP Python Tcl | For CQL interface: C#, C++, Clojure, Erlang, Go, Haskell, Java, JavaScript, Node.js, Perl, PHP, Python, Ruby, Rust, Scala For DynamoDB interface: .Net, ColdFusion, Erlang, Groovy, Java, JavaScript, Perl, PHP, Python, Ruby | Ada C C# C++ D Delphi Eiffel Erlang Haskell Java JavaScript (Node.js) Objective-C OCaml Perl PHP Python Ruby Scheme Tcl | C# C++ Erlang nicht offiziell unterstützt Go Java JavaScript Node.js PHP Python | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Server-seitige Scripts Stored Procedures | JavaScript | benutzerdefinierte Funktionen realisiert z.B. mit spezifischer Sprache PL/pgSQL, aber auch andere Sprachen möglich (Perl, Python, Tcl, etc.) | yes, Lua | nein | Java | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Triggers | ja in MongoDB Atlas only | ja | nein | nein | nein | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Partitionierungsmechanismen Methoden zum Speichern von unterschiedlichen Daten auf unterschiedlichen Knoten | Sharding Partitioned by hashed, ranged, or zoned sharding keys. Live resharding allows users to change their shard keys as an online operation with zero downtime. | partitioning by range, list and (since PostgreSQL 11) by hash | Sharding | horizontal partitioning (by key range) | Sharding | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Replikationsmechanismen Methoden zum redundanten Speichern von Daten auf mehreren Knoten | Multi-Source deployments with MongoDB Atlas Global Clusters Source-Replica Replikation | Source-Replica Replikation andere Varianten durch Verwendung von 3rd party - tools | frei wählbarer Replikationsfaktor Representation of geographical distribution of servers is possible | Using Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas. | Multi-Source Replikation Source-Replica Replikation | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MapReduce Bietet ein API für Map/Reduce Operationen | ja | nein | nein | ja with TiSpark Connector | nein | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Konsistenzkonzept Methoden zur Sicherstellung der Konsistenz in einem verteilten System | Eventual Consistency can be individually decided for each read operation Immediate Consistency default behaviour | Immediate Consistency | Eventual Consistency Tunable Consistency can be individually decided for each write operation | Immediate Consistency | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Fremdschlüssel referenzielle Integrität | nein Normalerweise nicht gebraucht, abgeschwächte Variante mit DBRef | ja | nein | ja full support since version 6.6 | nein FOREIGN KEY constraints werden nicht unterstützt | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Transaktionskonzept Unterstützung zur Sicherstellung der Datenintegrität bei nicht-atomaren Datenmanipulationen | Multi-document ACID Transactions with snapshot isolation | ACID | nein Atomicity and isolation are supported for single operations | ACID | ACID Transaktionen werden single-threaded innerhalb von Stored Procedures ausgeführt | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Concurrency Unterstützung von gleichzeitig ausgeführten Datenmanipulationen | ja | ja | ja | ja | ja Datenzugriffe werden vom Server serialisiert | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Durability Dauerhafte Speicherung der Daten | ja optional, enabled by default | ja | ja | ja | ja Snapshots und Command Logging | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In-Memory Unterstützung Gibt es Möglichkeiten einige oder alle Strukturen nur im Hauptspeicher zu halten | ja In-memory storage engine introduced with MongoDB version 3.2 | nein | ja in-memory tables | nein | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Berechtigungskonzept Zugriffskontrolle | Zugriffsrechte für Benutzer und Rollen | Benutzer mit feingranularem Berechtigungskonzept entsprechend SQL-Standard | Access rights for users can be defined per object | Fine grained access rights according to SQL-standard | Benutzer und Rollen mit Berechtigungen auf Stored Procedures | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Weitere Informationen bereitgestellt vom Systemhersteller | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MongoDB | PostgreSQL | ScyllaDB | TiDB | VoltDB | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Specific characteristics | MongoDB provides an integrated suite of cloud database and data services to accelerate... » mehr | ScyllaDB is engineered to deliver predictable performance at scale. It’s adopted... » mehr | TiDB is an advanced open-source, distributed SQL database for modern application... » mehr | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Competitive advantages | Built around the flexible document data model and unified API, MongoDB is a developer... » mehr | Highly-performant (efficiently utilizes full resources of a node and network; millions... » mehr | - HORIZONTAL SCALING : TiDB grants total transparency into your data workloads without... » mehr | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Typical application scenarios | AI-enriched intelligent apps (Continental, Telefonica, Iron Mountain) Internet of... » mehr | ScyllaDB is ideal for applications that require high throughput and low latency at... » mehr | TiDB is ideal for transactional applications that require extreme scalability and... » mehr | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Key customers | ADP, Adobe, Amadeus, AstraZeneca, Auto Trader, Barclays, BBVA, Bosch, Cisco, CERN,... » mehr | Discord, Epic Games, Expedia, Zillow, Comcast, Disney+ Hotstar, Samsung, ShareChat,... » mehr | Block, Pinterest, Catalyst, Bolt, Flipkart, Capcom, Shopee (E-commerce), JD Cloud... » mehr | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Market metrics | Hundreds of millions downloads, over 150,000+ Atlas clusters provisioned every month... » mehr | ScyllaDB typically offers ~75% total cost of ownership savings, with ~5X higher throughput... » mehr | 34K+ GitHub stars 5K+ members in TiDB Community Slack 1K+ community contributors... » mehr | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Licensing and pricing models | MongoDB database server: Server-Side Public License (SSPL) . Commercial licenses... » mehr | ScyllaDB Open Source - free open source software (AGPL) ScyllaDB Enterprise - subscription-based... » mehr | TiDB Community : Free open source software (Apache 2.0) TiDB Self-Hosted : Enterprise... » mehr | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Wir laden Vertreter der Systemhersteller ein uns zu kontaktieren, um die Systeminformationen zu aktualisieren und zu ergänzen, | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Zugehörige Produkte und Dienstleistungen | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Drittanbieter | Navicat for MongoDB gives you a highly effective GUI interface for MongoDB database management, administration and development. » mehr CData: Connect to Big Data & NoSQL through standard Drivers. » mehr Studio 3T: The world's favorite IDE for working with MongoDB » mehr | Instaclustr: Fully Hosted & Managed PostgreSQL » mehr Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools. » mehr Timescale: Calling all PostgreSQL users – the 2023 State of PostgreSQL survey is now open! Share your favorite extensions, preferred frameworks, community experiences, and more. Take the survey today! » mehr Redgate webinars: A series of key topics for new PostgreSQL users. » mehr Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development. » mehr Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems. » mehr Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance. » mehr pgDash: In-Depth PostgreSQL Monitoring. » mehr CYBERTEC is your professional partner in PostgreSQL topics for over 20 years. As our main aim is to be your single-source all-in-one IT service provider, we offer a wide range of products and services. Visit our website for more details. » mehr SharePlex is the reliable and affordable data replication solution for PostgreSQL migrations, high availability and more. » 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MongoDB | PostgreSQL | ScyllaDB | TiDB | VoltDB | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DB-Engines Blog Posts | Snowflake is the DBMS of the Year 2021 PostgreSQL is the DBMS of the Year 2020 PostgreSQL is the DBMS of the Year 2018 | PostgreSQL is the DBMS of the Year 2023 Snowflake is the DBMS of the Year 2022, defending the title from last year Snowflake is the DBMS of the Year 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Erwähnungen in aktuellen Nachrichten | Why MongoDB Stock Plunged Today Analysts retool MongoDB stock price target after earnings MongoDB loses nearly a quarter of its value after adjusting revenue forecasts MongoDB Q1 Earnings: Another One Bites The Dust (NASDAQ:MDB) Why MongoDB Stock Plunged Today bereitgestellt von Google News | What Microsoft's Open Source PostgreSQL Acquisition Portends for SQL Server How to implement a better like, views, comment counters in PostgreSQL? Automatically Generate Types for Your PostgreSQL Database Enterprise DB begins rolling AI features into PostgreSQL Oracle Introduces PostgreSQL Running Native on OCI bereitgestellt von Google News | ScyllaDB Raises $43M to Take on MongoDB at Scale, Push Database Performance to New Levels Sleeping at Scale - Delivering 10k Timers per Second per Node with Rust, Tokio, Kafka, and Scylla Running ScyllaDB NoSQL on Kubernetes with Spot Instances ScyllaDB on AWS is a NoSQL Database Built for Gigabyte-to-Petabyte Scale | Amazon Web Services ScyllaDB Database Review | eWeek bereitgestellt von Google News | PingCAP Named Customers' Choice in 2024 Gartner Peer Insights for Cloud Database Management Systems How PingCAP transformed TiDB into a serverless DBaaS using Amazon S3 and Amazon EBS | Amazon Web Services Google Cloud's C3D Instances Provide Strong Performance Value For PingCAP's TiDB TiDB by PingCAP Leads Data Management Revolution at GIDS 2024, Empowering India's Burgeoning Developer ... Announcing TiDB 7.4: The Best Database Alternative for MySQL 8.0 bereitgestellt von Google News | VoltDB Turns to Real-Time Analytics with NewSQL Database VoltDB Launches Active(N) Lossless Cross Data Center Replication VoltDB Upgrades Power, Security of Its In-Memory Database VoltDB Aims for Fast Big Data Development -- ADTmag VoltDB Adds Geospatial Support, Cross-Site Replication bereitgestellt von Google News |
Teilen sie diese Seite mit ihrem Netzwerk