TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    H2 Database

    Score8 out of 10
    N/AH2 Database Engine is an open source, embeddable database management system (RDMS) written in Java.N/A

    IBM IMS

    Score9.9 out of 10
    N/AIBM IMS, for Information Management System, is a database and transaction server.N/A
    Pricing
    H2 DatabaseIBM IMS
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    H2 DatabaseIBM IMS
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Best Alternatives
    H2 DatabaseIBM IMS
    Small Businesses
    MariaDB Platform
    Score9.1 out of 10
    No answers on this topic
    Medium-sized Companies
    PostgreSQL
    Score8.8 out of 10
    No answers on this topic
    Enterprises
    SQLite
    Score8 out of 10
    No answers on this topic
    All AlternativesView all alternativesView all alternatives
    User Ratings
    H2 DatabaseIBM IMS
    Likelihood to Recommend
    8.0
    (2 ratings)
    7.0
    (1 ratings)
    User Testimonials
    H2 DatabaseIBM IMS
    Likelihood to Recommend
    Open Source
    For running application tests it's well suited. H2 [Database Engine] can replace the real-world database solution for them easily and removes the requirement to set up a a separate database instance just for running unit tests. For using in actual production application one needs to consider scale. H2 is suitable if application runs in single instance and database is located in same machine as a file where that application runs. This means the application shouldn't have a large user base. However it's easy to switch to an actual MySQL instance if the need arises, it's most likely only a configuration change and doesn't require new code.
    Incentivized
    Read full review
    IBM
    We have built a database of a network of bank branches with all the needs of security and recovery/restart. It requires knowledge of obsolete maintenance languages and perhaps it is too rigid in the schemes.
    Incentivized
    Read full review
    Pros
    Open Source
    • Can run as an in-memory database.
    • Simple and quick to get started with, and is light weight (only 2MB).
    • SQL compliant so it compatible with most relational databases.
    Incentivized
    Read full review
    IBM
    • Security
    • Reliability
    • Big volume of data and good performance
    Incentivized
    Read full review
    Cons
    Open Source
    • There's a warning in official FAQ "Is it Reliable?"-section which makes it seem like H2 is not yet a mature product.
    • If raw SQL queries are used there maybe be differences between MySQL & H2. ORM library should be used.
    • Support seems to be community-based only.
    Incentivized
    Read full review
    IBM
    • Certainly, not being a DB relational penalizes its use
    • It should be more flexible
    • Open up to more recent languages
    Incentivized
    Read full review
    Alternatives Considered
    Open Source
    While both can run as an in-memory database, H2 Database Engine was just so much easier for us to use since we primarily use the Java stack and H2 Database Engine is also built with Java.
    Incentivized
    Read full review
    IBM
    Essentially, for a question of reliability and scalability, the performance has always been of an enterprise level. The utilities are efficient and effective.
    Incentivized
    Read full review
    Return on Investment
    Open Source
    • Doesn't take time from developers, once it's configs are set up for testing it works in everyone's development environments
    • Easy to integrate in application, no need to setup separate database software, no maintenance
    • No need to deal with infrastructure related issues/costs - database runs in same machine as the application that uses it.
    Incentivized
    Read full review
    IBM
    • The investment made about 20 years ago that has been fully repaid
    • Reliability and security of investments
    • Unfortunately, it is quite outdated and therefore maintenance costs are higher because the skills are not always available.
    Incentivized
    Read full review
    ScreenShots