title: Database history for client usage
body: <p>I'm trying to figure out what would be the best way to have a history on a database, to track any Insert/Delete/Update that is done.  The history data will need to be coded into the front-end since it will be used by the users.  Creating "history tables" (a copy of each table used to store history) is not a good way to do this, since the data is spread across multiple tables.  </p>
  
  <p>At this point in time, my best idea is to create a few History tables, which the tables would reflect the output I want to show to the users.  Whenever a change is made to specific tables, I would update this history table with the data as well.</p>
  
  <p>I'm trying to figure out what the best way to go about would be.  Any suggestions will be appreciated.</p>
  
  <p>I am using Oracle + VB.NET</p>