Znovu použitelnost výsledků vyhledávání v rozsáhlých databázích

Abstract

The subject of this master thesis is to explore possible solutions of reusability of search results in a large database, especially by using cache in computer memory. Firstly, the database systems MySQL, MongoDB and Elasticsearch that will be used in this thesis were described. Then the principle of cache was briefly explained and the basic mechanisms, such as cache admission, data eviction and the data invalidation problem, were described. Next, various technologies for caching were introduced. In the practical part, testing of three database systems was documented, executing either unique or repeating queries on each of these systems. It was measured how the execution time changes with or without the use of cache. The outcome of this testing was the result summary and recommendation of which database system is best for which case, as well as the evaluation of the benefits of caching the database query results and if it is worth it to implement this mechanism.