in reply to Re: A database caching scheme
in thread A database caching scheme

I would agree with terra. In fact, if you're using oracle, you can create session-level temporary tables that will expire when the session disconnects:
CREATE GLOBAL TEMPORARY TABLE foo ( bar VARCHAR2(16), baz DATE ) ON COMMIT PRESERVE ROWS
Unfortunatly, I don't know about other RDBMS's such as Postgres or MySQL. Hope that helps

--
Ben