InterSystems Caché vs. Oracle TimesTen

It's definitely great for medical industries that need the vast amounts of features/security/performance, however if you need something simple then this would be too much. There is a learning curve, and if you come from more common database technologies, then there will be a lot of differences to handle. Simple database needs would be better fulfilled elsewhere, but Cache is for when you need to take the next step, whether that be in the volume, complexity, or security of ETL.

Incentivized

TimesTen is well suited for applications using smaller data or smaller data stores and where transaction response times are not as business critical. TimesTen is good for applications already accessing Oracle and need to cache data for quick read/write operations. TimesTen is not appropriate for large data dependent applications or applications requiring fast response times. In these cases, using Oracle database or Exadata is better

Incentivized

• Performance
• Robustness
• Reliable

Incentivized

• With basic database experience, TimesTen has a very short learning curve.
• The installation and setup is easy and straightforward. The command line instructions are easy to follow.
• The error logging mechanism is simple and efficient. The system log files are helpful in troubleshooting problems with using TimesTen.
• The maintenance tools are user friendly and effective. Upgrading is easy and quick. TimesTen is almost a self-administrating database.

Incentivized

• The IDE IntelliSense needs to be improved.

Incentivized

• Provide better monitoring tools of TimesTen daemon, servers and connections.
• Improved support for APIs. The libraries lack the necessary code for applications to customize for applications using TimesTen.

Incentivized

I've only worked with products that do one thing before, but there's so much that Cache offers versus piecing different services together manually. Not only does the product offer a more robust tool-set, but the support is wonderful and I've never encountered a better vendor in any industry in terms of how well they interact with their customers and care about helping you solve your problems. They want you to grow and to get better.

Incentivized

Sybase does not have an in-memory database until version 15 so TimesTen was ideal for caching data. TimesTen has reliable replication and backing up mechanisms. Oracle takes longer to set up and use for most applications where as TimesTen is a smaller DBMS that is quick and easy to set up and use. TimesTen can connect to Oracle for caching data so using Oracle as a backend makes sense

Incentivized

• Implementation time could be speeded up
• It is very flexible and attractive

Incentivized

• TimesTen has had a positive impact from a developer's perspective because implementing TimesTen is quick and easy. The benefits of TimesTen can be seen almost instantly. For instance, the application start up time is faster, the data is easy to maintain and the performance is fast for TimesTen clients.
• TimesTen has had a positive impact for the business because it can be made accessible to users via a GUI. This gives users transparency to the data at any time.
• The negative impact is that once the TimesTen database has grown too large, the application should move to using Oracle database or else it suffers from performance degradation and stability issues.

Incentivized