In a previous post, I discussed materialized views in Oracle. I wanted to share a relatively simple technique that can be used to create similar functionality in Oracle or another database.
Why Use Something Else?
Materialized Views are a feature available in Oracle. If you’re not using Oracle, then that’s reason enough on its own. Materialized Views [...]

So the existence of Materialized Views might not be news to the Oracle DBAs around the world, but I present topics from the perspective of a software developer. As software developers we often have to use databases with our applications. As a user of a database, I think it is very important that software developers [...]

I’ve recently been doing some performance testing and tuning on an application. It makes use of Hibernate for the data access and ORM and Spring to configure and wire together everything. As I was looking at all of the configuration and came upon the fact that we were using the ClassicQueryTranslatorFactory. The job of the [...]

The Hibernate ORM tool give you the ability to write SQL-esque queries using HQL to do custom joining, filtering, etc. to pull Objects from your database. The documentation gives you a lot of examples of the things you can do, but I haven’t seen any caveats or warnings.
Database Performance
As far as database performance goes there [...]