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

DBMS > Apache Drill vs. BigchainDB vs. dBASE vs. OmniSci

System Properties Comparison Apache Drill vs. BigchainDB vs. dBASE vs. OmniSci

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Drill  Xexclude from comparisonBigchainDB  Xexclude from comparisondBASE  Xexclude from comparisonOmniSci infoFormerly named 'MapD', rebranded to 'OmniSci' in September 2018  Xexclude from comparison
DescriptionSchema-free SQL Query Engine for Hadoop, NoSQL and Cloud StorageBigchainDB is scalable blockchain database offering decentralization, immutability and native assetsdBase 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 GPUs
Primary database modelDocument store
Relational DBMS
Document storeRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.74
Rank#93  Overall
#17  Document stores
#45  Relational DBMS
Score0.67
Rank#187  Overall
#29  Document stores
Score14.79
Rank#37  Overall
#23  Relational DBMS
Score2.30
Rank#105  Overall
#51  Relational DBMS
Websitedrill.apache.orgwww.bigchaindb.comwww.dbase.comwww.omnisci.com
Technical documentationdrill.apache.org/­docsbigchaindb.readthedocs.io/­en/­latestwww.dbase.com/­support/­knowledgebasedocs.omnisci.com/­latest
DeveloperApache Software FoundationAsthon TateMapD Technologies, Inc.
Initial release2012201619792016
Current release1.16, May 2019dBASE PLUS 11, December 2016V4
License infoCommercial or Open SourceOpen Source infoApache Version 2Open Source infoAGPL v3commercialOpen Source infoApache Version 2; enterprise edition available
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languagePythonC++ and CUDA
Server operating systemsLinux
OS X
Windows
LinuxDOS infodBase Classic
Windows infodBase Pro
Linux
Data schemeschema-freeschema-freeyesyes
Typing infopredefined data types such as float or dateyesnoyesyes
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 indexesnoyesno
SQL infoSupport of SQLSQL SELECT statement is SQL:2003 compliantnonoyes
APIs and other access methodsJDBC
ODBC
RESTful HTTP API
CLI Client
RESTful HTTP API
none infoThe IDE can access other DBMS or ODBC-sources.JDBC
ODBC
Thrift
Supported programming languagesC++Go
Haskell
Java
JavaScript
Python
Ruby
dBase proprietary IDEAll languages supporting JDBC/ODBC/Thrift
Python
Server-side scripts infoStored proceduresuser defined functionsno infoThe IDE can access stored procedures in other database systems.no
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodesShardingShardingnoneSharding infoRound robin
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factornoneMaster-master replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate Consistency
Foreign keys infoReferential integritynonoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanono infonot for dBase internal data, but IDE does support transactions when accessing external DBMSno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentDepending on the underlying data sourceyes,with MongoDB ord RethinkDByesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.Depending on the underlying data sourceyes
User concepts infoAccess controlDepending on the underlying data sourceyesAccess rights for users and rolesfine 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

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

More resources
Apache DrillBigchainDBdBASEOmniSci infoFormerly named 'MapD', rebranded to 'OmniSci' in September 2018
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

MapR Advances Support for Flexible and High Performance Analytics on JSON and S3 Data with Apache Drill
30 January 2019, Business Wire

Apache Drill Poised to Crack Tough Data Challenges
19 May 2015, Datanami

Amazon's PartiQL query language eyes all data sources
6 August 2019, TechTarget

MapR Ships Drill For SQL Analysis Of Big Data
16 September 2014, InformationWeek

SQL Syntax for Apache Drill
16 December 2015, DZone News

provided by Google News

Block chain in Manufacturing Market to Reflect a Holistic Expansion with Project Provenance Ltd., Everledger Ltd, Supercomputing Systems AG, and More – Dagoretti News
20 January 2020, Dagoretti News

Latest Research on Blockchain in Energy Market 2019: Comprehensive study by key players: IBM, SAP SE, Deloitte LLP, Accenture plc, Infosys Limited, BigchainDB GmbH, Oracle corporation, Power Ledger Pty Ltd, Microsoft Corporation, Amazon Web Services Inc
20 January 2020, Fusion Science Academy

Global Blockchain for Enterprise Applications Market Quality and Quantity Analysis BY ConsenSys, BigchainDB, Block Array and Barclays
7 January 2020, Neptune Pine

Blockchain for Enterprise Applications Market Latest Technology Usages 2020-2029 By: Barclays, ConsenSys, Block Array and BigchainDB
18 January 2020, TheLoop21

Blockchain In Trade Finance and Credit Insurance Market Predicts Massive Growth by 2024: Key Players- Finextra, IBM, Bain & Company, Deloitte, McKinsey, TradeIX, Bitfury, PYMNTS.com, Capco, Digital Asset Holdings
20 January 2020, Expedition 99

provided by Google News

Two missing digits? How about two missing employees in today's story of Y2K
30 December 2019, The Register

WFP DBase (Logistics Data, Budgets and Systems Execution) Factsheet (November 2019) - World
23 December 2019, ReliefWeb

dBase, LLC. is excited to announce the NEW version of dBASE® 2019 Optimized Edition
19 July 2019, MENAFN.COM

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

provided by Google News

Inside OmniSci's Plans for Data Analytics Convergence
23 October 2019, Datanami

Global GPU Database Market – Industry Analysis and Forecast (2018-2026)
20 January 2020, Fusion Science Academy

OmniSci 'Hitting Its Stride,' CEO Says
25 October 2019, Datanami

Review: OmniSci GPU database lifts huge data sets
1 April 2019, InfoWorld

The insideBIGDATA IMPACT 50 List for Q1 2020
14 January 2020, insideBIGDATA

provided by Google News

Job opportunities

Senior Software Developer
Nielsen, Chicago, IL

Program Manager II-61006505
State of South Carolina, Columbia, SC

DATA ENTRY CLERK II
Duke Careers, Durham, NC

IT Applications Programmer 1
State of Louisiana, Baton Rouge, LA

Broker Digital Enablement
AETNA, Princeton, NJ

Credentials Administrator II
Kaiser Permanente, Oakland, CA

jobs by Indeed




Share this page

Featured Products

Datastax Luna logo

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

MariaDB logo

How do MariaDB, Oracle MySQL and EnterpriseDB compare?
Get the white paper to
learn more.

AllegroGraph logo

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

Neo4j logo

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

Couchbase logo

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

Present your product here