IBM Informix vs Oracle Java DB comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
3,205 views|1,866 comparisons
85% willing to recommend
Oracle Logo
1,028 views|873 comparisons
69% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Informix and Oracle Java DB based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools.
To learn more, read our detailed Relational Databases Tools Report (Updated: April 2024).
769,599 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution.""The stability is incredible. I have customers with uptimes of several years.""The solution's stability, performance, enhanced functionality, and replication are all great features.""The scalability is very good.""The most valuable feature is concurrency and locking because my customers usually use databases in OLTP mode. So, for a large number of competitive users. Other features that are well valued are quick large-scale data types. It is better than Oracle.""It supports in-house-built applications in .NET and VB6""The initial setup is pretty easy.""This solution has made financial reporting possible by allowing financial people the opportunity to set Informix to "Auto Pilot" so that they can attend other duties."

More IBM Informix Pros →

"It's very clever.""The additional value of having Java inside the Oracle database is all the security that is applied to an Oracle database will be enforced on Java's stored procedures as well.""The most valuable feature is automation.""The solution is stable.""Able to write queries more efficiently and the management of data has become better and easier.""There have been no issues in relation to stability. We've never really had do to any recoveries. It is very stable.""It has a programming language so anything that we require for Selenium is all available there."

More Oracle Java DB Pros →

Cons
"In my opinion, the packages could be improved. The version I use doesn't allow for packages. I can do some general procedures, but no packages like in Oracle. So, develop separate modules in SQL language. This would be most beneficial for me.""Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language.""The pricing is a bit expensive.""The solution really doesn't add new features very often.""I would like to see backups from secondary servers.""I experienced poor input/output (IO) performance.""This product could be made easier to use for beginners.""The technical support services need substantial improvement."

More IBM Informix Cons →

"In terms of improvement, I'd like an automation tool that is lower priced. The core prices are very high.""The solution should continue to keep updating and improving the Java language.""The solution could be more user-friendly.""Needs improvement in consistency issues with respect to timeframes.""It'll be better if Oracle Java supports open source technologies, like Node.js.""The biggest lesson that I have learned from using Oracle products is vendor lock-in."

More Oracle Java DB Cons →

Pricing and Cost Advice
  • "The free edition can be enough to handle moderate-size implementations, but you may want a pay for edition to benefit from more functionality, such as replication."
  • "I am not aware of the licensing costs or terms."
  • "For me, it's always too expensive."
  • "The product has reasonable pricing. We purchase its yearly license."
  • More IBM Informix Pricing and Cost Advice →

  • "The product's pricing is very friendly, with no extra costs after the licensing fees."
  • More Oracle Java DB Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
    769,599 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It supports multiple applications and business intelligence tools.
    Top Answer:The product has reasonable pricing. We purchase its yearly license.
    Top Answer:The key areas for improvement revolve around understanding the current customer trends and demands, particularly in software and database requirements. The product's performance could be better… more »
    Top Answer:The solution could be more user-friendly. It comes with baggage so it should be simple to use. The PLS QL and the queries are efficient, but there isn't a major difference between the normal Java and… more »
    Top Answer:Our primary use case for this solution is for applications within the bank that are minor applications and web applications developed in house.
    Ranking
    Views
    3,205
    Comparisons
    1,866
    Reviews
    5
    Average Words per Review
    394
    Rating
    7.0
    Views
    1,028
    Comparisons
    873
    Reviews
    1
    Average Words per Review
    405
    Rating
    6.0
    Comparisons
    Oracle Database logo
    Compared 39% of the time.
    SQL Server logo
    Compared 37% of the time.
    IBM Db2 Database logo
    Compared 10% of the time.
    MySQL logo
    Compared 7% of the time.
    MariaDB logo
    Compared 4% of the time.
    MySQL logo
    Compared 46% of the time.
    Oracle Database logo
    Compared 12% of the time.
    SQL Server logo
    Compared 12% of the time.
    SAP HANA logo
    Compared 10% of the time.
    Apache Derby logo
    Compared 10% of the time.
    Also Known As
    Informix
    Learn More
    IBM
    Video Not Available
    Overview

    IBM Informix is a widely used and scalable relational database management system designed to handle large amounts of data and high transaction volumes. It is known to provide exceptional performance, thanks to its Parallel Data Query Engine (PDQ) that enables parallel processing of queries and operations, significantly reducing response times for complex queries and large data sets. Additionally, Informix supports online operations like backup, restore, index maintenance, and table reorganization, minimizing downtime and ensuring continuous availability.

    Informix provides robust high availability and replication features, including shared-disk clustering, remote data replication, and high-availability data replication (HDR). These features ensure data redundancy, failover protection, and disaster recovery capabilities, making it a reliable choice for mission-critical applications. Furthermore, Informix offers specialized features for data warehousing and analytics, such as in-database analytics, data compression, and parallel load capabilities, making it suitable for business intelligence (BI) and data analysis applications.

    Informix can be deployed as an embedded database, allowing it to be tightly integrated with applications and systems, reducing overhead and simplifying deployment. It includes workload management capabilities, enabling organizations to prioritize and manage different types of workloads, such as online transaction processing (OLTP) and analytical queries, ensuring efficient resource utilization and meeting service-level agreements (SLAs). Informix also provides robust security features, including role-based access control, data encryption, auditing, and compliance with industry standards like FIPS 140-2 and Common Criteria.

    Java DB is a relational database management system (RDBMS). Data is stored and queried via SQL or JDBC. Like other RDBMSs, Java DB can also be accessed through a persistence layer such as JPA, Hibernate, or JDO. Java objects can be stored in the columns of Java DB tables.

    Sample Customers
    Shaspa, Hildebrand, Kaifa, Ranhill Powertron, Federaci‹ Farmacutica (FedeFarma), Camden Council, The German Aerospace Center (DLR), Myers, Votorantim Group, Doosan Infracore, GreenIvory
    Université Nice Sophia Antipolis
    Top Industries
    REVIEWERS
    Energy/Utilities Company22%
    Retailer11%
    Logistics Company11%
    Outsourcing Company11%
    VISITORS READING REVIEWS
    Educational Organization53%
    Financial Services Firm5%
    Retailer5%
    Computer Software Company5%
    VISITORS READING REVIEWS
    Financial Services Firm20%
    Computer Software Company11%
    Educational Organization11%
    Comms Service Provider8%
    Company Size
    REVIEWERS
    Small Business53%
    Midsize Enterprise12%
    Large Enterprise35%
    VISITORS READING REVIEWS
    Small Business9%
    Midsize Enterprise60%
    Large Enterprise31%
    REVIEWERS
    Small Business40%
    Midsize Enterprise10%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise14%
    Large Enterprise72%
    Buyer's Guide
    Relational Databases Tools
    April 2024
    Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: April 2024.
    769,599 professionals have used our research since 2012.

    IBM Informix is ranked 14th in Relational Databases Tools with 16 reviews while Oracle Java DB is ranked 23rd in Relational Databases Tools with 7 reviews. IBM Informix is rated 8.6, while Oracle Java DB is rated 8.2. The top reviewer of IBM Informix writes "Quite stable and flexible but not very innovative". On the other hand, the top reviewer of Oracle Java DB writes "Ability to handle large volumes and data sets but could be more user-friendly". IBM Informix is most compared with Oracle Database, SQL Server, IBM Db2 Database, MySQL and MariaDB, whereas Oracle Java DB is most compared with MySQL, Oracle Database, SQL Server, SAP HANA and Apache Derby.

    See our list of best Relational Databases Tools vendors.

    We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.