Show simple item record

dc.contributor.authorGuisado Gámez, Joan
dc.contributor.authorWolski, Antoni
dc.contributor.authorZuzarte, Calisto
dc.contributor.authorLarriba Pey, Josep
dc.contributor.authorMuntés Mulero, Víctor
dc.contributor.otherUniversitat Politècnica de Catalunya. Departament d'Arquitectura de Computadors
dc.date.accessioned2010-10-05T18:38:51Z
dc.date.available2010-10-05T18:38:51Z
dc.date.created2010
dc.date.issued2010
dc.identifier.citationGuisado, J. [et al.]. Hybrid in-memory and on-disk tables for speeding-up table accesses. A: Database and Expert Systems Applications Conference. "21st International Conference". Bilbao: Springer, 2010, p. 231-240.
dc.identifier.isbn978-3-642-15363-1
dc.identifier.urihttp://hdl.handle.net/2117/9414
dc.description.abstractMain 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 unafordable 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. Our objective is twofold: first, to allow large tables that do not fit in the memory to partially benefit from in-memory management techniques and, second, to provide a way to discard unnecessary accesses to both memory and disk. Overall, 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 .
dc.format.extent10 p.
dc.language.isoeng
dc.publisherSpringer
dc.rightsAttribution-NonCommercial-NoDerivs 3.0 Spain
dc.rights.urihttp://creativecommons.org/licenses/by-nc-nd/3.0/es/
dc.subjectÀrees temàtiques de la UPC::Informàtica::Sistemes d'informació::Bases de dades
dc.subject.lcshDatabases management
dc.subject.otherHybrid tables
dc.subject.otherMain memory databases
dc.subject.otherDBMS performance
dc.titleHybrid in-memory and on-disk tables for speeding-up table accesses
dc.typeConference report
dc.subject.lemacBases de dades -- Gestió
dc.contributor.groupUniversitat Politècnica de Catalunya. DAMA-UPC - Data Management Group
dc.relation.publisherversionhttp://www.springerlink.com/content/b351k48359r43m6n/fulltext.pdf
dc.rights.accessOpen Access
drac.iddocument3130128
dc.description.versionPostprint (published version)
upcommons.citation.authorGuisado, J.; Wolski, A.; Zuzarte, C.; Larriba, J.; Muntés, V.
upcommons.citation.contributorDatabase and Expert Systems Applications Conference
upcommons.citation.pubplaceBilbao
upcommons.citation.publishedtrue
upcommons.citation.publicationName21st International Conference
upcommons.citation.startingPage231
upcommons.citation.endingPage240


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record

Except where otherwise noted, content on this work is licensed under a Creative Commons license: Attribution-NonCommercial-NoDerivs 3.0 Spain