The Implementation of Caching Database to Reduce Query’s Response Time
Performance is an imperative aspect of a web-based application. Response time is one of the most important performance parameters. Most of web-based applications are driven by database system. Reducing response time of its database system will improve the performance of a web-based application. Cach...
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
EDP Sciences
2016-01-01
|
| Series: | MATEC Web of Conferences |
| Subjects: | |
| Online Access: | http://dx.doi.org/10.1051/matecconf/20165803014 |
| _version_ | 1818943150963556352 |
|---|---|
| author | Sinaga Arnaldo Marulitua Sibarani Poppy |
| author_facet | Sinaga Arnaldo Marulitua Sibarani Poppy |
| author_sort | Sinaga Arnaldo Marulitua |
| collection | DOAJ |
| description | Performance is an imperative aspect of a web-based application. Response time is one of the most important performance parameters. Most of web-based applications are driven by database system. Reducing response time of its database system will improve the performance of a web-based application. Caching is one of techniques that can be implemented to reduce response time. The implementation of caching can be conducted in the application or database side. Caching is a technique to keep the executed query and hence the query will not be executed when called in the later execution. The result of an executed query will be stored in the cache therefore when that query is called, the database will retrieve the stored result without re-executing query. This mechanism will reduce the time to re-execute queries. However, this technique may be not suitable for all queries. This research is intended to investigate the effect of the implementation of caching into performance of a database. A series of experiments have been conducted by applying query cache. The response time of the application of query cache is compared with the response time of database without query. The results show that the implementation of query cache reduces response time significantly. However, this technique is more suitable for large database with many frequently asked queries. The number of clients accessing the database is found to be influencing the performance of caching. The more clients access the database, the more improvement is provided by query cache. |
| first_indexed | 2024-12-20T07:22:46Z |
| format | Article |
| id | doaj.art-c30fdd00d7614054baef93cbf434b9e1 |
| institution | Directory Open Access Journal |
| issn | 2261-236X |
| language | English |
| last_indexed | 2024-12-20T07:22:46Z |
| publishDate | 2016-01-01 |
| publisher | EDP Sciences |
| record_format | Article |
| series | MATEC Web of Conferences |
| spelling | doaj.art-c30fdd00d7614054baef93cbf434b9e12022-12-21T19:48:38ZengEDP SciencesMATEC Web of Conferences2261-236X2016-01-01580301410.1051/matecconf/20165803014matecconf_bisstech2016_03014The Implementation of Caching Database to Reduce Query’s Response TimeSinaga Arnaldo Marulitua0Sibarani Poppy1Informatics Department, Faculty of Electronics and Informatics Engineering, Institut Teknologi DelInformatics Department, Faculty of Electronics and Informatics Engineering, Institut Teknologi DelPerformance is an imperative aspect of a web-based application. Response time is one of the most important performance parameters. Most of web-based applications are driven by database system. Reducing response time of its database system will improve the performance of a web-based application. Caching is one of techniques that can be implemented to reduce response time. The implementation of caching can be conducted in the application or database side. Caching is a technique to keep the executed query and hence the query will not be executed when called in the later execution. The result of an executed query will be stored in the cache therefore when that query is called, the database will retrieve the stored result without re-executing query. This mechanism will reduce the time to re-execute queries. However, this technique may be not suitable for all queries. This research is intended to investigate the effect of the implementation of caching into performance of a database. A series of experiments have been conducted by applying query cache. The response time of the application of query cache is compared with the response time of database without query. The results show that the implementation of query cache reduces response time significantly. However, this technique is more suitable for large database with many frequently asked queries. The number of clients accessing the database is found to be influencing the performance of caching. The more clients access the database, the more improvement is provided by query cache.http://dx.doi.org/10.1051/matecconf/20165803014databasecachingqueryperformance |
| spellingShingle | Sinaga Arnaldo Marulitua Sibarani Poppy The Implementation of Caching Database to Reduce Query’s Response Time MATEC Web of Conferences database caching query performance |
| title | The Implementation of Caching Database to Reduce Query’s Response Time |
| title_full | The Implementation of Caching Database to Reduce Query’s Response Time |
| title_fullStr | The Implementation of Caching Database to Reduce Query’s Response Time |
| title_full_unstemmed | The Implementation of Caching Database to Reduce Query’s Response Time |
| title_short | The Implementation of Caching Database to Reduce Query’s Response Time |
| title_sort | implementation of caching database to reduce query s response time |
| topic | database caching query performance |
| url | http://dx.doi.org/10.1051/matecconf/20165803014 |
| work_keys_str_mv | AT sinagaarnaldomarulitua theimplementationofcachingdatabasetoreducequerysresponsetime AT sibaranipoppy theimplementationofcachingdatabasetoreducequerysresponsetime AT sinagaarnaldomarulitua implementationofcachingdatabasetoreducequerysresponsetime AT sibaranipoppy implementationofcachingdatabasetoreducequerysresponsetime |