Modelirovanie i Analiz Informatsionnykh Sistem
RUS  ENG    JOURNALS   PEOPLE   ORGANISATIONS   CONFERENCES   SEMINARS   VIDEO LIBRARY   PACKAGE AMSBIB  
General information
Latest issue
Archive
Impact factor

Search papers
Search references

RSS
Latest issue
Current issues
Archive issues
What is RSS



Model. Anal. Inform. Sist.:
Year:
Volume:
Issue:
Page:
Find






Personal entry:
Login:
Password:
Save password
Enter
Forgotten password?
Register


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
Full-text PDF (455 kB) Citations (2)
References:
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
Bibliographic databases:
Document Type: Article
UDC: 519.987
Language: English
Citation: S. V. Mosin, S. V. Zykin, “Truth space method for caching database queries”, Model. Anal. Inform. Sist., 22:2 (2015), 248–258
Citation in format AMSBIB
\Bibitem{MosZyk15}
\by S.~V.~Mosin, S.~V.~Zykin
\paper Truth space method for caching database queries
\jour Model. Anal. Inform. Sist.
\yr 2015
\vol 22
\issue 2
\pages 248--258
\mathnet{http://mi.mathnet.ru/mais439}
\mathscinet{http://mathscinet.ams.org/mathscinet-getitem?mr=3417825}
\elib{https://elibrary.ru/item.asp?id=23405833}
Linking options:
  • https://www.mathnet.ru/eng/mais439
  • https://www.mathnet.ru/eng/mais/v22/i2/p248
  • This publication is cited in the following 2 articles:
    Citing articles in Google Scholar: Russian citations, English citations
    Related articles in Google Scholar: Russian articles, English articles
    Моделирование и анализ информационных систем
    Statistics & downloads:
    Abstract page:10414
    Full-text PDF :215
    References:64
     
      Contact us:
     Terms of Use  Registration to the website  Logotypes © Steklov Mathematical Institute RAS, 2024