DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Redshift vs. OpenEdge vs. Oracle Berkeley DB vs. Oracle Rdb vs. Solr

System Properties Comparison Amazon Redshift vs. OpenEdge vs. Oracle Berkeley DB vs. Oracle Rdb vs. Solr

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonOpenEdge  Xexclude from comparisonOracle Berkeley DB  Xexclude from comparisonOracle Rdb  Xexclude from comparisonSolr  Xexclude from comparison
DescriptionLarge scale data warehouse service for use with business intelligence toolsApplication development environment with integrated database management systemWidely used in-process key-value storeA widely used distributed, scalable search engine based on Apache Lucene
Primary database modelRelational DBMSRelational DBMSKey-value store infosupports sorted and unsorted key sets
Native XML DBMS infoin the Oracle Berkeley DB XML version
Relational DBMSSearch engine
Secondary database modelsSpatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score17.94
Rank#34  Overall
#21  Relational DBMS
Score3.51
Rank#86  Overall
#46  Relational DBMS
Score2.21
Rank#117  Overall
#20  Key-value stores
#3  Native XML DBMS
Score1.08
Rank#184  Overall
#85  Relational DBMS
Score42.91
Rank#24  Overall
#3  Search engines
Websiteaws.amazon.com/­redshiftwww.progress.com/­openedgewww.oracle.com/­database/­technologies/­related/­berkeleydb.htmlwww.oracle.com/­database/­technologies/­related/­rdb.htmlsolr.apache.org
Technical documentationdocs.aws.amazon.com/­redshiftdocumentation.progress.com/­output/­ua/­OpenEdge_latestdocs.oracle.com/­cd/­E17076_05/­html/­index.htmlwww.oracle.com/­database/­technologies/­related/­rdb-doc.htmlsolr.apache.org/­resources.html
DeveloperAmazon (based on PostgreSQL)Progress Software CorporationOracle infooriginally developed by Sleepycat, which was acquired by OracleOracle, originally developed by Digital Equipment Corporation (DEC)Apache Software Foundation
Initial release20121984199419842006
Current releaseOpenEdge 12.2, March 202018.1.40, May 20207.4.1.1, 20219.6.0, April 2024
License infoCommercial or Open SourcecommercialcommercialOpen Source infocommercial license availablecommercialOpen Source infoApache Version 2
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC, Java, C++ (depending on the Berkeley DB edition)Java
Server operating systemshostedAIX
HP-UX
Linux
Solaris
Windows
AIX
Android
FreeBSD
iOS
Linux
OS X
Solaris
VxWorks
Windows
HP Open VMSAll OS with a Java VM inforuns as a servlet in servlet container (e.g. Tomcat, Jetty is included)
Data schemeyesyesschema-freeFlexible Schema (defined schema, partial schema, schema free)yes infoDynamic Fields enables on-the-fly addition of new fields
Typing infopredefined data types such as float or dateyesyesnoyesyes infosupports customizable data types and automatic typing
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.noyesyes infoonly with the Berkeley DB XML editionnoyes
Secondary indexesrestrictedyesyesyesyes infoAll search fields are automatically indexed
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardyes infoclose to SQL 92yes infoSQL interfaced based on SQLite is availableyesSolr Parallel SQL Interface
APIs and other access methodsJDBC
ODBC
JDBC
ODBC
Java API
RESTful HTTP/JSON API
Supported programming languagesAll languages supporting JDBC/ODBCProgress proprietary ABL (Advanced Business Language).Net infoFigaro is a .Net framework assembly that extends Berkeley DB XML into an embeddable database engine for .NET
others infoThird-party libraries to manipulate Berkeley DB files are available for many languages
C
C#
C++
Java
JavaScript (Node.js) info3rd party binding
Perl
Python
Tcl
.Net
Erlang
Java
JavaScript
any language that supports sockets and either XML or JSON
Perl
PHP
Python
Ruby
Scala
Server-side scripts infoStored proceduresuser defined functions infoin PythonyesnoJava plugins
Triggersnoyesyes infoonly for the SQL APIyes infoUser configurable commands triggered on index changes
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning infosince Version 11.4noneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesSource-replica replicationSource-replica replicationyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononospark-solr: github.com/­lucidworks/­spark-solr and streaming expressions to reduce
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyEventual Consistency
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACIDyes, on a single nodeoptimistic locking
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyesnoyes
User concepts infoAccess controlfine grained access rights according to SQL-standardUsers and groupsnoyes

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

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

More resources
Amazon RedshiftOpenEdgeOracle Berkeley DBOracle RdbSolr
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

Elasticsearch replaced Solr as the most popular search engine
12 January 2016, Paul Andlinger

Enterprise Search Engines almost double their popularity in the last 12 months
2 July 2014, Paul Andlinger

The DB-Engines ranking includes now search engines
4 February 2013, Paul Andlinger

show all

Recent citations in the news

Revolutionizing data querying: Amazon Redshift and Visual Studio Code integration | Amazon Web Services
2 May 2024, AWS Blog

Amazon Redshift adds new AI capabilities, including Amazon Q, to boost efficiency and productivity | Amazon Web ...
29 November 2023, AWS Blog

Power analytics as a service capabilities using Amazon Redshift | Amazon Web Services
17 April 2024, AWS Blog

Amazon Redshift announces programmatic access to Advisor recommendations via API
8 February 2024, AWS Blog

Amazon Redshift now supports multi-data warehouse writes through data sharing (preview)
26 November 2023, AWS Blog

provided by Google News

OpenEdge Application Development | Progress OpenEdge
14 September 2014, Progress Software

What's New in OpenEdge 12.8
15 April 2024, release.nl

PoC Exploit Released for OpenEdge Authentication Gateway & AdminServer Vulnerability
11 March 2024, GBHackers

provided by Google News

Margo Seltzer Named ACM Athena Lecturer for Technical and Mentoring Contributions
26 April 2023, HPCwire

ACM recognizes far-reaching technical achievements with special awards
26 May 2021, EurekAlert

Database Trends Report: SQL Beats NoSQL, MySQL Most Popular -- ADTmag
5 March 2019, ADT Magazine

A Quick Look at Open Source Databases for Mobile App Development
29 April 2018, Open Source For You

Motorola A780 Linux based smartphone to have mobile database
14 September 2004, Geekzone

provided by Google News

Oracle Adds New AI-Enabling Features To MySQL HeatWave
23 March 2023, Forbes

Oracle Business Model - How Oracle Makes Money?
12 June 2023, Business Model Analyst

Should we all consolidate databases for the storage benefits? Reg vultures deploy DevOps, zoos, haircuts
18 September 2020, The Register

2013 Data Science Salary Survey – O'Reilly
4 May 2013, O'Reilly Media

provided by Google News

SOLR-led walkout demands better conditions for Compass workers
27 February 2024, Daily Northwestern

Best Practices from Rackspace for Modernizing a Legacy HBase/Solr Architecture Using AWS Services | Amazon Web ...
9 October 2023, AWS Blog

SOLR hosts teach-in of labor movements at Northwestern
28 January 2024, Daily Northwestern

Top 5 stock gainers and losers: SOLR.V, GRSL.V, ANON.C
21 November 2023, Equity.Guru

SearchStax Launches Serverless Solr Service to Accelerate Cloud-Native Application Development
5 April 2023, PR Newswire

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

SingleStore logo

The database to transact, analyze and contextualize your data in real time.
Try it today.

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Neo4j logo

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

Present your product here