Reviews (1-1 of 1)
July 13, 2016
Score 8 out of 10
TimesTen is being used as an in-memory relational database for a multi-threaded real-time application. This application reads, writes and updates the data in TimesTen. TimesTen is also being used by a front-end graphical user interface to allow users to view the data and create reports. One problem with TimesTen is slow performance for larger sized tables and slow initial loading of TimesTen database. Another problem that was discovered is that TimesTen is not as fast as caching data using STL maps.
- 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.
- 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.
Read Trung Pham's full review
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.
Oracle TimesTen Scorecard Summary
About Oracle TimesTen
Oracle TimesTen In-Memory Database (TimesTen) delivers real time application performance by changing the assumptions around where data resides at runtime. By managing data in memory, and optimizing data structures and access algorithms, database operations execute achieve gains in responsiveness and throughput. With TimesTen Scaleout, a shared nothing scale-out architecture based on the existing in-memory technology, TimesTen allows databases to scale across hosts, reach hundreds of terabytes in size and support hundreds of millions of transactions per second without the need for manual database sharding or workload partitioning.
Categories: Embedded Database
Oracle TimesTen Technical Details