DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > EDB Postgres vs. Elasticsearch vs. Milvus vs. Oracle NoSQL

System Properties Comparison EDB Postgres vs. Elasticsearch vs. Milvus vs. Oracle NoSQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameEDB Postgres  Xexclude from comparisonElasticsearch  Xexclude from comparisonMilvus  Xexclude from comparisonOracle NoSQL  Xexclude from comparison
DescriptionThe EDB Postgres Platform is an enterprise-class data management platform based on the open source database PostgreSQL with flexible deployment options and Oracle compatibility features, complemented by tool kits for management, integration, and migration.A distributed, RESTful modern search and analytics engine based on Apache Lucene infoElasticsearch lets you perform and combine many types of searches such as structured, unstructured, geo, and metricA DBMS designed for efficient storage of vector data and vector similarity searchesA multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodes
Primary database modelRelational DBMSSearch engineSearch engineDocument store
Key-value store
Relational DBMS
Secondary database modelsDocument store
Spatial DBMS
Document store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.13
Rank#124  Overall
#60  Relational DBMS
Score155.08
Rank#8  Overall
#1  Search engines
Score0.37
Rank#264  Overall
#18  Search engines
Score4.38
Rank#86  Overall
#16  Document stores
#14  Key-value stores
#45  Relational DBMS
Websitewww.enterprisedb.comwww.elastic.co/­elasticsearchmilvus.iowww.oracle.com/­database/­technologies/­related/­nosql.html
Technical documentationwww.enterprisedb.com/­edb-docswww.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.htmlmilvus.io/­docs/­overview.mddocs.oracle.com/­en/­database/­other-databases/­nosql-database/­index.html
DeveloperEnterpriseDBElasticOracle
Initial release2005201020192011
Current release14, December 20217.8.0, June 20202.0, January 202222.1, May 2022
License infoCommercial or Open Sourcecommercial infoBSD for PostgreSQL-componentsOpen Source infoElastic LicenseOpen Source infoApache Version 2.0Open Source infoProprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCJavaC++, GoJava
Server operating systemsLinux
Windows
All OS with a Java VMLinux
macOS info10.14 or later
Windows infowith WSL 2 enabled
Linux
Solaris SPARC/x86
Data schemeyesschema-free infoFlexible type definitions. Once a type is defined, it is persistentSupport Fixed schema and Schema-less deployment with the ability to interoperate between them.
Typing infopredefined data types such as float or dateyesyesNumeric and Stringoptional
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yes infospecific XML-type available, but no XML query functionality.nonono
Secondary indexesyesyes infoAll search fields are automatically indexednoyes
SQL infoSupport of SQLyes infostandard with numerous extensionsSQL-like query languagenoSQL-like DML and DDL statements
APIs and other access methodsADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Java API
RESTful HTTP/JSON API
RESTful HTTP APIRESTful HTTP API
Supported programming languages.Net
C
C++
Delphi
Java
Perl
PHP
Python
Tcl
.Net
Groovy
Community Contributed Clients
Java
JavaScript
Perl
PHP
Python
Ruby
C++
Go
Java
JavaScript (Node.js)
Python
C
C#
Go
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.yesnono
Triggersyesyes infoby using the 'percolation' featurenono
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoby hash, list or rangeShardingShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationyesElectable source-replica replication per shard. Support distributed global deployment with Multi-region table feature
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoES-Hadoop Connectornowith Hadoop integration
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allBounded Staleness
Eventual Consistency
Immediate Consistency
Session Consistency
Tunable Consistency
Eventual Consistency
Immediate Consistency infodepending on configuration
Foreign keys infoReferential integrityyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnonoconfigurable infoACID within a storage node (=shard)
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noMemcached and Redis integrationnoyes infooff heap cache
User concepts infoAccess controlfine grained access rights according to SQL-standardnoAccess rights for users and roles
More information provided by the system vendor
EDB PostgresElasticsearchMilvusOracle NoSQL
Specific characteristicsPostgreSQL with added Security, Performance, DBA, Developer, and Oracle compatibile...
» more
Milvus is an open-source and cloud-native vector database built for production-ready...
» more
Competitive advantagesComplete Postgres platform with enterprise-class Postgres, Management, Integration,...
» more
Highly available, versatile, and robust with millisecond latency. Supports batch...
» more
Typical application scenariosNew applications for transactional, reporting and mixed workloads that need to integrate...
» more
Video media : video understanding, video deduplication. E-commerce and mobile applications...
» more
Key customersMasterCard, Hewlett Packard Enterprise, Ericsson, AT&T, Alibaba, Korea Telecom and...
» more
Milvus is trusted by over 1,000 enterprises, including Baidu, eBay, IKEA, LINE, Shopee,...
» more
Market metricsListed in Gartner Magic Quadrant 2013-2018 with over 4,000 customers.
» more
As of March 2022, 9.8k+ GitHub stars 1.4k+ Github forks 871k+ docker pulls 2k+ community...
» more
Licensing and pricing modelsOpen Source and Commercial core based licensing.
» more
Milvus was released under the open-source Apache License 2.0 in October 2019. Managed...
» more

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

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

More resources
EDB PostgresElasticsearchMilvusOracle NoSQL
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

Elasticsearch moved into the top 10 most popular database management systems
3 July 2017, Matthias Gelbmann

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Recent citations in the news

EDB 14 Supercharges PostgreSQL for Mission-critical Applications
9 December 2021, Business Wire

EDB Accelerates Innovation with World’s First Openly Governed Postgres Operator for Kubernetes
16 May 2022, DevOps.com

EDB Announces General Availability of a PostgreSQL Database in the Cloud: BigAnimal
17 November 2021, InfoQ.com

EDB Releases EDB BigAnimal DBaaS on AWS
17 May 2022, Business Wire

EDB Releases Fully-managed ‘BigAnimal’ Postgres Service on AWS, Azure
1 June 2022, CDOTrends

provided by Google News

Supercloud simplifies cloud architecture while leveling up automation
16 August 2022, SiliconANGLE News

5 Best Browsers that Support Kibana [Ranked by Compatibility]
4 August 2022, WindowsReport.com

What to Expect at the 2022 ElasticON; San Francisco, D.C., and NYC
12 August 2022, Solutions Review

Thousands of Burger King Customers Received a Blank Receipt: Security Breach or Employee Mistake?
9 August 2022, Tech Times

Report: 84% of online shoppers say personalization influences their purchases
15 August 2022, VentureBeat

provided by Google News

Zilliz Announces Key Contributions to Milvus 2.1, the Leading Open-Source Vector Database for Structured and Unstructured Data
3 August 2022, Business Wire

Database technology evolves to combine machine learning and data storage
7 March 2022, VentureBeat

What Is Vector Similarity Search? | Business Applications of Vector Search
11 August 2021, CIO Insight

The Recommendation System
15 February 2022, News | Europeana Pro

Black Kites on a flyway between Western Siberia and the Indian Subcontinent | Scientific Reports
2 April 2022, Nature.com

provided by Google News

Oracle and Microsoft Rolling Out Database Service for Azure
25 July 2022, Datamation

Oracle NoSQL Database
28 March 2022, TechTarget

Oracle NoSQL database comes to the cloud
2 April 2020, TechTarget

Oracle, Uni. Of Mauritius develop breast cancer awareness app
21 April 2022, Africanews English

Oracle Beefs Up Its NoSQL Database Offering
3 April 2014, Data Center Knowledge

provided by Google News

Job opportunities

Partner Account Executive- ISV/OEM
EDB, Dallas, TX

AWS PostgreSQL ETL Data Modeling
Silver Tree Consulting and Services, Raleigh, NC

Sales Development Representative
EDB, Bedford, MA

Postgres DBA
Unisoft Technology Inc., Gaithersburg, MD

Partner Marketing Manager (Cloud)
EDB, Bedford, MA

Sr. DBA-MongoDB/Elasticsearch
Autofi, Remote

Elasticsearch SME
NR Consulting LLC, San Jose, CA

Full Stack Developer
Esolvit Inc.,, Amigo, WV

ELK Administrator - Remote
Compugra Systems Inc, Remote

Python/Django Developer
Blutium, Remote

Talent Acquisition Lead
Zilliz, San Francisco, CA

Director of Developer Relations
Hire io, Remote

High Performance Computing Engineer
Zilliz, San Francisco, CA

Head of Marketing
Zilliz, San Francisco, CA

Head of Developer Relations
Zilliz, San Francisco, CA

Business Intelligence Engineer II, Inventory Placement
Amazon.com Services LLC, Remote

Data Engineer - Customer Packaging Experience, CPEX Data Engineering and Intelligence
Amazon.com Services LLC, Remote

Business Intelligence Engineer, Prime Decision Sciences
Amazon.com Services LLC, Seattle, WA

Data Engineer
Fisher Investments, Camas, WA

Business Intelligence Engineer
Amazon.com Services LLC, Bellevue, WA

jobs by Indeed



Share this page

Featured Products

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

The definitive guide for Cassandra

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

Neo4j logo

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

Redis logo

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

Present your product here