Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What should be the caching strategy if the Data is being changed by another program/system ?

 
aditee sharma
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Given a table in an Oracle 10g DB that is being updated/refreshed by ETL.
There is no defined frequency of update for a given key key.It could be seconds, minutes, days, weeks...even years or may be never.
For a IBATIS (for that matter it could be any other ORM) based java application that reads this table,what could be a good caching strategy such that Database hits are optimized and at the same time dirty reads are minimized ?
 
aditee sharma
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this question too vague? Or could it be that it missed attention because it was posted on a Friday evening?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic