DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Apache Impala vs. Heroic vs. Raima Database Manager vs. SAP SQL Anywhere vs. Valentina Server

System Properties Comparison Apache Impala vs. Heroic vs. Raima Database Manager vs. SAP SQL Anywhere vs. Valentina Server

Editorial information provided by DB-Engines
NameApache Impala  Xexclude from comparisonHeroic  Xexclude from comparisonRaima Database Manager infoformerly named db_Vista  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparisonValentina Server  Xexclude from comparison
DescriptionAnalytic DBMS for HadoopTime Series DBMS built at Spotify based on Cassandra or Google Cloud Bigtable, and ElasticSearchRDBMS with a small footprint, either embedded into an application or used as a database serverRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environmentsObject-relational database and reports server
Primary database modelRelational DBMSTime Series DBMSRelational DBMS
Time Series DBMS
Relational DBMSRelational DBMS
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score11.30
Rank#41  Overall
#25  Relational DBMS
Score0.02
Rank#363  Overall
#37  Time Series DBMS
Score0.24
Rank#295  Overall
#132  Relational DBMS
#23  Time Series DBMS
Score2.87
Rank#88  Overall
#48  Relational DBMS
Score0.11
Rank#330  Overall
#148  Relational DBMS
Websiteimpala.apache.orggithub.com/­spotify/­heroicraima.comwww.sap.com/­products/­technology-platform/­sql-anywhere.htmlwww.valentina-db.net
Technical documentationimpala.apache.org/­impala-docs.htmlspotify.github.io/­heroicdocs.raima.comhelp.sap.com/­docs/­SAP_SQL_Anywherevalentina-db.com/­docs/­dokuwiki/­v5/­doku.php
DeveloperApache Software Foundation infoApache top-level project, originally developed by ClouderaSpotifyRaima Inc.SAP infoformerly SybaseParadigma Software
Initial release20132014198419921999
Current release4.1.0, June 202215, June 202117, July 20155.7.5
License infoCommercial or Open SourceOpen Source infoApache Version 2Open Source infoApache 2.0commercialcommercialcommercial
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 languageC++JavaC
Server operating systemsLinuxAndroid
HP-UX
Integrity RTOS
iOS
Linux
OS X
QNX
Solaris
VxWorks
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
Linux
OS X
Windows
Data schemeyesschema-freeyesyesyes
Typing infopredefined data types such as float or dateyesyesyesyesyes
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 infoExporting/Importing of XML structures possibleyes
Secondary indexesyesyes infovia Elasticsearchyesyesyes
SQL infoSupport of SQLSQL-like DML and DDL statementsnoyesyesyes
APIs and other access methodsJDBC
ODBC
HQL (Heroic Query Language, a JSON-based language)
HTTP API
ADO.NET
JDBC
ODBC
RESTful HTTP API
ADO.NET
HTTP API
JDBC
ODBC
ODBC
Supported programming languagesAll languages supporting JDBC/ODBC.Net
C
C++
Objective-C
PL/SQL
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
.Net
C
C#
C++
Objective-C
PHP
Ruby
Visual Basic
Visual Basic.NET
Server-side scripts infoStored proceduresyes infouser defined functions and integration of map-reducenoyes infobased on the ANSI/ISO SQL Persistent Stored Modules (PSM) specificationyes, in C/C++, Java, .Net or Perlyes
Triggersnonoyesyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardinghorizontal partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factoryesSource-replica replicationSource-replica replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoquery execution via MapReducenononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyEventual Consistency
Immediate Consistency
Immediate Consistency or Eventual Consistency depending on configurationImmediate Consistency
Foreign keys infoReferential integritynonoyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes, multi-version concurrency control (MVCC)yes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyesyesyes
User concepts infoAccess controlAccess rights for users, groups and roles infobased on Apache Sentry and Kerberosnofine grained access rights according to SQL-standardfine grained access rights according to SQL-standard
More information provided by the system vendor
Apache ImpalaHeroicRaima Database Manager infoformerly named db_VistaSAP SQL Anywhere infoformerly called Adaptive Server AnywhereValentina Server
Specific characteristicsRaima Database Manager (RDM) is an embedded time-series database optimized to run...
» more
Competitive advantagesDecreased time-to-market Industry-standard interfaces & tools for making your job...
» more
Typical application scenariosTypical use cases include: Internet of Things (IoT) Embedded In-Memory Database Time-Series...
» more
Key customersInfor, ABB, The Boeing Company, BAE Systems, Dow Jones, Dun & Bradstreet, Fujitsu,...
» more
Market metricsOver 30 000 applications developers worldwide have field-tested RDM products More...
» more
Licensing and pricing modelsJust as the technical aspects of Raima Database Manager are flexible, so are the...
» more
News

RaimaDB and QNX Forge a Powerful Partnership in Embedded Systems
9 July 2024

Raima Unveils RaimaDB 16.0: Elevating Database Performance and User Experience
29 February 2024

Raima Announces Release of Raima Database Manager (RDM) v15, a Powerful Embedded Time Series Database
10 June 2021

Raima Announces Release of Raima Database Manager (RDM) v14.2, a Powerful IoT Edge Embedded Database
8 October 2020

Raima Joins BlackBerry QNX Channel Partner Program to Deliver Safety-Critical and Secure Software Solutions
1 October 2020

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 ImpalaHeroicRaima Database Manager infoformerly named db_VistaSAP SQL Anywhere infoformerly called Adaptive Server AnywhereValentina Server
Recent citations in the news

Apache Impala becomes Top-Level Project
28 November 2017, SDTimes.com

The Apache Software Foundation Announces Apache® Hudi™ as a Top-Level Project
4 June 2020, GlobeNewswire

Hudi: Uber Engineering’s Incremental Processing Framework on Apache Hadoop
12 March 2017, Uber

How different SQL-on-Hadoop engines satisfy BI workloads
24 February 2016, CIO

How do I create a Kudu table via SQL?
10 April 2017, oreilly.com

provided by Google News

How Code Wizards load tested Heroic Labs’ Nakama to two million concurrent players with AWS
1 October 2024, AWS Blog

Review: Google Bigtable scales with ease
7 September 2016, InfoWorld

provided by Google News

Raima re-bundles their Raima Database Manager packages to align with market trends
14 March 2012, Embedded

LabVIEW integrates Raima’s Database API
7 August 2013, Embedded

provided by Google News

Rimini Street expands support beyond SAP and Oracle
11 June 2022, InsideSAP

Securing SAP with AWS Network Firewall: Part 2 – Managed Rules
17 July 2023, AWS Blog

SAP vulnerabilities Let Attacker Inject OS Commands—Patch Now!
11 July 2023, CybersecurityNews

Gartner’s Magic Quadrant for Cloud Database Management Systems
9 December 2020, CRN

Data Integration Tools – Market Study
21 October 2016, Data Science Central

provided by Google News

A Look at Valentina
18 April 2014, SitePoint

MySQL GUI Tools for Windows and Ubuntu/Linux: Top 8 free or open source
6 December 2018, H2S Media

provided by Google News



Share this page

Featured Products

SingleStore logo

The data platform to build your intelligent applications.
Try it 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.

Milvus logo

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

RaimaDB logo

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

Present your product here