DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > dBASE vs. EJDB vs. Newts vs. Spark SQL vs. Transbase

System Properties Comparison dBASE vs. EJDB vs. Newts vs. Spark SQL vs. Transbase

Editorial information provided by DB-Engines
NamedBASE  Xexclude from comparisonEJDB  Xexclude from comparisonNewts  Xexclude from comparisonSpark SQL  Xexclude from comparisonTransbase  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.Embeddable document-store database library with JSON representation of queries (in MongoDB style)Time Series DBMS based on CassandraSpark SQL is a component on top of 'Spark Core' for structured data processingA resource-optimized, high-performance, universally applicable RDBMS
Primary database modelRelational DBMSDocument storeTime Series DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score14.33
Rank#42  Overall
#26  Relational DBMS
Score0.10
Rank#314  Overall
#41  Document stores
Score0.00
Rank#354  Overall
#33  Time Series DBMS
Score22.86
Rank#35  Overall
#21  Relational DBMS
Score0.07
Rank#325  Overall
#147  Relational DBMS
Websitewww.dbase.comejdb.orgopennms.github.io/­newtsspark.apache.org/­sqlwww.transaction.de/­en/­products/­transbase.html
Technical documentationwww.dbase.com/­support/­knowledgebasegithub.com/­Softmotions/­ejdb/­blob/­master/­README.mdgithub.com/­OpenNMS/­newts/­wikispark.apache.org/­docs/­latest/­sql-programming-guide.htmlwww.transaction.de/­en/­products/­transbase/­features.html
DeveloperAsthon TateSoftmotionsOpenNMS GroupApache Software FoundationTransaction Software GmbH
Initial release19792012201420141987
Current releasedBASE 2019, 20193.2.0, October 2021Transbase 8.4, September 2020
License infoCommercial or Open SourcecommercialOpen Source infoGPLv2Open Source infoApache 2.0Open Source infoApache 2.0commercial infofree development license
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 languageCJavaScalaC and C++
Server operating systemsDOS infodBase Classic
Windows infodBase Pro
server-lessLinux
OS X
Windows
Linux
OS X
Windows
FreeBSD
Linux
macOS
Solaris
Windows
Data schemeyesschema-freeschema-freeyesyes
Typing infopredefined data types such as float or dateyesyes infostring, integer, double, bool, date, object_idyesyesyes
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.nonono
Secondary indexesyesnononoyes
SQL infoSupport of SQLnononoSQL-like DML and DDL statementsyes
APIs and other access methodsnone infoThe IDE can access other DBMS or ODBC-sources.in-process shared libraryHTTP REST
Java API
JDBC
ODBC
ADO.NET
JDBC
ODBC
Proprietary native API
Supported programming languagesdBase proprietary IDEActionscript
C
C#
C++
Go
Java
JavaScript (Node.js)
Lua
Objective-C
Pike
Python
Ruby
JavaJava
Python
R
Scala
C
C#
C++
Java
JavaScript
Kotlin
Objective-C
PHP
Python
Server-side scripts infoStored proceduresno infoThe IDE can access stored procedures in other database systems.nononoyes
Triggersnonononoyes
Partitioning methods infoMethods for storing different data on different nodesnonenoneSharding infobased on Cassandrayes, utilizing Spark Core
Replication methods infoMethods for redundantly storing data on multiple nodesnonenoneselectable replication factor infobased on CassandranoneSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency infobased on Cassandra
Immediate Consistency infobased on Cassandra
Immediate Consistency
Foreign keys infoReferential integrityyesno infotypically not needed, however similar functionality with collection joins possiblenonoyes
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 DBMSnononoyes
Concurrency infoSupport for concurrent manipulation of datayesyes infoRead/Write Lockingyesyesyes
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.nonono
User concepts infoAccess controlAccess rights for users and rolesnononofine grained access rights according to SQL-standard

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 partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

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

More resources
dBASEEJDBNewtsSpark SQLTransbase
DB-Engines blog posts

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

show all

Recent citations in the news

Object-Oriented Databases Software Market Regional Outlook To 2028 – Google, Microsoft, InterSystems, DBase, Cyebiz, VelocityDB, etc – ManufactureLink
11 May 2022, ManufactureLink

Microsoft Access 2016 Now Supports dBase Database Format
7 September 2016, Redmondmag.com

Retro Database dBASE Making a Comeback?
20 March 2013, Visual Studio Magazine

FlytBase & DroneBase partner up to provide fully autonomous Drone-in-a-Box solutions in Italy
2 December 2021, sUAS News

How to convert DBF to Excel (XLSX or XLS) in Windows 10
1 June 2021, TheWindowsClub

provided by Google News

Top online courses to learn Apache Spark
5 May 2022, Analytics India Magazine

Spark Gets Closer Hooks to Pandas, SQL with Version 3.2
26 October 2021, Datanami

Top 10 Business Intelligence Jobs in MNCs to Apply for in May
6 May 2022, Analytics Insight

Databricks SQL Now GA, Bringing Traditional BI to the Lakehouse
16 December 2021, Datanami

The 7 Best Apache Spark Tutorials on YouTube to Watch Right Now
14 February 2022, Solutions Review

provided by Google News

Job opportunities

Production Operator - 1st Shift (M-F 7am to 3:30pm)
Farmer Bros Co, Northlake, TX

Machine Operator - 2nd Shift (Monday through Friday 3:00pm - 11:30pm)
Farmer Brothers Coffee, Northlake, TX

Manager of Onsite Experience
Convention Data Services, Remote

Machine Operator -Day Shift (Monday through Friday 7am to 3:30pm)
Farmer Brothers Coffee, Portland, OR

Audit Analyst I
PRGX Global, Inc, Nashville, TN

Python/Spark/SQL Data Egnineer
Zettalogix, Iselin, NJ

Data Engineer
Piper Companies, Remote

Big Data Engineer
VIR Consultant, Santa Clara, CA

ETL Tester
Cool Minds LLC, Remote

Associate Data & Machine Learning Engineer
Amazon Web Services, Inc., Irvine, CA

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Redis logo

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

Present your product here