Title
Hybrid in-memory and on-disk tables for speeding-up table accesses
Abstract
Main memory database management systems have become essential for response-time-bounded applications, such as those in telecommunications systems or Internet, where users frequently access a table in order to get information or check whether an element exists, and require the response to be as fast as possible. Continuous data growth is making it unaffordable to keep entire relations in memory and some commercial applications provide two different engines to handle data in-memory and on-disk separately. However, these systems assign each table to one of these engines, forcing large relations to be kept on secondary storage. In this paper we present TwinS -- a hybrid database management system that allows managing hybrid tables, i.e. tables partially managed by both engines. We show that we can reduce response time when accessing a large table in the database. All our experiments have been run on a dual-engine DBMS: IBM®SolidDB®.
Year
DOI
Venue
2010
10.1007/978-3-642-15364-8_17
DEXA
Field
DocType
ISBN
Data mining,Computer science,Response time,Foreign key,Physical data model,Database index,Database,The Internet,Auxiliary memory
Conference
3-642-15363-1
Citations 
PageRank 
References 
1
0.44
8
Authors
5
Name
Order
Citations
PageRank
Joan Guisado-Gámez1163.11
Antoni Wolski27547.30
Calisto Zuzarte326031.97
Josep-Lluís Larriba-Pey4132.41
Victor Muntés-Mulero520422.79