DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Databricks vs. FatDB vs. GeoMesa vs. JSqlDb vs. LokiJS

System Properties Comparison Databricks vs. FatDB vs. GeoMesa vs. JSqlDb vs. LokiJS

Editorial information provided by DB-Engines
NameDatabricks  Xexclude from comparisonFatDB  Xexclude from comparisonGeoMesa  Xexclude from comparisonJSqlDb  Xexclude from comparisonLokiJS  Xexclude from comparison
FatDB/FatCloud has ceased operations as a company with February 2014. FatDB is discontinued and excluded from the ranking.JSqlDB seems to be discontinued. Therefore it is excluded from the DB-Engines ranking.
DescriptionThe Databricks Lakehouse Platform combines elements of data lakes and data warehouses to provide a unified view onto structured and unstructured data. It is based on Apache Spark.A .NET NoSQL DBMS that can integrate with and extend SQL Server.GeoMesa is a distributed spatio-temporal DBMS based on various systems as storage layer.JavaScript Query Language Database, stores JavaScript objects and primitivesIn-memory JavaScript DBMS
Primary database modelDocument store
Relational DBMS
Document store
Key-value store
Spatial DBMSDocument store
Object oriented DBMS
Document store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score78.61
Rank#15  Overall
#2  Document stores
#10  Relational DBMS
Score0.78
Rank#213  Overall
#4  Spatial DBMS
Score0.43
Rank#264  Overall
#42  Document stores
Websitewww.databricks.comwww.geomesa.orgjsqldb.org (offline)github.com/­techfort/­LokiJS
Technical documentationdocs.databricks.comwww.geomesa.org/­documentation/­stable/­user/­index.htmltechfort.github.io/­LokiJS
DeveloperDatabricksFatCloudCCRi and othersKonrad von Backstrom
Initial release20132012201420182014
Current release4.0.5, February 20240.8, December 2018
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache License 2.0Open SourceOpen Source
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC#ScalaJavaScript
Server operating systemshostedWindowsLinux
macOS
Windows
server-less, requires a JavaScript environment (browser, Node.js)
Data schemeFlexible Schema (defined schema, partial schema, schema free)schema-freeyesschema-freeschema-free
Typing infopredefined data types such as float or dateyesyesnono
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.yesnonono
Secondary indexesyesyesyesnoyes infovia views
SQL infoSupport of SQLwith Databricks SQLno infoVia inetgration in SQL Servernonono
APIs and other access methodsJDBC
ODBC
RESTful HTTP API
.NET Client API
LINQ
RESTful HTTP API
RPC
Windows WCF Bindings
JavaScript API
Supported programming languagesPython
R
Scala
C#JavaScriptJavaScript
Server-side scripts infoStored proceduresuser defined functions and aggregatesyes infovia applicationsnofunctions in JavaScriptView functions in JavaScript
Triggersyes infovia applicationsnonoyes
Partitioning methods infoMethods for storing different data on different nodesShardingdepending on storage layernonenone
Replication methods infoMethods for redundantly storing data on multiple nodesyesselectable replication factordepending on storage layernonenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesyesnoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency
depending on storage layernone
Foreign keys infoReferential integritynononono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnonono infoatomic operations within a single collection possible
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyesyes infousing RocksDByes infoSerialization of a DB in a Node.JS/Cordova/PhoneGap environment. Usage of the IndexedDB-API in a browser.
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nodepending on storage layeryes
User concepts infoAccess controlno infoCan implement custom security layer via applicationsyes infodepending on the DBMS used for storageno
More information provided by the system vendor
DatabricksFatDBGeoMesaJSqlDbLokiJS
Specific characteristicsSupported database models : In addition to the Document store and Relational DBMS...
» more

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
DatabricksFatDBGeoMesaJSqlDbLokiJS
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2023
2 January 2024, Matthias Gelbmann, Paul Andlinger

show all

Spatial database management systems
6 April 2021, Matthias Gelbmann

show all

New kids on the block: database management systems implemented in JavaScript
1 December 2014, Matthias Gelbmann

show all

Recent citations in the news

5. Databricks
14 May 2024, CNBC

This Is the Platform Nancy Pelosi Used to Make Her Private Investment in Databricks
9 May 2024, Yahoo Finance

AI is Driving Record Sales at Multibillion-Dollar Databricks. An IPO Can Wait … - WSJ
6 March 2024, The Wall Street Journal

Top 5 Lessons Learned from Databricks' Journey from $400M to $1.5B+
23 April 2024, SaaStr

Researchers from Columbia University and Databricks Conducted a Comparative Study of LoRA and Full Finetuning in Large Language Models
19 May 2024, MarkTechPost

provided by Google News

LokiJS - A JavaScript Database
18 November 2014, iProgrammer

LokiJS Reaches 1.4
8 July 2016, iProgrammer

provided by Google News



Share this page

Featured Products

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

SingleStore logo

Build AI apps with Vectors on SQL and JSON with milliseconds response times.
Try it today.

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