Database Change Auditing - Part of or Abstracted from ORM / Application Layer?
Posted
by
BrandonV
on Programmers
See other posts from Programmers
or by BrandonV
Published on 2012-10-03T15:19:27Z
Indexed on
2012/10/03
15:50 UTC
Read the original article
Hit count: 274
My fellow developers and I are at a crossroads in how to go about continuing our auditing of database changes.
Most of our applications log changes via INSERT
, UPDATE
, and DELETE
triggers.
A few of our newer applications audit at the ORM layer; specifically using Hibernate Envers.
While ORM layer auditing provides a much cleaner interface and is much more maintainable, it will not capture any manual database changes that are made. ORM layer auditing also means that our libraries will currently require a dependency on our ORM implementation unless, specifically in our case for example, JPA plans on providing something in the near future.
Is there a common paradigm that addresses this?
© Programmers or respective owner