DBMS > Apache Pinot vs. DolphinDB vs. SAP Advantage Database Server vs. Yaacomo

System Properties Comparison Apache Pinot vs. DolphinDB vs. SAP Advantage Database Server vs. Yaacomo

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Apache Pinot  Xexclude from comparison	DolphinDB  Xexclude from comparison	SAP Advantage Database Server former name: Sybase ADS  Xexclude from comparison	Yaacomo  Xexclude from comparison
			SAP Advantage Database Server seems to be discontinued. Therefore it is excluded from the DB-Engines Ranking.	Yaacomo seems to be discontinued and is removed from the DB-Engines ranking
Description	Realtime distributed OLAP datastore, designed to answer OLAP queries with low latency	DolphinDB is a high performance Time Series DBMS. It is integrated with an easy-to-use fully featured programming language and a high-volume high-velocity streaming analytics system. It offers operational simplicity, scalability, fault tolerance, and concurrency.	Low-cost RDBMS with access to ISAM and FoxPro data structures	OpenCL based in-memory RDBMS, designed for efficiently utilizing the hardware via parallel computing
Primary database model	Relational DBMS	Time Series DBMS	Relational DBMS	Relational DBMS
Secondary database models		Relational DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.38 Rank #275   Overall #126   Relational DBMS	Score 4.03 Rank #78   Overall #6   Time Series DBMS
Website	pinot.apache.org	www.dolphindb.com	www.sap.com/products/advantage-database-server.html	yaacomo.com
Technical documentation	docs.pinot.apache.org	docs.dolphindb.cn/­en/­help200/­index.html
Developer	Apache Software Foundation and contributors	DolphinDB, Inc	Sybase, SAP	Q2WEB GmbH
Initial release	2015	2018	1993	2009
Current release	1.0.0, September 2023	v2.00.4, January 2022
License Commercial or Open Source	Open Source Apache Version 2.0	commercial free community version available	commercial	commercial
Cloud-based only Only available as a cloud service	no	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language	Java	C++
Server operating systems	All OS with a Java JDK11 or higher	Linux Windows	Linux Windows	Android Linux Windows
Data scheme	yes	yes	yes	yes
Typing predefined data types such as float or date	yes	yes	yes	yes
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.		no	no	no
Secondary indexes		yes	yes	yes
SQL Support of SQL	SQL-like query language	SQL-like query language	yes	yes
APIs and other access methods	JDBC	JDBC JSON over HTTP Kafka MQTT (Message Queue Telemetry Transport) ODBC OPC DA OPC UA RabbitMQ WebSocket	.NET Client API ADO.NET JDBC ODBC OLE DB	JDBC ODBC
Supported programming languages	Go Java Python	C# C++ Go Java JavaScript MatLab Python R Rust	Delphi Perl PHP
Server-side scripts Stored procedures		yes	yes
Triggers		no	yes	yes
Partitioning methods Methods for storing different data on different nodes	horizontal partitioning	horizontal partitioning	none	horizontal partitioning
Replication methods Methods for redundantly storing data on multiple nodes		yes	Multi-source replication CONFLICT Trigger to resolve replication conflicts Source-replica replication	Source-replica replication
MapReduce Offers an API for user-defined Map/Reduce methods		yes	no	no
Consistency concepts Methods to ensure consistency in a distributed system		Immediate Consistency	Immediate Consistency	Immediate Consistency
Foreign keys Referential integrity		no	yes	yes
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data		yes	ACID	ACID
Concurrency Support for concurrent manipulation of data		yes	yes	yes
Durability Support for making data persistent		yes	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.		yes	no caching of (temporary) tables can be configured	yes
User concepts Access control		Administrators, Users, Groups	fine grained access rights according to SQL-standard	fine 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 Pinot	DolphinDB	SAP Advantage Database Server former name: Sybase ADS	Yaacomo
Recent citations in the news	StarTree broadly enhances Apache Pinot-based analytics platform 8 May 2024, SiliconANGLE News Apache Pinot - SD Times Open Source Project of the Week 31 May 2024, SDTimes.com StarTree Finds Apache Pinot the Right Vintage for IT Observability 8 May 2024, Datanami Real-Time Analytics for Mobile App Crashes using Apache Pinot 2 November 2023, Uber StarTree Makes Observability Case for Apache Pinot Database 8 May 2024, DevOps.com provided by Google News		SAP Announces Q3 2023 Results: Asia Pacific and Japan View 19 October 2023, SAP News provided by Google News

Share this page