Are there any common strategies that I can use for such instances?

I'm not sure what you're asking exactly but your plan seems sound to me, assuming your tables are relatively simple. What you're doing reminds me of a new module which I've been meaning to investigate: CGI::Application::Plugin::BREAD. If you're looking for general CGI::App examples you might take a look at CGI::Application::Framework or Krang.

-sam