DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Microsoft Azure Data Explorer vs. OpenEdge vs. OpenQM vs. Oracle Berkeley DB vs. Oracle Rdb

System Properties Comparison Microsoft Azure Data Explorer vs. OpenEdge vs. OpenQM vs. Oracle Berkeley DB vs. Oracle Rdb

Editorial information provided by DB-Engines
NameMicrosoft Azure Data Explorer  Xexclude from comparisonOpenEdge  Xexclude from comparisonOpenQM infoalso called QM  Xexclude from comparisonOracle Berkeley DB  Xexclude from comparisonOracle Rdb  Xexclude from comparison
DescriptionFully managed big data interactive analytics platformApplication development environment with integrated database management systemQpenQM is a high-performance, self-tuning, multi-value DBMSWidely used in-process key-value store
Primary database modelRelational DBMS infocolumn orientedRelational DBMSMultivalue DBMSKey-value store infosupports sorted and unsorted key sets
Native XML DBMS infoin the Oracle Berkeley DB XML version
Relational DBMS
Secondary database modelsDocument store infoIf a column is of type dynamic docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types/­dynamic then it's possible to add arbitrary JSON documents in this cell
Event Store infothis is the general usage pattern at Microsoft. Billing, Logs, Telemetry events are stored in ADX and the state of an individual entity is defined by the arg_max(timestamps)
Search engine infosupport for complex search expressions docs.microsoft.com/­en-us/­azure/­kusto/­query/­parseoperator, FTS, Geospatial docs.microsoft.com/­en-us/­azure/­kusto/­query/­geo-point-to-geohash-function, distributed search -> ADX acts as a distributed search engine
Time Series DBMS infosee docs.microsoft.com/­en-us/­azure/­data-explorer/­time-series-analysis
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.75
Rank#89  Overall
#45  Relational DBMS
Score4.04
Rank#75  Overall
#40  Relational DBMS
Score0.27
Rank#252  Overall
#10  Multivalue DBMS
Score2.69
Rank#92  Overall
#17  Key-value stores
#2  Native XML DBMS
Score1.01
Rank#146  Overall
#71  Relational DBMS
Websiteazure.microsoft.com/­services/­data-explorerwww.progress.com/­openedgewww.openqm.comwww.oracle.com/­technetwork/­database/­database-technologies/­berkeleydb/­overview/­index.htmlwww.oracle.com/­technetwork/­database/­database-technologies/­rdb/­overview/­index.html
Technical documentationdocs.microsoft.com/­en-us/­azure/­data-explorerdocumentation.progress.com/­output/­ua/­OpenEdge_latestwww.openqm.com/­support/­documentationdocs.oracle.com/­cd/­E17076_05/­html/­index.html
DeveloperMicrosoftProgress Software CorporationMartin PhillipsOracle infooriginally developed by Sleepycat, which was acquired by OracleOracle, originally developed by Digital Equipment Corporation (DEC)
Initial release20191984199319941984
Current releasecloud service with continuous releasesOpenEdge 11.7, March 20173.4-1218.1 (Core), June 20187.3.3.2.0, 2019
License infoCommercial or Open SourcecommercialcommercialOpen Source infoGPLv2, extended commercial license availableOpen Source infocommercial license availablecommercial
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 languageC, Java, C++ (depending on the Berkeley DB edition)
Server operating systemshostedAIX
HP-UX
Linux
Solaris
Windows
AIX
FreeBSD
Linux
macOS
Raspberry Pi
Solaris
Windows
AIX
Android
FreeBSD
iOS
Linux
OS X
Solaris
VxWorks
Windows
HP Open VMS
Data schemeFixed schema with schema-less datatypes (dynamic)yesyes infowith some exceptionsschema-freeFlexible Schema (defined schema, partial schema, schema free)
Typing infopredefined data types such as float or dateyes infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-typesyesnoyes
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.yesnoyesyes infoonly with the Berkeley DB XML editionno
Secondary indexesall fields are automatically indexedyesyesyesyes
SQL infoSupport of SQLKusto Query Language (KQL), SQL subsetyes infoclose to SQL 92noyes infoSQL interfaced based on SQLite is availableyes
APIs and other access methodsMicrosoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
JDBC
ODBC
Supported programming languages.Net
Java
JavaScript (Node.js)
PowerShell
Python
R
Progress proprietary ABL (Advanced Business Language).Net
Basic
C
Java
Objective C
PHP
Python
.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
Server-side scripts infoStored proceduresYes, possible languages: KQL, Python, Ryesyesno
Triggersyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicyyesyesyes infoonly for the SQL API
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud servicehorizontal partitioning infosince Version 11.4yesnone
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.Master-slave replicationyesMaster-slave replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Immediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDACIDyes, on a single node
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.nonoyesno
User concepts infoAccess controlAzure Active Directory AuthenticationUsers and groupsAccess rights can be defined down to the item levelno
More information provided by the system vendor
Microsoft Azure Data ExplorerOpenEdgeOpenQM infoalso called QMOracle Berkeley DBOracle Rdb
Specific characteristicsAzure Data Explorer is a fast and highly scalable data exploration service for log...
» more
Competitive advantagesKusto Query Language (innovative query language, optimized for high performance data...
» more
Typical application scenariosIoT applications IoT devices generate billions of sensor readings. Normalizing and...
» more
Key customersMicrosoft, DocuSign, Taboola, Bosch, Siemens Healthineers, Bühler, Ecolab, Zoomd
» more
Market metricsAzure Data Explorer is the data service for Azure Monitor, Azure Time Series Insights,...
» 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
Microsoft Azure Data ExplorerOpenEdgeOpenQM infoalso called QMOracle Berkeley DBOracle Rdb
Recent citations in the news

How to share data in place from Azure Data Explorer - Microsoft
20 December 2019, Channel 9

Azure Data Explorer for IoT Data Analytics | Internet of Things Show - Microsoft
2 September 2019, Channel 9

Microsoft announces reserved capacity offerings for six more Azure services
13 November 2019, Neowin

Fastly, Microsoft partner on real-time analytics with Azure Data Explorer
29 January 2019, ZDNet

Zoomd Takes Another Step Towards Becoming an Industry Leader After Adopting Microsoft's Azure Data Explorer
4 December 2019, PRNewswire

provided by Google News

Industry Spotlight: Extracting data from inside the app
1 June 2017, SDTimes.com

SQL vs. NoSQL vs. NewSQL: Finding the Right Solution
17 August 2015, Dataconomy

provided by Google News

OpenQM
5 March 2019, International Spectrum Magazine

provided by Google News

Fedora Looking To Transition The RPM Database From Berkeley DB To SQLite
16 March 2020, Phoronix

Fedora 33 Plans To Ship With Latest MinGW For Best Experience In Compiling Software For Windows
18 March 2020, Phoronix

Oracle switches Berkeley DB license
5 July 2013, InfoWorld

Getting Started with Oracle Berkeley DB
30 August 2009, DZone News

Top Local Databases for React Native App Development {A 2020 List}
15 October 2019, Appinventiv

provided by Google News

Database Types from Hierarchical to Graph: An Industry Breakdown
30 May 2018, Dice Insights

New Eclipse Tools for OpenVMS and Oracle RDB Certified by eCube Systems to Work with NXTware Remote
12 November 2013, PR Web

provided by Google News

Job opportunities

Azure Data Engineer
Denken Solutions Inc, Grand Rapids, MI

Game Health Analyst
Microsoft, Redmond, WA

Sr Data & Applied Scientist
Microsoft, Redmond, WA

Cyber Hunt Analyst
Microsoft, Redmond, WA

Senior Data Engineer - Turn 10 Studios
Microsoft, Redmond, WA

OpenEdge / Database Developer
Cognizant Technology Solutions, Roseland, NJ

Progress OpenEdge Database Administrator
JSR Tech Consulting, Roseland, NJ

OpenEdge Software Engineer
Mass Genics, Wilmington, DE

QA Engineer (Software Development Engineer in Test)
Progress Software Corporation, Bedford, MA

QA Engineer (Software Development Engineer in Test)
Progress, Bedford, MA

PERL Programmer
Books-A-Million, Birmingham, AL

Software Engineer (TS/SCI with Polygraph)
Deloitte, Baltimore, MD

Senior Developer
Spectrum Systems, Riverwoods, IL

Sr. Systems Analyst - Storage / Backup
Swagelok Company, Solon, OH

Senior Systems Analyst
Swagelok Company, Solon, OH

jobs by Indeed




Share this page

Featured Products

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Present your product here