As an increasing number of applications are being deployed on the Web, many web contents are being generated from the database to manage a large amount data efficiently, but database server is easy to be overloaded because of low scalability. To solve such a database server bottleneck, database cache that increases the scalability of the database server is suggested. To improve scalability efficiently, a database cache must be high performance and cost-effective. In this thesis, an efficient query-results management system is proposed for an efficient database cache. First, this query-results management system supports high performance by replacing costly query processing with pointing data. Second, this system uses limited storage space efficiently by removing redundancy among caching objects and supporting an efficient cache replacement. To evaluate our system, we designed an implemented a prototype system. We also ran experiments and measured processing time per a query and hit ratio based on synthetically generated query traces. Our system shows approximately 50% performance enhancement and 100% storage space efficiency enhancement.
