DBMS > H2 vs. Oracle Rdb vs. TempoIQ
System Properties Comparison H2 vs. Oracle Rdb vs. TempoIQ
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||H2 Xexclude from comparison||Oracle Rdb Xexclude from comparison||TempoIQ formerly TempoDB Xexclude from comparison|
|TempoIQ seems to be decommissioned. It will be removed from the DB-Engines ranking.|
|Description||Full-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.||Scalable analytics DBMS for sensor data, provided as a service (SaaS)|
|Primary database model||Relational DBMS||Relational DBMS||Time Series DBMS|
|Secondary database models||Spatial DBMS|
|Developer||Thomas Mueller||Oracle, originally developed by Digital Equipment Corporation (DEC)||TempoIQ|
|Current release||2.2.220, July 2023||220.127.116.11, 2021|
|License Commercial or Open Source||Open Source dual-licence (Mozilla public license, Eclipse public license)||commercial||commercial|
|Cloud-based only Only available as a cloud service||no||no||yes|
|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||HP Open VMS|
|Data scheme||yes||Flexible Schema (defined schema, partial schema, schema free)||schema-free|
|Typing predefined data types such as float or date||yes||yes||yes|
|SQL Support of SQL||yes||yes||no|
|APIs and other access methods||JDBC|
|Supported programming languages||Java||C#|
|Server-side scripts Stored procedures||Java Stored Procedures and User-Defined Functions||no|
|Triggers||yes||yes Realtime Alerts|
|Partitioning methods Methods for storing different data on different nodes||none|
|Replication methods Methods for redundantly storing data on multiple nodes||With clustering: 2 database servers on different computers operate on identical copies of a database|
|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||yes||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||yes, on a single node||no|
|Concurrency Support for concurrent manipulation of data||yes, multi-version concurrency control (MVCC)||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||no|
|User concepts Access control||fine grained access rights according to SQL-standard||simple authentication-based access control|
More information provided by the system vendor
Related products and services
|H2||Oracle Rdb||TempoIQ formerly TempoDB|
|Recent citations in the news|
Oracle Adds New AI-Enabling Features To MySQL HeatWave
Oracle Business Model - How Oracle Makes Money?
Oracle: Datenbank- und Business-IT Gigant [PORTRÄT]
Oracle Aktie Analyse
provided by Google News
6 IoT Startups That Make Connecting Things To The Cloud A Breeze
Big Data and Analytics Industry Growth Factors, Applications, and ...
Spillover effect: Oil price crash bankrupting 'small oil'
The Industrial IoT: Startups Transforming Factory Floors, Oil Fields ...
IIoT and Cloud Computing Market Business Strategy and Growth ...
provided by Google News
Share this page