DBMS > HEAVY.AI vs. PostgreSQL vs. VoltDB
System Properties Comparison HEAVY.AI vs. PostgreSQL vs. VoltDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||HEAVY.AI Formerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022 Xexclude from comparison||PostgreSQL Xexclude from comparison||VoltDB Xexclude from comparison|
|Description||A high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardware||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||Distributed In-Memory NewSQL RDBMS Used for OLTP applications with a high frequency of relatively simple transactions, that can hold all their data in memory|
|Primary database model||Relational DBMS||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Relational DBMS|
|Secondary database models||Spatial DBMS||Document store|
Graph DBMS with Apache Age
|Developer||HEAVY.AI, Inc.||PostgreSQL Global Development Group www.postgresql.org/developer||VoltDB Inc.|
|Initial release||2016||1989 1989: Postgres, 1996: PostgreSQL||2010|
|Current release||5.10, January 2022||15.3, May 2023||11.3, April 2022|
|License Commercial or Open Source||Open Source Apache Version 2; enterprise edition available||Open Source BSD||Open Source AGPL for Community Edition, commercial license for Enterprise, AWS, and Pro Editions|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||C++ and CUDA||C||Java, C++|
|Server operating systems||Linux||FreeBSD|
OS X for development
|Typing predefined data types such as float or date||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||yes specific XML-type available, but no XML query functionality.|
|SQL Support of SQL||yes||yes standard with numerous extensions||yes only a subset of SQL 99|
|APIs and other access methods||JDBC|
native C library
streaming API for large objects
RESTful HTTP/JSON API
|Supported programming languages||All languages supporting JDBC/ODBC/Thrift|
Erlang not officially supported
|Server-side scripts Stored procedures||no||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||Java|
|Partitioning methods Methods for storing different data on different nodes||Sharding Round robin||partitioning by range, list and (since PostgreSQL 11) by hash||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-source replication||Source-replica replication other methods possible by using 3rd party extensions||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||no||yes||no FOREIGN KEY constraints are not supported|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID||ACID Transactions are executed single-threaded within stored procedures|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes Data access is serialized by the server|
|Durability Support for making data persistent||yes||yes||yes Snapshots and command logging|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||no|
|User concepts Access control||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard||Users and roles with access to stored procedures|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
Instaclustr: Fully Hosted & Managed PostgreSQL
Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
DbVisualizer is equipping database professionals with the tools they need to build, manage and maintain state-of-the-art database technologies. It has sky-high user satisfaction and is the preferred tool for database professionals around the world. Customers include Tesla, Apple, Facebook, Deutsche Bank, NASA, and 25,000 others in 145 countries.
SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
pgDash: In-Depth PostgreSQL Monitoring.
The State of PostgreSQL 2022 survey is now open!
Aiven for PostgreSQL: The familiar open source PostgreSQL® that you know and love, with no proprietary features or add-ons that will lock you in.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|HEAVY.AI Formerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022||PostgreSQL||VoltDB|
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year Snowflake is the DBMS of the Year 2021 Driving the Future of PostgreSQL Adoption
Snowflake is the DBMS of the Year 2021 Driving the Future of PostgreSQL Adoption
Driving the Future of PostgreSQL Adoption
|Conferences and events|
PGCon 2023, PostgreSQL Conference for Users and Developers
|Recent citations in the news|
insideBIGDATA Latest News – 5/8/2023
Metaphysic Deep Fakes TED
HEAVY.AI Launches HEAVY 7.0, Introducing Real-Time Machine ...
Making the most of geospatial intelligence
The insideBIGDATA IMPACT 50 List for Q1 2023
provided by Google News
PostgreSQL 16 advances query parallelism
MariaDB's Xpand offers PostgreSQL compatibility without the forking drama
How to Migrate from Oracle to PostgreSQL
Devart Tools for PostgreSQL Come with a Massive Update
How to Set Up a PostgreSQL Database on Ubuntu
provided by Google News
RDBMS Software Market 2023 Growth Drivers and Future Outlook ...
Data Management System (DBMS) Market Size & Share | Outlook ...
Database Management Systems (DBMS) Market 2023-2031 ...
Visualizing IoT Data at Scale With Hopara and TimescaleDB
In-Memory Database Market Analysis 2023-2031: Competitive ...
provided by Google News
Senior Big Data Engineer (Remote)
Lead / Principal UX Designer
PostgreSQL Database Administrator
Software Engineer – Python, Django, Postgresql
Share this page