Any sort of Internet and database application efficiency depends on good query base. In order to improve processing performance the cache utilization play a vital role by acting as auxiliary unit and provide associate services to processor. Various existing techniques about cache optimal utilization for the past two to three decades discussed about only the indexing, architectural view, address mapping mechanism, few concentrated cache only on needy base, In general as information retrieval among user applications as sample pharmacy or hospital relevant data in timely need plays high importance. considering this aspect in order to find a way to improve efficiency among query processing in this paper a detailed survey and investigation was made about the cache utilization in query processing at various levels and come out with the resultant as how the semantic cache enhanced as CoopSc(cooperative semantic database architecture) and how it can be collaborated in a cooperative way intelligently in large scale applications over p2p, distributed and cloud environments in an optimal way. © 2016, International Journal of Pharmacy and Technology. All rights reserved.