DocumentCode :
718669
Title :
Using logical formulas for caching uniform RDB queries
Author :
Mosin, S.V. ; Zykin, S.V.
Author_Institution :
Inf. Process. & Representation Lab., Sobolev Inst. of Math., Omsk, Russia
fYear :
2015
fDate :
21-23 May 2015
Firstpage :
1
Lastpage :
5
Abstract :
We propose a new method of client-side data caching for relational databases with a central server and distant clients. Data is loaded into client cache based on queries executed on the central database at the server. These queries have a special form - “universal relational query”. The majority of search queries to database can be expressed in such form. Besides, this form allows us to analyze query correctness by checking lossless join property. A subsequent query may be executed in 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 new user´s query and results of the queries execution in cache. This method may be used to define lacking data in cache and execute the query on server for this data only. Problem of data actualizations in cache is not discussed in this paper. However, it can be solved by cataloging of queries on server and their serving by triggers in background mode.
Keywords :
cataloguing; query processing; relational databases; central database; central server; client-side data caching; data actualizations; distant clients; logical formulas; logical restrictions; lossless join property; query cataloging; query correctness analysis; relational databases; uniform RDB query caching; universal relational query; Aerospace electronics; Buildings; Physics; Relational databases; Servers; Uniform resource locators; Caching; Relational databases; Truth space;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Control and Communications (SIBCON), 2015 International Siberian Conference on
Conference_Location :
Omsk
Print_ISBN :
978-1-4799-7102-2
Type :
conf
DOI :
10.1109/SIBCON.2015.7147151
Filename :
7147151
Link To Document :
بازگشت