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

DBMS > dBASE vs. OmniSci vs. Spark SQL

System Properties Comparison dBASE vs. OmniSci vs. Spark SQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NamedBASE  Xexclude from comparisonOmniSci infoFormerly named 'MapD', rebranded to 'OmniSci' in September 2018  Xexclude from comparisonSpark SQL  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.A high performance, in-memory, column-oriented RDBMS, designed to run on GPUsSpark SQL is a component on top of 'Spark Core' for structured data processing
Primary database modelRelational DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score14.11
Rank#38  Overall
#23  Relational DBMS
Score1.98
Rank#122  Overall
#59  Relational DBMS
Score18.40
Rank#34  Overall
#21  Relational DBMS
Websitewww.dbase.comwww.omnisci.comspark.apache.org/­sql
Technical documentationwww.dbase.com/­support/­knowledgebasedocs.omnisci.com/­latestspark.apache.org/­docs/­latest/­sql-programming-guide.html
DeveloperAsthon TateMapD Technologies, Inc.Apache Software Foundation
Initial release197920162014
Current releasedBASE PLUS 11, December 2016V43.0.0, June 2020
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2; enterprise edition availableOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++ and CUDAScala
Server operating systemsDOS infodBase Classic
Windows infodBase Pro
LinuxLinux
OS X
Windows
Data schemeyesyesyes
Typing infopredefined data types such as float or dateyesyesyes
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.nono
Secondary indexesyesnono
SQL infoSupport of SQLnoyesSQL-like DML and DDL statements
APIs and other access methodsnone infoThe IDE can access other DBMS or ODBC-sources.JDBC
ODBC
Thrift
JDBC
ODBC
Supported programming languagesdBase proprietary IDEAll languages supporting JDBC/ODBC/Thrift
Python
Java
Python
R
Scala
Server-side scripts infoStored proceduresno infoThe IDE can access stored procedures in other database systems.nono
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodesnoneSharding infoRound robinyes, utilizing Spark Core
Replication methods infoMethods for redundantly storing data on multiple nodesnoneMaster-master replicationnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integrityyesnono
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 DBMSnono
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlAccess rights for users and rolesfine grained access rights according to SQL-standardno

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
dBASEOmniSci infoFormerly named 'MapD', rebranded to 'OmniSci' in September 2018Spark SQL
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

Global Object-Oriented Databases Software Market 2020 Top Companies – Google, Actian, DBase, Microsoft, Paradigma Software
29 June 2020, Galus Australis

Object-Oriented Databases Software Market 2020-2024 Current Trends, Demand and Statistical Analysis By Google, Microsoft, InterSystems, DBase, Cyebiz, VelocityDB
3 July 2020, 3rd Watch News

Current COVID-19 Impact on Object Oriented Databases Software Market Research 2020 With Strategic Analysis of Key Companies – Google, Microsoft, InterSystems, DBase, Cyebiz
16 June 2020, Cole of Duty

Dbase4media Group & Real Advertising announce strategic partnership
11 June 2020, Exchange4Media

#BajanVibes - Living the dream . . . Barri G on road to success
2 July 2020, Barbados Today

provided by Google News

GPU Database Market Size, Opportunities And Forecast Analysis To 2026|Omnisci, Sqream, Neo4j
2 July 2020, Weekly Wall

GPU Database Market Survey Report 2020-2026: Kinetica DB, OmniSci, Neo4j
1 July 2020, NJ MMA News

Global GPU Database Market 2020 Top Companies – Kinetica, Omnisci, Sqream, Neo4j, Nvidia
26 June 2020, Bandera County Courier

GPU Database Market Is Booming Worldwide | Kinetica, Omnisci, Sqream
23 June 2020, 3rd Watch News

Accelerated Databases In The Fast Lane
25 June 2020, The Next Platform

provided by Google News

Spark 3.0 Brings Big SQL Speed-Up, Better Python Hooks
25 June 2020, Datanami

Spark 3 Improves Python and SQL Support
22 June 2020, iProgrammer

Databricks Cranks Delta Lake Performance, Nabs Redash for SQL Viz
24 June 2020, Datanami

Spark 3.0 changes gears with adaptive query execution and GPU help
23 June 2020, DevClass

news digest: Apache Spark 3.0 released, OpenAPI 3.1.0 RC0, Pinpoint Agile ceremonies - SD Times
19 June 2020, SDTimes.com

provided by Google News

Job opportunities

Planner
Shaw Industries Group, Inc., Dalton, GA

CUSTOMER SERVICE LIAISON - CALL CENTER - GREENSBURG
Excela Health Corporate Services, Greensburg, PA

Credentialing Assistant
Coastal Horizons Center, Inc., Wilmington, NC

Sr.Spec'st Dbase Analyst
BNY Mellon, Florham Park, NJ

Fiscal Analyst 2
Washington State University, Pullman, WA

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

Spark ETL Developer
Alderson Loop, Chevy Chase, MD

Data Engineers - Hadoop
State Street, Redwood City, CA

Python & JavaScript Developer
Media Storm, LLC, New York, NY

Technical Support Engineer (Remote)
Dataiku, Remote

jobs by Indeed




Share this page

Featured Products

AllegroGraph logo

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

Couchbase logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Neo4j logo

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

Present your product here