Database Cache Management System |
Author(s): |
| Heena V. Chainani , Prof. Ram Meghe Institute of Technology And Research; Samruddhi S. Kale, Prof. Ram Meghe Institute of Technology And Research; Renuka R. Sarad, Prof. Ram Meghe Institute of Technology And Research; Roshan R. Karwa, Prof. Ram Meghe Institute of Technology And Research |
Keywords: |
| Cache Management, Buffer Pool, SQL Cache Dependency, Page Output Cache |
Abstract |
|
The users of web applications are increasing day by day. As the request increases the database trips also increases. As a result, the time required to fetch data from database increases, which in turn reduces the performance of web application. Under commercial available operating systems data can only be manipulated in the main memory storage. Therefore part of the database has to be loaded into a main storage area before modification and has to be written back to the disk after modification. This main memory storage technically referred as cache memory is used to store frequently asked data for faster retrieval by minimizing the time for retrieval queries. We have to apply various mechanisms policies so the user will get maximum cache hit. Our system in collaboration with airlines reservation application makes use of SQL Cache Dependency and Page Output Cache to deliver optimal and faster results. |
Other Details |
|
Paper ID: IJSRDV6I21450 Published in: Volume : 6, Issue : 2 Publication Date: 01/05/2018 Page(s): 2334-2336 |
Article Preview |
|
|
|
|
