|
Modelirovanie i Analiz Informatsionnykh Sistem, 2015, Volume 22, Number 2, Pages 248–258
(Mi mais439)
|
|
|
|
This article is cited in 2 scientific papers (total in 2 papers)
Truth space method for caching database queries
S. V. Mosin, S. V. Zykin Sobolev Institute of Mathematics of the Siberian Branch of the Russian Academy of Sciences, Pevtsova str., 13, Omsk, 644043, Russia
Abstract:
We propose a new method of client-side data caching for relational databases
with a central server and distant clients. Data are loaded into the client cache
based on queries executed on the server. Every query has the corresponding DB table — the result of the query execution. These
queries have a special form called “universal relational query” based on three fundamental Relational Algebra operations: \linebreak selection, projection and natural join. We have to mention that such a form is the closest one to the natural language and the majority of database
search queries can be expressed in this way. Besides, this form
allows us to analyze query correctness by checking lossless join property. A
subsequent query may be executed in a client's local cache if we can determine
that the query result is entirely contained in the cache. For this we compare
truth spaces of the logical restrictions in a new user's query and the results of
the queries execution in the cache. Such a comparison can be performed analytically , without need in additional Database queries. This method may be used to define lacking data
in the cache and execute the query on the server only for these data. To do this the analytical approach is also used, what distinguishes our paper from the existing technologies. We propose four theorems for testing the required conditions. The first and the third theorems conditions allow us to define the existence of required data in cache. The second and the fourth theorems state conditions to execute queries with cache only. The problem of cache data
actualizations is not discussed in this paper. However, it can be
solved by cataloging queries on the server and their serving by triggers in
background mode.
The article is published in the author's wording.
Keywords:
relational databases, caching, truth space.
Received: 01.03.2015
Citation:
S. V. Mosin, S. V. Zykin, “Truth space method for caching database queries”, Model. Anal. Inform. Sist., 22:2 (2015), 248–258
Linking options:
https://www.mathnet.ru/eng/mais439 https://www.mathnet.ru/eng/mais/v22/i2/p248
|
Statistics & downloads: |
Abstract page: | 10414 | Full-text PDF : | 215 | References: | 64 |
|