After looking at the modules suggested by simonm I would recommend using DBIx::HA - it appears to map quite well to your requirements.

Michael