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 > Citus vs. Hazelcast vs. LMDB vs. SiteWhere

System Properties Comparison Citus vs. Hazelcast vs. LMDB vs. SiteWhere

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameCitus  Xexclude from comparisonHazelcast  Xexclude from comparisonLMDB  Xexclude from comparisonSiteWhere  Xexclude from comparison
DescriptionScalable hybrid operational and analytics RDBMS for big data use cases based on PostgreSQLA widely adopted in-memory data gridA high performant, light-weight, embedded key-value database libraryM2M integration platform for persisting/querying time series data
Primary database modelRelational DBMSKey-value storeKey-value storeTime Series DBMS
Secondary database modelsDocument storeDocument store infoJSON support with IMDG 3.12
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.15
Rank#117  Overall
#56  Relational DBMS
Score5.46
Rank#61  Overall
#7  Key-value stores
Score2.09
Rank#121  Overall
#20  Key-value stores
Score0.06
Rank#383  Overall
#43  Time Series DBMS
Websitewww.citusdata.comhazelcast.comwww.symas.com/­symas-embedded-database-lmdbgithub.com/­sitewhere/­sitewhere
Technical documentationdocs.citusdata.comhazelcast.org/­imdg/­docswww.lmdb.tech/­docsitewhere1.sitewhere.io/­index.html
DeveloperHazelcastSymasSiteWhere
Initial release2010200820112010
Current release8.1, December 20185.3.6, November 20230.9.32, January 2024
License infoCommercial or Open SourceOpen Source infoAGPL, commercial license also availableOpen Source infoApache Version 2; commercial licenses availableOpen SourceOpen Source infoCommon Public Attribution License Version 1.0
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 languageCJavaCJava
Server operating systemsLinuxAll OS with a Java VMLinux
Unix
Windows
Linux
OS X
Windows
Data schemeyesschema-freeschema-freepredefined scheme
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.yes infospecific XML type available, but no XML query functionalityyes infothe object must implement a serialization strategynono
Secondary indexesyesyesnono
SQL infoSupport of SQLyes infostandard, with numerous extensionsSQL-like query languagenono
APIs and other access methodsADO.NET
JDBC
native C library
ODBC
streaming API for large objects
JCache
JPA
Memcached protocol
RESTful HTTP API
HTTP REST
Supported programming languages.Net
C
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
.Net
C#
C++
Clojure
Go
Java
JavaScript (Node.js)
Python
Scala
.Net
C
C++
Clojure
Go
Haskell
Java
JavaScript (Node.js)
Lisp
Lua
MatLab
Nim
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Rust
Swift
Tcl
Server-side scripts infoStored proceduresuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.yes infoEvent Listeners, Executor Servicesno
Triggersyesyes infoEventsno
Partitioning methods infoMethods for storing different data on different nodesShardingShardingnoneSharding infobased on HBase
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replication infoother methods possible by using 3rd party extensionsyes infoReplicated Mapnoneselectable replication factor infobased on HBase
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency selectable by user infoRaft Consensus AlgorithmImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDone or two-phase-commit; repeatable reads; read commitedACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
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.noyesyesno
User concepts infoAccess controlfine grained access rights according to SQL-standardRole-based access controlnoUsers with fine-grained authorization concept

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
CitusHazelcastLMDBSiteWhere
Recent citations in the news

Ubicloud wants to build an open source alternative to AWS
5 March 2024, TechCrunch

Ubicloud reels in $16M for its open-source cloud platform
5 March 2024, SiliconANGLE News

Microsoft acquires Citus Data, re-affirming its commitment to Open Source and accelerating Azure PostgreSQL ...
24 January 2019, blogs.microsoft.com

Distributed PostgreSQL Benchmarks: Azure Cosmos DB, CockroachDB, and YugabyteDB
8 July 2023, InfoQ.com

Microsoft Benchmarks Distributed PostgreSQL DBs
10 July 2023, Datanami

provided by Google News

Hazelcast Weaves Wider Logic Threads Through The Data Fabric
7 March 2024, Forbes

Hazelcast 5.4 real time data processing platform boosts AI and consistency
17 April 2024, VentureBeat

Hazelcast appoints Anthony Griffin as Chief Architect -
11 June 2024, Enterprise Times

Hazelcast Showcases Real-Time Data Platform at 2024 Gartner Summit
15 May 2024, Datanami

Hazelcast Versus Redis: A Practical Comparison
4 January 2024, Database Trends and Applications

provided by Google News

The Tom Brady Data Biography
8 September 2023, StatsBomb

Automating SAP S/4HANA Migration with IT-Conductor, BGP Managed Services, and AWS | Amazon Web Services
22 August 2023, AWS Blog

The Lightning Memory-mapped Database
2 March 2016, InfoQ.com

Akamai launches managed database service – Blocks and Files
25 April 2022, Blocks and Files

Connecting the worlds of metabolomics databases
15 June 2021, Medical Xpress

provided by Google News

SiteWhere: An open platform for connected devices
11 July 2017, Open Source For You

Ten Popular IoT Platforms You Should be Aware of
27 March 2023, Open Source For You

11 Best Open source IoT Platforms To Develop Smart Projects
9 March 2023, H2S Media

provided by Google News



Share this page

Featured Products

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

Neo4j logo

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

Present your product here