DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > mSQL vs. OrigoDB vs. SiteWhere vs. Transwarp KunDB vs. Trino

System Properties Comparison mSQL vs. OrigoDB vs. SiteWhere vs. Transwarp KunDB vs. Trino

Editorial information provided by DB-Engines
NamemSQL infoMini SQL  Xexclude from comparisonOrigoDB  Xexclude from comparisonSiteWhere  Xexclude from comparisonTranswarp KunDB  Xexclude from comparisonTrino  Xexclude from comparison
DescriptionmSQL (Mini SQL) is a simple and lightweight RDBMSA fully ACID in-memory object graph databaseM2M integration platform for persisting/querying time series dataOLTP DBMS based on a distributed architecture and highly compatible with MySQL and OracleFast distributed SQL query engine for big data analytics. Forked from Presto and originally named PrestoSQL
Primary database modelRelational DBMSDocument store
Object oriented DBMS
Time Series DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument store
Key-value store
Spatial DBMS
Search engine
Time Series DBMS
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.24
Rank#162  Overall
#74  Relational DBMS
Score0.00
Rank#388  Overall
#54  Document stores
#21  Object oriented DBMS
Score0.07
Rank#345  Overall
#31  Time Series DBMS
Score0.01
Rank#374  Overall
#158  Relational DBMS
Score5.47
Rank#62  Overall
#35  Relational DBMS
Websitehughestech.com.au/­products/­msqlorigodb.comgithub.com/­sitewhere/­sitewherewww.transwarp.cn/­en/­product/­kundbtrino.io
Technical documentationorigodb.com/­docssitewhere1.sitewhere.io/­index.htmltrino.io/­broadcast
trino.io/­docs/­current
DeveloperHughes TechnologiesRobert Friberg et alSiteWhereTranswarpTrino Software Foundation
Initial release19942009 infounder the name LiveDB20102012 info2020 rebranded from PrestoSQL
Current release4.4, October 2021
License infoCommercial or Open Sourcecommercial infofree licenses can be providedOpen SourceOpen Source infoCommon Public Attribution License Version 1.0commercialOpen Source infoApache Version 2.0
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC#JavaJava
Server operating systemsAIX
HP-UX
Linux
OS X
Solaris SPARC/x86
Windows
Linux
Windows
Linux
OS X
Windows
Linux
macOS infofor devlopment
Data schemeyesyespredefined schemeyesyes
Typing infopredefined data types such as float or dateyesUser defined using .NET types and collectionsyesyesyes
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 infocan be achieved using .NETnono
Secondary indexesyesyesnoyesdepending on connected data-source
SQL infoSupport of SQLA subset of ANSI SQL is implemented infono subqueries, aggregate functions, views, foreign keys, triggersnonoyesyes
APIs and other access methodsJDBC
ODBC
.NET Client API
HTTP API
LINQ
HTTP RESTJDBC
RESTful HTTP API
Trino CLI
Supported programming languagesC
C++
Delphi
Java
Perl
PHP
Tcl
.NetGo
Java
JavaScript (Node.js)
Python
R
Ruby
Server-side scripts infoStored proceduresnoyesyesyes, depending on connected data-source
Triggersnoyes infoDomain Eventsyesno
Partitioning methods infoMethods for storing different data on different nodesnonehorizontal partitioning infoclient side managed; servers are not synchronizedSharding infobased on HBasehorizontal partitioningdepending on connected data-source
Replication methods infoMethods for redundantly storing data on multiple nodesnoneSource-replica replicationselectable replication factor infobased on HBasedepending on connected data-source
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate Consistencydepending on connected data-source
Foreign keys infoReferential integritynodepending on modelnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDnoACIDdepending on connected data-source
Concurrency infoSupport for concurrent manipulation of datanoyesyesyesyes
Durability infoSupport for making data persistentyesyes infoWrite ahead logyesyesdepending on connected data-source
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesno
User concepts infoAccess controlnoRole based authorizationUsers with fine-grained authorization conceptyesSQL standard access control
More information provided by the system vendor
mSQL infoMini SQLOrigoDBSiteWhereTranswarp KunDBTrino
News

A glimpse at the summit
17 October 2024

A Kubernetes operator for Trino?
10 October 2024

SQL basecamps before Trino Summit
7 October 2024

23 is a go, keeping pace with Java
17 September 2024

66: Chat with Trino and Wren AI
12 September 2024

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
mSQL infoMini SQLOrigoDBSiteWhereTranswarp KunDBTrino
Recent citations in the news

Higher Education PS rules out ghost students before PAC – Zambia
29 November 2018, diggers.news

provided by Google News

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

Top Open-Source Tools for IoT Development in 2024
5 September 2024, Analytics Insight

provided by Google News

The Perfect AI Storage: Trino From Facebook And Iceberg From Netflix?
30 April 2024, The Next Platform

A look at Presto, Trino SQL query engines
9 August 2022, TechTarget

Run queries up to 9x faster using Trino with Amazon S3 Select on Amazon EMR
21 November 2022, AWS Blog

Starburst Advances 'Icehouse' for Near Real-Time Analytics on the Open Data Lakehouse
10 April 2024, PR Newswire

Starburst, which promises faster analytics on decentralized data, raises $250M
9 February 2022, VentureBeat

provided by Google News



Share this page

Featured Products

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Milvus logo

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

Neo4j logo

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB 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