Dbms

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

OLIVANOVA can generate code for application information logs automatically: for .NET environments OLIVANOVA uses the System.Diagnostics.Trace class included in the .NET Framework for J2EE platforms OLIVANOVA uses log4j

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

I currently ran into an interesting issue when installing MS SQL Server 2008. During the initial checks at startup of the installation process I got the following error: “Restart required”. So I restarted my computer but without success. I got exactly the same error message again. I found out that this happens due to a wrong registry entry. In order to get the prerequisite-checks to succeed I had to delete the value of the following registry entry: ...