DB-EnginesDo you need a hard real time database?English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > dBASE vs. EsgynDB vs. Greenplum vs. mSQL vs. OrigoDB

System Properties Comparison dBASE vs. EsgynDB vs. Greenplum vs. mSQL vs. OrigoDB

Editorial information provided by DB-Engines
NamedBASE  Xexclude from comparisonEsgynDB  Xexclude from comparisonGreenplum  Xexclude from comparisonmSQL infoMini SQL  Xexclude from comparisonOrigoDB  Xexclude from comparison
DescriptiondBase was one of the first databases with a development environment on PC's. Its latest version dBase V is still sold as dBase classic, which needs a DOS Emulation. The up-to-date product is dBase plus.Enterprise-class SQL-on-Hadoop solution, powered by Apache TrafodionAnalytic 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.mSQL (Mini SQL) is a simple and lightweight RDBMSA fully ACID in-memory object graph database
Primary database modelRelational DBMSRelational DBMSRelational DBMSRelational DBMSDocument store
Object oriented DBMS
Secondary database modelsDocument store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score14.38
Rank#42  Overall
#26  Relational DBMS
Score0.19
Rank#292  Overall
#137  Relational DBMS
Score13.27
Rank#43  Overall
#27  Relational DBMS
Score1.74
Rank#134  Overall
#66  Relational DBMS
Score0.00
Rank#363  Overall
#49  Document stores
#20  Object oriented DBMS
Websitewww.dbase.comwww.esgyn.cngreenplum.orghughestech.com.au/­products/­msqlorigodb.com
Technical documentationwww.dbase.com/­support/­knowledgebasedocs.greenplum.orgorigodb.com/­docs
DeveloperAsthon TateEsgynPivotal Software Inc.Hughes TechnologiesRobert Friberg et al
Initial release19792015200519942009 infounder the name LiveDB
Current releasedBASE 2019, 20196.7.1, April 20204.4, October 2021
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache 2.0commercial infofree licenses can be providedOpen Source
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++, JavaCC#
Server operating systemsDOS infodBase Classic
Windows infodBase Pro
LinuxLinuxAIX
HP-UX
Linux
OS X
Solaris SPARC/x86
Windows
Linux
Windows
Data schemeyesyesyesyesyes
Typing infopredefined data types such as float or dateyesyesyesyesUser defined using .NET types and collections
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.noyes infosince Version 4.2nono infocan be achieved using .NET
Secondary indexesyesyesyesyesyes
SQL infoSupport of SQLnoyesyesA subset of ANSI SQL is implemented infono subqueries, aggregate functions, views, foreign keys, triggersno
APIs and other access methodsnone infoThe IDE can access other DBMS or ODBC-sources.ADO.NET
JDBC
ODBC
JDBC
ODBC
JDBC
ODBC
.NET Client API
HTTP API
LINQ
Supported programming languagesdBase proprietary IDEAll languages supporting JDBC/ODBC/ADO.NetC
Java
Perl
Python
R
C
C++
Delphi
Java
Perl
PHP
Tcl
.Net
Server-side scripts infoStored proceduresno infoThe IDE can access stored procedures in other database systems.Java Stored Proceduresyesnoyes
Triggersnonoyesnoyes infoDomain Events
Partitioning methods infoMethods for storing different data on different nodesnoneShardingShardingnonehorizontal partitioning infoclient side managed; servers are not synchronized
Replication methods infoMethods for redundantly storing data on multiple nodesnoneMulti-source replication between multi datacentersSource-replica replicationnoneSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistencynone
Foreign keys infoReferential integrityyesyesyesnodepending on model
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infonot for dBase internal data, but IDE does support transactions when accessing external DBMSACIDACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesnoyes
Durability infoSupport for making data persistentyesyesyesyesyes infoWrite ahead log
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nononoyes
User concepts infoAccess controlAccess rights for users and rolesfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardnoRole based authorization

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

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

More resources
dBASEEsgynDBGreenplummSQL infoMini SQLOrigoDB
DB-Engines blog posts

DB-Engines Ranking coverage expanded to 169 database management systems
3 June 2013, Paul Andlinger

show all