IDERA SQL Compliance Manager vs. Oracle Coherence

The payment card industry is best as it has built-in PCI DSS compliant and in a transactional DB where there are a lot of DML activities the size of the database must be increased.

Incentivized

Oracle Coherence can be used to solve latency problems by caching data near the application tier. In-memory performance helps to reduce data contention, thus improving application response time. Oracle Coherence does a great job at scaling linearly and can do so dynamically. Oracle Coherence can replicate data so it can be part of a disaster recovery solution. One thing that is often overlooked with elastic caches is their ability to analyze data in memory, leveraging the processing power of the data grid. This is something Oracle Coherence does exceptionally well. Oracle Coherence also provided event handling capabilities to allow applications to respond to events triggered by transactions.

Incentivized

• Audit Logins
• DML Activities
• DDL Activities
• Queries Reporting

Incentivized

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

Incentivized

• Should have a compression algorithm to compress the audited logs, as it will take a lot of space.
• Can not audit all the DML and DDL activities as it will take a lot of space, should have a compression algo.

Incentivized

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

Incentivized

Oracle Coherence support team is responsive and knowledgeable. We contacted them to ask a couple of design questions about how we were setting up Oracle Coherence based on how we used IBM's Datapower Extreme Scale. They were able to guide us so that we got the design correct the first time and didn't have to go back and re-architect our design later.

Incentivized

More easy to use, no SQL queries to extract data out of it, graphical user interface is very good and easy to use.

Incentivized

DataSynapse GridServer has the same cache functionality connected with a grid distributed application deployment platform. It provides all the necessary tools to configure and manage these applications. On the otherhand Oracle Coherence has more a flexible configuration and better performance. Also the Oracle configuration and monitoring tools are more convenient and informative than the DataSynapse ones.

Incentivized

• Audit reports are a hectic job for a DBA it made them easy.

Incentivized

• 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.

Incentivized