IBM Informix vs Oracle Java DB comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
3,372 views|1,981 comparisons
Oracle Logo
1,133 views|957 comparisons
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: March 2024).
765,234 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
"It supports multiple applications and business intelligence tools.""The solution's stability, performance, enhanced functionality, and replication are all great features.""The stability is incredible. I have customers with uptimes of several years.""The initial setup is pretty easy.""Every version is faster than the previous.""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.""Replication is a valuable feature and easy to use.""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."

More IBM Informix Pros →

"There have been no issues in relation to stability. We've never really had do to any recoveries. It is very stable.""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.""It's very clever.""It has a programming language so anything that we require for Selenium is all available there.""The most valuable feature is automation.""Able to write queries more efficiently and the management of data has become better and easier.""The solution is stable."

More Oracle Java DB Pros →

Cons
"This product could be made easier to use for beginners.""The technical support services need substantial improvement.""There should be more intelligence surrounding discovering data to be able to automatically create indexes.""The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process.""The solution lacks some functionality.""I experienced poor input/output (IO) performance.""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."

More IBM Informix Cons →

"The biggest lesson that I have learned from using Oracle products is vendor lock-in.""It'll be better if Oracle Java supports open source technologies, like Node.js.""The solution could be more user-friendly.""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.""Needs improvement in consistency issues with respect to timeframes."

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.
    765,234 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,372
    Comparisons
    1,981
    Reviews
    5
    Average Words per Review
    394
    Rating
    7.0
    Views
    1,133
    Comparisons
    957
    Reviews
    1
    Average Words per Review
    405
    Rating
    6.0
    Comparisons
    Oracle Database logo
    Compared 38% of the time.
    SQL Server logo
    Compared 35% of the time.
    IBM Db2 Database logo
    Compared 10% of the time.
    MySQL logo
    Compared 9% of the time.
    MariaDB logo
    Compared 4% of the time.
    MySQL logo
    Compared 44% of the time.
    SQL Server logo
    Compared 14% of the time.
    Oracle Database logo
    Compared 11% of the time.
    Apache Derby logo
    Compared 11% of the time.
    SAP HANA 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%
    Retailer5%
    Financial Services Firm5%
    Computer Software Company5%
    VISITORS READING REVIEWS
    Financial Services Firm22%
    Computer Software Company11%
    Educational Organization11%
    Comms Service Provider8%
    Company Size
    REVIEWERS
    Small Business53%
    Midsize Enterprise12%
    Large Enterprise35%
    VISITORS READING REVIEWS
    Small Business9%
    Midsize Enterprise59%
    Large Enterprise31%
    REVIEWERS
    Small Business40%
    Midsize Enterprise10%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise13%
    Large Enterprise72%
    Buyer's Guide
    Relational Databases Tools
    March 2024
    Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: March 2024.
    765,234 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, SQL Server, Oracle Database, Apache Derby and SAP HANA.

    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.