A couple of days ago I did some performance tests between Oracle 10g (Express) and Oracle TimesTen. As with any commercial products, there is some licensing and costs involved. Obviously, our idea was then to look for a more cost efficient solution in order to get the same results. We specifically looked at H2, a Java SQL Database. This DBMS can operate in several different modes such as embedded, server and in-memory and has compatibility modes for certain commcercial database products like DB2, MySql, MS SQL Server, Oracle and some others. So, looking at the feature list, this seemed to be a good fit.

Just recently, I had been asked to compare the performance of Oracle 10g and Oracle TimesTen In-Memory database. We wanted to evaluate to what extent the performance of a mission critical system could be increased by using an in-memory database like Oracle TimesTen compared to a “regular” RDBMS like Oracle 10g.

I used a sample application generated from OLIVANOVA in order to compare these different scenarios. The application is based upon a three-tier architecture with a JSF client, J2EE business logic and a RDBMS. The JSF client as well as the business logic have been deployed on a JBoss application server.

I just recently did some evaluation on OLIVANOVA (original URL https://www.care-t.com) along with TimesTen In-Memory Database as the persistence layer. OLIVANOVA is a model driven software development environment that generates code for business software**.** Certified database management systems include all major relational database management systems such as Microsoft SQL Server, Oracle, DB2 and so on.

One of OLIVANOVA’s customers required instant responsiveness and very high throughput. So, this was a welcome opportunity for me to evaluate TimesTen, an In-Memory database. I created the model, generated the source code and specified the driver and connection string. In a few minutes I was able to test the application against TimesTen.