DBMS > HyperSQL vs. PieCloudDB vs. UniData,UniVerse
System Properties Comparison HyperSQL vs. PieCloudDB vs. UniData,UniVerse
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||HyperSQL also known as HSQLDB Xexclude from comparison||PieCloudDB Xexclude from comparison||UniData,UniVerse Xexclude from comparison|
|Description||Multithreaded, transactional RDBMS written in Java also known as HSQLDB||A cloud-native analytic database platform with new technologoy for elastic MPP||MultiValue database and application server with SQL mapping layer and meta database capabilities|
|Primary database model||Relational DBMS||Relational DBMS||Multivalue DBMS|
|Current release||2.7.1, October 2022||2.1, January 2023|
|License Commercial or Open Source||Open Source based on BSD license||commercial||commercial|
|Cloud-based only Only available as a cloud service||no||yes||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||All OS with a Java VM Embedded (into Java applications) and Client-Server operating modes||hosted||AIX|
|Typing predefined data types such as float or date||yes||yes||optional|
|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|
|SQL Support of SQL||yes||yes||yes|
|APIs and other access methods||HTTP API JDBC via HTTP|
|Java API JPA|
RESTful HTTP API
|Supported programming languages||All languages supporting JDBC/ODBC|
Basic U2 Basic
|Server-side scripts Stored procedures||Java, SQL||user defined functions||yes|
|Triggers||yes||no||yes U2 Basic|
|Partitioning methods Methods for storing different data on different nodes||none||yes||none|
|Replication methods Methods for redundantly storing data on multiple nodes||none||yes||Source-replica replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID configurable|
|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|
|User concepts Access control||fine grained access rights according to SQL-standard||User Roles and pluggable authentication with full SQL Standard||Access rights according to SQL-standard and operating system based|
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
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|HyperSQL also known as HSQLDB||PieCloudDB||UniData,UniVerse|
|Recent citations in the news|
HyperSQL DataBase flaw leaves library vulnerable to RCE
Introduction to JDBC with HSQLDB tutorial
Upcoming ‘critical’ OpenSSL update prompts feverish speculation
SQLite patches 22-year-old code execution, denial of service vulnerability
Java News Roundup: JEPs Targeted for JDK 20, AWS Introduces ...
provided by Google News
Unidata, double-digit revenue increase in 2022; profit decline ...
Unidata launches Milan 25 Gbps service via TWT brand
UNIDATA SELECTS ASN AND ELETTRA Tlc TO BUILD NEW ...
Pioneer Consulting Assists Unidata in Development of Unitirreno ...
Unidata (BIT:UD) Could Easily Take On More Debt
provided by Google News
Business Support Specialist
Consultant - Colleague ERP (Remote)
Colleague Consultant/ Programmer (P117)
Applications Specialist III
Administrator, Application Systems
Chief Institutional Research Officer
Share this page