Hibernate version: 3.1

I was wondering if anyone had a pattern for using Hibernate to implement an audit trail that looks like a Type 2 Slowly Changing Dimension.

It's been a while since I took the databases class, and I just learned this term... The basic idea is to keep a table that has a complete history for a given 'row' by logging events of type 'insert', 'update', and 'delete', along with all the values in your tuple. Generally then you would create a view on this 'history table' to give you the most recent values for each of the individual histories.

Splittling the table in two: the history table and the current view, as you might imagine is a problem for Hibernate out-of-the-box. I can think of one way to implement this with a custom persister, but I don't know that I want to tackle that right now.

Has anyone already done this? Is there some clever way of implementing it that I'm missing? Thanks in advance for any help.

Hello,

Sorry I don't have a more definative answer for you....about all I can do is point you to a thread asking similar questions:
http://forum.hibernate.org/viewtopic.php?t=954125&highlight=.

In it are a couple of links to wiki pages that talk about some aspects of creating historical views, but it's far from complete.

Within a couple of months this will become of prime importance to me as well. At that time, if I come up with anything innovative, I'll repost.

good luck in the meantime,

-don.