DB-EnginesExtremeDB: the hard real time dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > BoltDB vs. HEAVY.AI vs. STSdb vs. UniData,UniVerse vs. Vertica

System Properties Comparison BoltDB vs. HEAVY.AI vs. STSdb vs. UniData,UniVerse vs. Vertica

Editorial information provided by DB-Engines
NameBoltDB  Xexclude from comparisonHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022  Xexclude from comparisonSTSdb  Xexclude from comparisonUniData,UniVerse  Xexclude from comparisonVertica infoVertica Analytics Platform  Xexclude from comparison
DescriptionAn embedded key-value store for Go.A high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardwareKey-Value Store with special method for indexing infooptimized for high performance using a special indexing methodMultiValue database and application server with SQL mapping layer and meta database capabilitiesCloud or on-premises analytical database and query engine for structured and semi-structured streaming and batch data. Machine learning platform with built-in algorithms, data preparation capabilities, and model evaluation and management via SQL or Python.
Primary database modelKey-value storeRelational DBMSKey-value storeMultivalue DBMSRelational DBMS infoColumn oriented
Secondary database modelsSpatial DBMSSpatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.55
Rank#232  Overall
#34  Key-value stores
Score1.29
Rank#153  Overall
#73  Relational DBMS
Score0.01
Rank#345  Overall
#53  Key-value stores
Score4.49
Rank#84  Overall
#2  Multivalue DBMS
Score19.29
Rank#38  Overall
#24  Relational DBMS
Websitegithub.com/­boltdb/­boltgithub.com/­heavyai/­heavydb
www.heavy.ai
github.com/­STSSoft/­STSdb4www.rocketsoftware.com/­products/­rocket-u2www.vertica.com
Technical documentationdocs.heavy.aiwww.rocketsoftware.com/­products/­rocket-u2/­documentationvertica.com/­documentation
DeveloperHEAVY.AI, Inc.STS Soft SCRocket SoftwareMicro Focus infoprior to that Hewlett Packard
Initial release20132016201119852005
Current release5.10, January 20224.0.8, September 201511.1, February 2022
License infoCommercial or Open SourceOpen Source infoMIT LicenseOpen Source infoApache Version 2; enterprise edition availableOpen Source infoGPLv2, commercial license availablecommercialcommercial infoLimited community edition free
Cloud-based only infoOnly available as a cloud servicenonononono infoon-premises, all major clouds - Amazon AWS, Microsoft Azure, Google Cloud Platform and containers
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Vertica Accelerator’s high-performance analytics and machine learning with SQL or Python is available as a managed service.
Implementation languageGoC++ and CUDAC#CC++
Server operating systemsBSD
Linux
OS X
Solaris
Windows
LinuxWindowsAIX
HP-UX
Linux
Solaris
Windows
Linux
Data schemeschema-freeyesyesschema-freeyes, but unstructured data can be stored in specific Flex-Tables
Typing infopredefined data types such as float or datenoyesyes infoprimitive types and user defined types (classes)optionalyes: BINARY, BOOLEAN, CHAR, VARCHAR, LONG VARCHAR, DATE, TIME, TIMESTAMP, INTERVAL, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, DOUBLE PRECISION, FLOAT, INTEGER, BIGINT, SMALLINT,NUMERIC, DECIMAL, NUMBER, MONEY,GEOMETRY
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
Secondary indexesnononoyesNo Indexes Required
SQL infoSupport of SQLnoyesnoyesFull 1999 standard plus machine learning, time series and geospatial. Over 650 functions.
APIs and other access methodsJDBC
ODBC
Thrift
Vega
.NET Client APIJava API infoJPA
JDBC
ODBC
OLE DB
Proprietary protocol
RESTful HTTP API
SOAP-based API
ADO.NET
JDBC
Kafka Connector
ODBC
RESTful HTTP API
Spark Connector
vSQL infocharacter-based, interactive, front-end utility
Supported programming languagesGoAll languages supporting JDBC/ODBC/Thrift
Python
C#
Java
.Net
Basic infoU2 Basic
C
Java
C#
C++
Java
Perl
PHP
Python
R
Server-side scripts infoStored proceduresnononoyesyes, PostgreSQL PL/pgSQL, with minor differences
Triggersnononoyes infoU2 Basicyes, called Custom Alerts
Partitioning methods infoMethods for storing different data on different nodesnoneSharding infoRound robinnonenonehorizontal partitioning, hierarchical partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesnoneMulti-source replicationnoneSource-replica replicationMulti-source replication infoOne, or more copies of data replicated across nodes, or object-store used for repository.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono infoBi-directional Spark integration
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayesnonoACID infoconfigurableACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
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.noyesno
User concepts infoAccess controlnofine grained access rights according to SQL-standardnoAccess rights according to SQL-standard and operating system basedfine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hash
More information provided by the system vendor
BoltDBHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022STSdbUniData,UniVerseVertica infoVertica Analytics Platform
Specific characteristicsOptimizes memory and compute layers to deliver unprecedented performance. Natively...
» more
Deploy-anywhere database for large-scale analytical deployments. Deploy on-premises,...
» more
Competitive advantagesOnly HEAVY.AI allows users to visually and interactively discover high-value patterns,...
» more
Fast, scalable and capable of high concurrency. Separation of compute/storage leverages...
» more
Typical application scenariosAdvanced analytics, geospatial and time-series analytics, accelerated data science,...
» more
Communication and network analytics, Embedded analytics, Fraud monitoring and Risk...
» more
Key customersAbiba Systems, Adform, adMarketplace, AmeriPride, Anritsu, AOL, Avito, Auckland Transport,...
» more
Licensing and pricing modelsHEAVY.AI Free (Free Forever), Foundations ($2k/month), and Enterprise Licensure (Inquire...
» more
Cost-based models and subscription-based models are both available. One license is...
» 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
BoltDBHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022STSdbUniData,UniVerseVertica infoVertica Analytics Platform
Recent citations in the news

Roblox’s cloud-native catastrophe: A post mortem
31 January 2022, InfoWorld

Metaverse Platform Roblox Adds Data Center to Address 73-Hour Outage
24 January 2022, Data Center Frontier

provided by Google News

The insideBIGDATA IMPACT 50 List for Q2 2022
27 April 2022, insideBIGDATA

OmniSci Gets HEAVY New Name and New CEO
1 March 2022, Datanami

Nvidia unveils a new GPU architecture designed for AI data centers
22 March 2022, Network World

The insideBIGDATA IMPACT 50 List for Q1 2022
10 January 2022, insideBIGDATA

Real-time Analytics News for Week Ending March 26
27 March 2022, RTInsights

provided by Google News

StrikeTru Implemented Unidata MDM Solution for Baird & Warner Real Estate Services Company
27 April 2022, PR Web

UniData
22 December 2019, International Spectrum Magazine

Global Ultrasonic Velocity Measuring System Market 2022 – Industry Analysis, Segments, Value Chain and Key Trends 2028 – Queen Anne and Mangolia News
12 May 2022, Queen Anne and Mangolia News

Investors Could Be Concerned With Unidata's (BIT:UD) Returns On Capital
11 May 2021, Simply Wall St

Data + software services
21 August 2018, UCAR

provided by Google News

VAST links arms with Vertica for fast analytics – Blocks and Files
19 April 2022, Blocks and Files

Enterprise Database Management System (DBMS) Market Is Booming Worldwide – Queen Anne and Mangolia News
9 May 2022, Queen Anne and Mangolia News

“Above the Trend Line” – Your Industry Rumor Central for 5/5/2022
5 May 2022, insideBIGDATA

Sesame Software Launches Vertica Data Connector for High-Volume Connectivity to Cloud and On-Premise Applications
15 February 2022, PR Newswire

Vertica and H3C ONEStor Bring Cloud-Scale Analytics to Enterprise Data Centers
23 February 2022, PR Newswire

provided by Google News

Job opportunities

Senior DevOps Engineer
NVIDIA, Santa Clara, CA

Product Designer 2
Microsoft, Redmond, WA

Accountant
HEAVY.AI, Inc., San Francisco Bay Area, CA

Software Engineer (Unidata)
Paychex, LLC, West Palm Beach, FL

IT Report Writer - Database Software
AlphaStaff, Remote

Colleague Programmer - National- Remote
CampusWorks, Remote

Engineer - Entry Level
Cabinetworks Group, Warren, OH

Analyst, Data
Guilford Technical Community College, Jamestown, NC

Software Test Engineer (entry-level)
Real-Time Technology Solutions, Remote

QA Engineer - Database Server at Vertica (REMOTE, Work From Home Available within the U.S.)
Micro Focus, Cambridge, MA

Systems Software Engineer at Vertica (REMOTE / WORK FROM HOME)
Vertica, Rhode Island

Systems Software Engineer at Vertica (REMOTE / WORK FROM HOME)
Micro Focus, Cambridge, MA

Software Engineer at Vertica
Vertica, Cambridge, MA

jobs by Indeed



Share this page

Featured Products

Redis logo

The world’s most loved real‑time data platform.
Try free

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

Present your product here