DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > atoti vs. CockroachDB vs. dBASE vs. Spark SQL vs. TempoIQ

System Properties Comparison atoti vs. CockroachDB vs. dBASE vs. Spark SQL vs. TempoIQ

Editorial information provided by DB-Engines
Nameatoti  Xexclude from comparisonCockroachDB  Xexclude from comparisondBASE  Xexclude from comparisonSpark SQL  Xexclude from comparisonTempoIQ infoformerly TempoDB  Xexclude from comparison
TempoIQ seems to be decommissioned. It will be removed from the DB-Engines ranking.
DescriptionAn in-memory DBMS combining transactional and analytical processing to handle the aggregation of ever-changing data.CockroachDB is a distributed database architected for modern cloud applications. It is wire compatible with PostgreSQL and backed by a Key-Value Store, which is either RocksDB or a purpose-built derivative, called Pebble.dBase 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.Spark SQL is a component on top of 'Spark Core' for structured data processingScalable analytics DBMS for sensor data, provided as a service (SaaS)
Primary database modelObject oriented DBMSRelational DBMSRelational DBMSRelational DBMSTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.61
Rank#243  Overall
#10  Object oriented DBMS
Score5.73
Rank#58  Overall
#34  Relational DBMS
Score9.70
Rank#44  Overall
#28  Relational DBMS
Score18.04
Rank#33  Overall
#20  Relational DBMS
Websiteatoti.iowww.cockroachlabs.comwww.dbase.comspark.apache.org/­sqltempoiq.com (offline)
Technical documentationdocs.atoti.iowww.cockroachlabs.com/­docswww.dbase.com/­support/­knowledgebasespark.apache.org/­docs/­latest/­sql-programming-guide.html
DeveloperActiveViamCockroach LabsAsthon TateApache Software FoundationTempoIQ
Initial release2015197920142012
Current release24.1.0, May 2024dBASE 2019, 20193.5.0 ( 2.13), September 2023
License infoCommercial or Open Sourcecommercial infofree versions availableOpen Source infoApache 2.0, commercial license availablecommercialOpen Source infoApache 2.0commercial
Cloud-based only infoOnly available as a cloud servicenonononoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaGoScala
Server operating systemsLinux
macOS
Windows
DOS infodBase Classic
Windows infodBase Pro
Linux
OS X
Windows
Data schemedynamic schemayesyesschema-free
Typing infopredefined data types such as float or dateyesyesyesyes
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 indexesyesyesno
SQL infoSupport of SQLMultidimensional Expressions (MDX)yes, wire compatible with PostgreSQLnoSQL-like DML and DDL statementsno
APIs and other access methodsJDBCnone infoThe IDE can access other DBMS or ODBC-sources.JDBC
ODBC
HTTP API
Supported programming languagesC#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
dBase proprietary IDEJava
Python
R
Scala
C#
Java
JavaScript infoNode.js
Python
Ruby
Server-side scripts infoStored proceduresPythonnono infoThe IDE can access stored procedures in other database systems.nono
Triggersnononoyes infoRealtime Alerts
Partitioning methods infoMethods for storing different data on different nodesSharding, horizontal partitioninghorizontal partitioning (by key range) infoall tables are translated to an ordered KV store and then broken down into 64MB ranges, which are then used as replicas in RAFTnoneyes, utilizing Spark Core
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication using RAFTnonenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integrityyesyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infonot for dBase internal data, but IDE does support transactions when accessing external DBMSnono
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnonono
User concepts infoAccess controlRole-based access controlAccess rights for users and rolesnosimple authentication-based access control

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
atotiCockroachDBdBASESpark SQLTempoIQ infoformerly TempoDB
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

FRTB product of the year: ActiveViam
28 November 2023, Risk.net

provided by Google News

Cockroach Labs Deepens Partnership with Google Cloud, CockroachDB Selected to Join Google Distributed Cloud
9 April 2024, PR Newswire

CockroachDB tempts legacy databases to crawl into the cloud age
29 January 2024, The Register

How DoorDash Migrated from Aurora Postgres to CockroachDB
5 December 2023, The New Stack

DoorDash Uses CockroachDB to Create Config Management Platform for Microservices
14 February 2024, InfoQ.com

How to Unlock Real-Time Data Streams with CockroachDB and Amazon MSK | Amazon Web Services
6 November 2023, AWS Blog

provided by Google News

AIHA and dBase Media Launch Season Two of Healthier Workplaces, A Healthier World, an Occupational and ...
13 June 2024, Business Wire

30 Years Ago: The Rise, Fall and Survival of Ashton-Tate's dBASE
19 September 2013, eWeek

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

A malicious document could lead to RCE in Apache OpenOffice (CVE-2021-33035)
22 September 2021, Help Net Security

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

provided by Google News

Use Amazon Athena with Spark SQL for your open-source transactional table formats | Amazon Web Services
24 January 2024, AWS Blog

What is Apache Spark? The big data platform that crushed Hadoop
3 April 2024, InfoWorld

Cracking the Apache Spark Interview: 80+ Top Questions and Answers for 2024
1 April 2024, Simplilearn

Performance Insights from Sigma Rule Detections in Spark Streaming
1 June 2024, Towards Data Science

Simba Technologies(R) Introduces New, Powerful JDBC Driver With SQL Connector for Apache Spark(TM)
17 March 2024, Yahoo Singapore News

provided by Google News

No-Code Internet of Things Development Platform
29 October 2015, Automation World

provided by Google News



Share this page

Featured Products

Neo4j logo

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Present your product here