GSoC Proposal - Caching query results in pgpool-II

Hello<br /><br /> I am sending my proposal about Google Summer Of Code2011. <br />It would be nice if you could give me
youropinion.<br /><br />・title<br /><br />Caching query results in pgpool-II<br /><br /><br />・Synopsis<br /><br
/>Pgpool-IIhas query caching functionality using storage provided by<br /> dedicated PostgreSQL ("system database").
Thishas several drawbacks<br />however. 1)it is slow because it needs to access disk storage 2)it<br />does not
invalidatethe cache automatically.<br /><br />This proposal tries to solve these problems.<br /><br />- To speed up the
cacheaccess, it will be placed on memory, rather<br />  than database. The memory will be put on shared memory or
external<br/>  memory services such as memcached so that the cache can be shared by<br />   multiple sessions. Old
cacheentries will be deleted by LRU manner.<br /><br />- The cache will be invalidated automatically upon the timing
whenthe<br />  relevant tables are updated. Note that this is not always possible<br />   because the query result
mightcome from multiple tables, views or<br />  even functions. In this case the cache will be invalidated by<br /> 
timeout(orthey are not cached at all).<br /><br />- Fine tuning knobs need to be invented to control the cache
behavior<br/>   though they are not clear at this moment.<br /><br /><br />・Benefits to the PostgreSQL Community:<br
/><br/><br />Query caching will effectively enhance the performance of PostgreSQL<br />and this project will contribute
toincrease the number of users of<br /> PostgreSQL, who need more high performance database systems.<br /><br />Note
thatimplementing query cache in pgpool-II will bring merits not<br />only to the latest version of PostgreSQL but to
theprevious releases<br />of PostgreSQL.<br /><br /><br />・Project Schedule<br /><br />-April<br /> preparation <br
/><br/>-May 1 - May 22 <br /> write a specification<br /><br />-May 23 - June 19<br /> coding<br /><br />-June 20 -
July22<br /> test<br /><br />-July 23 - August 12<br /> Complete of coding and test, commit<br /><br /><br />・Personal
Dataand Biographical Information<br /><br /> Name : Masanori Yamazaki<br /> Born : 23.1.1981<br /> School :Currently I
learncontemporary philosophy, culture and literature at Waseda University in Japan.<br /> Coding :<br />  1.About five
yearsjob as web application programer(PHP, Java).<br /> 2.I experienced projects used framework such as Symfony, Zend
Framework,CakePHP, and Struts.<br /> 3.I am interested in OSS and like coding.<br /><br /><br />Regards<br /><br /><br
/>