TrustRadius: an HG Insights company

Oracle Coherence

Score7.9 out of 10

21 Reviews and Ratings

What is Oracle Coherence?

Oracle Coherence is database management and development software.

Categories & Use Cases

Top Performing Features

  • Database security

    Security maintenance such as authorization management, log analysis, database auditing

    Category average: 8.2

  • Performance optimization tools

    Performance optimization tools measure and maintain overall responsiveness and efficiency of queries, database structures, etc.

    Category average: 8.1

  • Version control tools

    Version control tools ensure code integrity is maintained in a team coding environment

    Category average: 7.9

Areas for Improvement

  • User management

    Tools to help manage user and role administration

    Category average: 8.4

  • Change management

    Automated scripts for implementing database changes

    Category average: 7.8

  • Database status reporting

    Detailed reports on database performance, configuration, security, vulnerabilities, etc.

    Category average: 8.2

Oracle's Coherence Cache brings in-memory performance to applications.

Pros

  • scale out
  • caching

Cons

  • Better documentation on setting up various use cases.

Return on Investment

  • Improved performance of our customer facing transactions.
  • It allowed us to integrate with other applications across the enterprise for the consumption of our data.

Alternatives Considered

IBM DataPower Gateway, Redis and Amazon ElastiCache

Other Software Used

MongoDB Atlas, Microsoft SQL Server, Atlassian Jira Align (formerly AgileCraft)

Exploring Oracle Coherence for use on Microsoft Azure

Pros

  • Performance. Superfast resolution of complex data grid queries.
  • Reliability. Availability domain support for disaster recovery.
  • Programming model. Frictionless API for use with Java 8.

Cons

  • Integration with Prometheus and other cloud native technologies
  • Persistence. Ease of migration from one persistent store to another.
  • Compatibility with latest Java Versions. Support for 13 would be nice.

Return on Investment

  • Support for Coherence will allow us to claim a more broad and complete offering of Oracle technologies on Azure.
  • Support for Coherence will enable us to reach into accounts that have zero Azure and offer them some Azure.

Alternatives Considered

Redis

Other Software Used

Oracle WebLogic Application Server, IBM WebSphere Application Server on Cloud, Azure Cosmos DB

Coherence cache is awsomely performant

Pros

  • Fast in-memory cache.
  • Load balancing in clustered configuration.
  • Flexibly configurable.
  • Easily interacts with database.

Cons

  • Configuration difficulties (because of flexibility I suppose).
  • Weak logging (hard to trace and resolve problems).

Return on Investment

  • Better performance allows us to onboard more clients
  • Decom few mainframes that were needed to handle lots of DB queries
  • Better customer service with intraday calculations ability.

Other Software Used

Oracle Database, SAP Sybase IQ, JReport

Oracle Coherence Review!

Pros

  • I think it is pretty robust. Doesn't break.
  • A very sophisticated failover logic. Data rarely gets lost.
  • Highly configurable depending on how frequently and quickly data needs to be retrieved.

Cons

  • I can't really come up with too many flaws, but possibly a bit expensive considering there are good open source caches like Ehcache.

Return on Investment

  • It does serve its purpose well: being a robust cache solution that provides faster data access to our applications.
  • Regarding ROI, it all depends on a trade-off between cost, performance, robustness and support. Each team/company has to decide.

Alternatives Considered

Ehcache

Coherence in-memory data grid

Pros

  • Distributed in memory data managment. Your data is near your data manipulator or calculator engine.
  • Write behind, read through, write through concept.
  • Fault tolerance and scalable.
  • Continueous query, live events, map reduced aggregiation, extend client are few of the very good features I have used.

Cons

  • Real time monitoring - Java console using JMX manageable node is not quite friendly.
  • Security is not by default, we need to implement it.
  • Real time troubleshoot needs to improve.

Return on Investment

  • In my current project, it is yet to be decided as we are on the way to make it live for users. But I am sure it will be an added value to obtain timely calculations.