In the era of information explosion, the traditional approach to storing data have faced challenges due to the rapid growth of information. It becomes an important issue when we come to processing the large dataset and trying to retrieve the useful information from a big database. This paper presents an effective scheme which employs hybrid cache architecture on the existing database system to enhance the query performance without increasing the hardware cost. Our scheme can be applied to satisfy the traditional database query over the Internet. The experimental results collected from a practical application show that the data query can be speeded up to 26 times. Performance evaluation shows that the response time of queries is less than 0.02 seconds when the query hits the shared memory cache. The proposed architecture can be easily applied to the traditional SQL database to accelerate the database query without significant programing efforts.
['Yun-Te Lin', 'Y. K. Hsiao', 'Fang-Pang Lin', 'Chung-Ming Wang']
A hybrid cache architecture of shared memory and meta-table used in big multimedia query