Serveur d'exploration Cyberinfrastructure

Attention, ce site est en cours de développement !
Attention, site généré par des moyens informatiques à partir de corpus bruts.
Les informations ne sont donc pas validées.

Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses

Identifieur interne : 000573 ( Istex/Corpus ); précédent : 000572; suivant : 000574

Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses

Auteurs : Joan Guisado-Gámez ; Antoni Wolski ; Calisto Zuzarte ; Josep-Lluís Larriba-Pey ; Victor Muntés-Mulero

Source :

RBID : ISTEX:DA869BC2E851E59C35E094D8F4B0415BF707D364

Abstract

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®.

Url:
DOI: 10.1007/978-3-642-15364-8_17

Links to Exploration step

ISTEX:DA869BC2E851E59C35E094D8F4B0415BF707D364

Le document en format XML

<record>
<TEI wicri:istexFullTextTei="biblStruct">
<teiHeader>
<fileDesc>
<titleStmt>
<title xml:lang="en">Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses</title>
<author>
<name sortKey="Guisado Gamez, Joan" sort="Guisado Gamez, Joan" uniqKey="Guisado Gamez J" first="Joan" last="Guisado-Gámez">Joan Guisado-Gámez</name>
<affiliation>
<mods:affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</mods:affiliation>
</affiliation>
<affiliation>
<mods:affiliation>E-mail: joan@ac.upc.edu</mods:affiliation>
</affiliation>
</author>
<author>
<name sortKey="Wolski, Antoni" sort="Wolski, Antoni" uniqKey="Wolski A" first="Antoni" last="Wolski">Antoni Wolski</name>
<affiliation>
<mods:affiliation>IBM Helsinki Laboratory, Finland</mods:affiliation>
</affiliation>
<affiliation>
<mods:affiliation>E-mail: antoni.wolski@fi.ibm.com</mods:affiliation>
</affiliation>
</author>
<author>
<name sortKey="Zuzarte, Calisto" sort="Zuzarte, Calisto" uniqKey="Zuzarte C" first="Calisto" last="Zuzarte">Calisto Zuzarte</name>
<affiliation>
<mods:affiliation>IBM Toronto Laboratory, L6G 1C7, Markham, Ontario, Canada</mods:affiliation>
</affiliation>
<affiliation>
<mods:affiliation>E-mail: calisto@ca.ibm.com</mods:affiliation>
</affiliation>
</author>
<author>
<name sortKey="Larriba Pey, Josep Lluis" sort="Larriba Pey, Josep Lluis" uniqKey="Larriba Pey J" first="Josep-Lluís" last="Larriba-Pey">Josep-Lluís Larriba-Pey</name>
<affiliation>
<mods:affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</mods:affiliation>
</affiliation>
<affiliation>
<mods:affiliation>E-mail: larri@ac.upc.edu</mods:affiliation>
</affiliation>
</author>
<author>
<name sortKey="Muntes Mulero, Victor" sort="Muntes Mulero, Victor" uniqKey="Muntes Mulero V" first="Victor" last="Muntés-Mulero">Victor Muntés-Mulero</name>
<affiliation>
<mods:affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</mods:affiliation>
</affiliation>
<affiliation>
<mods:affiliation>E-mail: vmuntes@ac.upc.edu</mods:affiliation>
</affiliation>
</author>
</titleStmt>
<publicationStmt>
<idno type="wicri:source">ISTEX</idno>
<idno type="RBID">ISTEX:DA869BC2E851E59C35E094D8F4B0415BF707D364</idno>
<date when="2010" year="2010">2010</date>
<idno type="doi">10.1007/978-3-642-15364-8_17</idno>
<idno type="url">https://api.istex.fr/document/DA869BC2E851E59C35E094D8F4B0415BF707D364/fulltext/pdf</idno>
<idno type="wicri:Area/Istex/Corpus">000573</idno>
</publicationStmt>
<sourceDesc>
<biblStruct>
<analytic>
<title level="a" type="main" xml:lang="en">Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses</title>
<author>
<name sortKey="Guisado Gamez, Joan" sort="Guisado Gamez, Joan" uniqKey="Guisado Gamez J" first="Joan" last="Guisado-Gámez">Joan Guisado-Gámez</name>
<affiliation>
<mods:affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</mods:affiliation>
</affiliation>
<affiliation>
<mods:affiliation>E-mail: joan@ac.upc.edu</mods:affiliation>
</affiliation>
</author>
<author>
<name sortKey="Wolski, Antoni" sort="Wolski, Antoni" uniqKey="Wolski A" first="Antoni" last="Wolski">Antoni Wolski</name>
<affiliation>
<mods:affiliation>IBM Helsinki Laboratory, Finland</mods:affiliation>
</affiliation>
<affiliation>
<mods:affiliation>E-mail: antoni.wolski@fi.ibm.com</mods:affiliation>
</affiliation>
</author>
<author>
<name sortKey="Zuzarte, Calisto" sort="Zuzarte, Calisto" uniqKey="Zuzarte C" first="Calisto" last="Zuzarte">Calisto Zuzarte</name>
<affiliation>
<mods:affiliation>IBM Toronto Laboratory, L6G 1C7, Markham, Ontario, Canada</mods:affiliation>
</affiliation>
<affiliation>
<mods:affiliation>E-mail: calisto@ca.ibm.com</mods:affiliation>
</affiliation>
</author>
<author>
<name sortKey="Larriba Pey, Josep Lluis" sort="Larriba Pey, Josep Lluis" uniqKey="Larriba Pey J" first="Josep-Lluís" last="Larriba-Pey">Josep-Lluís Larriba-Pey</name>
<affiliation>
<mods:affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</mods:affiliation>
</affiliation>
<affiliation>
<mods:affiliation>E-mail: larri@ac.upc.edu</mods:affiliation>
</affiliation>
</author>
<author>
<name sortKey="Muntes Mulero, Victor" sort="Muntes Mulero, Victor" uniqKey="Muntes Mulero V" first="Victor" last="Muntés-Mulero">Victor Muntés-Mulero</name>
<affiliation>
<mods:affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</mods:affiliation>
</affiliation>
<affiliation>
<mods:affiliation>E-mail: vmuntes@ac.upc.edu</mods:affiliation>
</affiliation>
</author>
</analytic>
<monogr></monogr>
<series>
<title level="s">Lecture Notes in Computer Science</title>
<imprint>
<date>2010</date>
</imprint>
<idno type="ISSN">0302-9743</idno>
<idno type="eISSN">1611-3349</idno>
<idno type="ISSN">0302-9743</idno>
</series>
<idno type="istex">DA869BC2E851E59C35E094D8F4B0415BF707D364</idno>
<idno type="DOI">10.1007/978-3-642-15364-8_17</idno>
<idno type="ChapterID">17</idno>
<idno type="ChapterID">Chap17</idno>
</biblStruct>
</sourceDesc>
<seriesStmt>
<idno type="ISSN">0302-9743</idno>
</seriesStmt>
</fileDesc>
<profileDesc>
<textClass></textClass>
<langUsage>
<language ident="en">en</language>
</langUsage>
</profileDesc>
</teiHeader>
<front>
<div type="abstract" xml:lang="en">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®.</div>
</front>
</TEI>
<istex>
<corpusName>springer</corpusName>
<author>
<json:item>
<name>Joan Guisado-Gámez</name>
<affiliations>
<json:string>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</json:string>
<json:string>E-mail: joan@ac.upc.edu</json:string>
</affiliations>
</json:item>
<json:item>
<name>Antoni Wolski</name>
<affiliations>
<json:string>IBM Helsinki Laboratory, Finland</json:string>
<json:string>E-mail: antoni.wolski@fi.ibm.com</json:string>
</affiliations>
</json:item>
<json:item>
<name>Calisto Zuzarte</name>
<affiliations>
<json:string>IBM Toronto Laboratory, L6G 1C7, Markham, Ontario, Canada</json:string>
<json:string>E-mail: calisto@ca.ibm.com</json:string>
</affiliations>
</json:item>
<json:item>
<name>Josep-Lluís Larriba-Pey</name>
<affiliations>
<json:string>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</json:string>
<json:string>E-mail: larri@ac.upc.edu</json:string>
</affiliations>
</json:item>
<json:item>
<name>Victor Muntés-Mulero</name>
<affiliations>
<json:string>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</json:string>
<json:string>E-mail: vmuntes@ac.upc.edu</json:string>
</affiliations>
</json:item>
</author>
<language>
<json:string>eng</json:string>
</language>
<originalGenre>
<json:string>OriginalPaper</json:string>
</originalGenre>
<abstract>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®.</abstract>
<qualityIndicators>
<score>7.385</score>
<pdfVersion>1.6</pdfVersion>
<pdfPageSize>430 x 660 pts</pdfPageSize>
<refBibsNative>false</refBibsNative>
<keywordCount>0</keywordCount>
<abstractCharCount>951</abstractCharCount>
<pdfWordCount>4133</pdfWordCount>
<pdfCharCount>22304</pdfCharCount>
<pdfPageCount>10</pdfPageCount>
<abstractWordCount>146</abstractWordCount>
</qualityIndicators>
<title>Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses</title>
<chapterId>
<json:string>17</json:string>
<json:string>Chap17</json:string>
</chapterId>
<genre>
<json:string>conference</json:string>
</genre>
<serie>
<editor>
<json:item>
<name>David Hutchison</name>
<affiliations>
<json:string>Lancaster University, Lancaster, UK</json:string>
</affiliations>
</json:item>
<json:item>
<name>Takeo Kanade</name>
<affiliations>
<json:string>Carnegie Mellon University, Pittsburgh, PA, USA</json:string>
</affiliations>
</json:item>
<json:item>
<name>Josef Kittler</name>
<affiliations>
<json:string>University of Surrey, Guildford, UK</json:string>
</affiliations>
</json:item>
<json:item>
<name>Jon M. Kleinberg</name>
<affiliations>
<json:string>Cornell University, Ithaca, NY, USA</json:string>
</affiliations>
</json:item>
<json:item>
<name>Friedemann Mattern</name>
<affiliations>
<json:string>ETH Zurich, Zurich, Switzerland</json:string>
</affiliations>
</json:item>
<json:item>
<name>John C. Mitchell</name>
<affiliations>
<json:string>Stanford University, Stanford, CA, USA</json:string>
</affiliations>
</json:item>
<json:item>
<name>Moni Naor</name>
<affiliations>
<json:string>Weizmann Institute of Science, Rehovot, Israel</json:string>
</affiliations>
</json:item>
<json:item>
<name>Oscar Nierstrasz</name>
<affiliations>
<json:string>University of Bern, Bern, Switzerland</json:string>
</affiliations>
</json:item>
<json:item>
<name>C. Pandu Rangan</name>
<affiliations>
<json:string>Indian Institute of Technology, Madras, India</json:string>
</affiliations>
</json:item>
<json:item>
<name>Bernhard Steffen</name>
<affiliations>
<json:string>University of Dortmund, Dortmund, Germany</json:string>
</affiliations>
</json:item>
<json:item>
<name>Madhu Sudan</name>
<affiliations>
<json:string>Massachusetts Institute of Technology, MA, USA</json:string>
</affiliations>
</json:item>
<json:item>
<name>Demetri Terzopoulos</name>
<affiliations>
<json:string>University of California, Los Angeles, CA, USA</json:string>
</affiliations>
</json:item>
<json:item>
<name>Doug Tygar</name>
<affiliations>
<json:string>University of California, Berkeley, CA, USA</json:string>
</affiliations>
</json:item>
<json:item>
<name>Moshe Y. Vardi</name>
<affiliations>
<json:string>Rice University, Houston, TX, USA</json:string>
</affiliations>
</json:item>
<json:item>
<name>Gerhard Weikum</name>
<affiliations>
<json:string>Max-Planck Institute of Computer Science, Saarbrücken, Germany</json:string>
</affiliations>
</json:item>
</editor>
<issn>
<json:string>0302-9743</json:string>
</issn>
<language>
<json:string>unknown</json:string>
</language>
<eissn>
<json:string>1611-3349</json:string>
</eissn>
<title>Lecture Notes in Computer Science</title>
<copyrightDate>2010</copyrightDate>
</serie>
<host>
<editor>
<json:item>
<name>Pablo García Bringas</name>
<affiliations>
<json:string>DeustoTech Computing, University of Deusto, Avda. Universidades, 24, 48007, Bilbao, Spain</json:string>
<json:string>E-mail: pablo.garcia.bringas@deusto.es</json:string>
</affiliations>
</json:item>
<json:item>
<name>Abdelkader Hameurlain</name>
<affiliations>
<json:string>Institut de Recherche en Informatique de Toulouse (IRIT), Paul Sabatier University, 118, route de Narbonne, 31062, Toulouse Cedex, France</json:string>
<json:string>E-mail: hameur@irit.fr</json:string>
</affiliations>
</json:item>
<json:item>
<name>Gerald Quirchmayr</name>
<affiliations>
<json:string>Faculty of Computer Science, Department of Distributed Systems and Multimedia Systems, University of Vienna, Liebiggasse 4/3-4, 1010, Vienna, Austria</json:string>
<json:string>E-mail: Gerald.Quirchmayr@univie.ac.at</json:string>
</affiliations>
</json:item>
</editor>
<subject>
<json:item>
<value>Computer Science</value>
</json:item>
<json:item>
<value>Computer Science</value>
</json:item>
<json:item>
<value>Information Systems Applications (incl.Internet)</value>
</json:item>
<json:item>
<value>Artificial Intelligence (incl. Robotics)</value>
</json:item>
<json:item>
<value>Computer Communication Networks</value>
</json:item>
<json:item>
<value>Information Storage and Retrieval</value>
</json:item>
<json:item>
<value>Database Management</value>
</json:item>
<json:item>
<value>Data Mining and Knowledge Discovery</value>
</json:item>
</subject>
<isbn>
<json:string>978-3-642-15363-1</json:string>
</isbn>
<language>
<json:string>unknown</json:string>
</language>
<eissn>
<json:string>1611-3349</json:string>
</eissn>
<title>Database and Expert Systems Applications</title>
<bookId>
<json:string>978-3-642-15364-8</json:string>
</bookId>
<volume>6261</volume>
<pages>
<last>240</last>
<first>231</first>
</pages>
<issn>
<json:string>0302-9743</json:string>
</issn>
<genre>
<json:string>book-series</json:string>
</genre>
<eisbn>
<json:string>978-3-642-15364-8</json:string>
</eisbn>
<copyrightDate>2010</copyrightDate>
<doi>
<json:string>10.1007/978-3-642-15364-8</json:string>
</doi>
</host>
<publicationDate>2010</publicationDate>
<copyrightDate>2010</copyrightDate>
<doi>
<json:string>10.1007/978-3-642-15364-8_17</json:string>
</doi>
<id>DA869BC2E851E59C35E094D8F4B0415BF707D364</id>
<score>0.122538015</score>
<fulltext>
<json:item>
<original>true</original>
<mimetype>application/pdf</mimetype>
<extension>pdf</extension>
<uri>https://api.istex.fr/document/DA869BC2E851E59C35E094D8F4B0415BF707D364/fulltext/pdf</uri>
</json:item>
<json:item>
<original>false</original>
<mimetype>application/zip</mimetype>
<extension>zip</extension>
<uri>https://api.istex.fr/document/DA869BC2E851E59C35E094D8F4B0415BF707D364/fulltext/zip</uri>
</json:item>
<istex:fulltextTEI uri="https://api.istex.fr/document/DA869BC2E851E59C35E094D8F4B0415BF707D364/fulltext/tei">
<teiHeader>
<fileDesc>
<titleStmt>
<title level="a" type="main" xml:lang="en">Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses</title>
<respStmt>
<resp>Références bibliographiques récupérées via GROBID</resp>
<name resp="ISTEX-API">ISTEX-API (INIST-CNRS)</name>
</respStmt>
</titleStmt>
<publicationStmt>
<authority>ISTEX</authority>
<publisher>Springer Berlin Heidelberg</publisher>
<pubPlace>Berlin, Heidelberg</pubPlace>
<availability>
<p>Springer-Verlag Berlin Heidelberg, 2010</p>
</availability>
<date>2010</date>
</publicationStmt>
<sourceDesc>
<biblStruct type="inbook">
<analytic>
<title level="a" type="main" xml:lang="en">Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses</title>
<author xml:id="author-1">
<persName>
<forename type="first">Joan</forename>
<surname>Guisado-Gámez</surname>
</persName>
<email>joan@ac.upc.edu</email>
<affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</affiliation>
</author>
<author xml:id="author-2">
<persName>
<forename type="first">Antoni</forename>
<surname>Wolski</surname>
</persName>
<email>antoni.wolski@fi.ibm.com</email>
<affiliation>IBM Helsinki Laboratory, Finland</affiliation>
</author>
<author xml:id="author-3">
<persName>
<forename type="first">Calisto</forename>
<surname>Zuzarte</surname>
</persName>
<email>calisto@ca.ibm.com</email>
<affiliation>IBM Toronto Laboratory, L6G 1C7, Markham, Ontario, Canada</affiliation>
</author>
<author xml:id="author-4">
<persName>
<forename type="first">Josep-Lluís</forename>
<surname>Larriba-Pey</surname>
</persName>
<email>larri@ac.upc.edu</email>
<affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</affiliation>
</author>
<author xml:id="author-5">
<persName>
<forename type="first">Victor</forename>
<surname>Muntés-Mulero</surname>
</persName>
<email>vmuntes@ac.upc.edu</email>
<affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</affiliation>
</author>
</analytic>
<monogr>
<title level="m">Database and Expert Systems Applications</title>
<title level="m" type="sub">21st International Conference, DEXA 2010, Bilbao, Spain, August 30 - September 3, 2010, Proceedings, Part I</title>
<idno type="pISBN">978-3-642-15363-1</idno>
<idno type="eISBN">978-3-642-15364-8</idno>
<idno type="pISSN">0302-9743</idno>
<idno type="eISSN">1611-3349</idno>
<idno type="DOI">10.1007/978-3-642-15364-8</idno>
<idno type="book-ID">978-3-642-15364-8</idno>
<idno type="book-title-ID">213114</idno>
<idno type="book-sequence-number">6261</idno>
<idno type="book-volume-number">6261</idno>
<idno type="book-chapter-count">44</idno>
<editor>
<persName>
<forename type="first">Pablo</forename>
<forename type="first">García</forename>
<surname>Bringas</surname>
</persName>
<email>pablo.garcia.bringas@deusto.es</email>
<affiliation>DeustoTech Computing, University of Deusto, Avda. Universidades, 24, 48007, Bilbao, Spain</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Abdelkader</forename>
<surname>Hameurlain</surname>
</persName>
<email>hameur@irit.fr</email>
<affiliation>Institut de Recherche en Informatique de Toulouse (IRIT), Paul Sabatier University, 118, route de Narbonne, 31062, Toulouse Cedex, France</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Gerald</forename>
<surname>Quirchmayr</surname>
</persName>
<email>Gerald.Quirchmayr@univie.ac.at</email>
<affiliation>Faculty of Computer Science, Department of Distributed Systems and Multimedia Systems, University of Vienna, Liebiggasse 4/3-4, 1010, Vienna, Austria</affiliation>
</editor>
<imprint>
<publisher>Springer Berlin Heidelberg</publisher>
<pubPlace>Berlin, Heidelberg</pubPlace>
<date type="published" when="2010"></date>
<biblScope unit="volume">6261</biblScope>
<biblScope unit="page" from="231">231</biblScope>
<biblScope unit="page" to="240">240</biblScope>
</imprint>
</monogr>
<series>
<title level="s">Lecture Notes in Computer Science</title>
<editor>
<persName>
<forename type="first">David</forename>
<surname>Hutchison</surname>
</persName>
<affiliation>Lancaster University, Lancaster, UK</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Takeo</forename>
<surname>Kanade</surname>
</persName>
<affiliation>Carnegie Mellon University, Pittsburgh, PA, USA</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Josef</forename>
<surname>Kittler</surname>
</persName>
<affiliation>University of Surrey, Guildford, UK</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Jon</forename>
<forename type="first">M.</forename>
<surname>Kleinberg</surname>
</persName>
<affiliation>Cornell University, Ithaca, NY, USA</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Friedemann</forename>
<surname>Mattern</surname>
</persName>
<affiliation>ETH Zurich, Zurich, Switzerland</affiliation>
</editor>
<editor>
<persName>
<forename type="first">John</forename>
<forename type="first">C.</forename>
<surname>Mitchell</surname>
</persName>
<affiliation>Stanford University, Stanford, CA, USA</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Moni</forename>
<surname>Naor</surname>
</persName>
<affiliation>Weizmann Institute of Science, Rehovot, Israel</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Oscar</forename>
<surname>Nierstrasz</surname>
</persName>
<affiliation>University of Bern, Bern, Switzerland</affiliation>
</editor>
<editor>
<persName>
<forename type="first">C.</forename>
<surname>Pandu Rangan</surname>
</persName>
<affiliation>Indian Institute of Technology, Madras, India</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Bernhard</forename>
<surname>Steffen</surname>
</persName>
<affiliation>University of Dortmund, Dortmund, Germany</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Madhu</forename>
<surname>Sudan</surname>
</persName>
<affiliation>Massachusetts Institute of Technology, MA, USA</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Demetri</forename>
<surname>Terzopoulos</surname>
</persName>
<affiliation>University of California, Los Angeles, CA, USA</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Doug</forename>
<surname>Tygar</surname>
</persName>
<affiliation>University of California, Berkeley, CA, USA</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Moshe</forename>
<forename type="first">Y.</forename>
<surname>Vardi</surname>
</persName>
<affiliation>Rice University, Houston, TX, USA</affiliation>
</editor>
<editor>
<persName>
<forename type="first">Gerhard</forename>
<surname>Weikum</surname>
</persName>
<affiliation>Max-Planck Institute of Computer Science, Saarbrücken, Germany</affiliation>
</editor>
<biblScope>
<date>2010</date>
</biblScope>
<idno type="pISSN">0302-9743</idno>
<idno type="eISSN">1611-3349</idno>
<idno type="series-Id">558</idno>
</series>
<idno type="istex">DA869BC2E851E59C35E094D8F4B0415BF707D364</idno>
<idno type="DOI">10.1007/978-3-642-15364-8_17</idno>
<idno type="ChapterID">17</idno>
<idno type="ChapterID">Chap17</idno>
</biblStruct>
</sourceDesc>
</fileDesc>
<profileDesc>
<creation>
<date>2010</date>
</creation>
<langUsage>
<language ident="en">en</language>
</langUsage>
<abstract xml:lang="en">
<p>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®.</p>
</abstract>
<textClass>
<keywords scheme="Book-Subject-Collection">
<list>
<label>SUCO11645</label>
<item>
<term>Computer Science</term>
</item>
</list>
</keywords>
</textClass>
<textClass>
<keywords scheme="Book-Subject-Group">
<list>
<label>I</label>
<label>I18040</label>
<label>I21017</label>
<label>I13022</label>
<label>I18032</label>
<label>I18024</label>
<label>I18030</label>
<item>
<term>Computer Science</term>
</item>
<item>
<term>Information Systems Applications (incl.Internet)</term>
</item>
<item>
<term>Artificial Intelligence (incl. Robotics)</term>
</item>
<item>
<term>Computer Communication Networks</term>
</item>
<item>
<term>Information Storage and Retrieval</term>
</item>
<item>
<term>Database Management</term>
</item>
<item>
<term>Data Mining and Knowledge Discovery</term>
</item>
</list>
</keywords>
</textClass>
</profileDesc>
<revisionDesc>
<change when="2010">Published</change>
<change xml:id="refBibs-istex" who="#ISTEX-API" when="2016-09-22">References added</change>
</revisionDesc>
</teiHeader>
</istex:fulltextTEI>
<json:item>
<original>false</original>
<mimetype>text/plain</mimetype>
<extension>txt</extension>
<uri>https://api.istex.fr/document/DA869BC2E851E59C35E094D8F4B0415BF707D364/fulltext/txt</uri>
</json:item>
</fulltext>
<metadata>
<istex:metadataXml wicri:clean="Springer, Publisher found" wicri:toSee="no header">
<istex:xmlDeclaration>version="1.0" encoding="UTF-8"</istex:xmlDeclaration>
<istex:docType PUBLIC="-//Springer-Verlag//DTD A++ V2.4//EN" URI="http://devel.springer.de/A++/V2.4/DTD/A++V2.4.dtd" name="istex:docType"></istex:docType>
<istex:document>
<Publisher>
<PublisherInfo>
<PublisherName>Springer Berlin Heidelberg</PublisherName>
<PublisherLocation>Berlin, Heidelberg</PublisherLocation>
</PublisherInfo>
<Series>
<SeriesInfo SeriesType="Series" TocLevels="0">
<SeriesID>558</SeriesID>
<SeriesPrintISSN>0302-9743</SeriesPrintISSN>
<SeriesElectronicISSN>1611-3349</SeriesElectronicISSN>
<SeriesTitle Language="En">Lecture Notes in Computer Science</SeriesTitle>
</SeriesInfo>
<SeriesHeader>
<EditorGroup>
<Editor AffiliationIDS="Aff1">
<EditorName DisplayOrder="Western">
<GivenName>David</GivenName>
<FamilyName>Hutchison</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff2">
<EditorName DisplayOrder="Western">
<GivenName>Takeo</GivenName>
<FamilyName>Kanade</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff3">
<EditorName DisplayOrder="Western">
<GivenName>Josef</GivenName>
<FamilyName>Kittler</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff4">
<EditorName DisplayOrder="Western">
<GivenName>Jon</GivenName>
<GivenName>M.</GivenName>
<FamilyName>Kleinberg</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff5">
<EditorName DisplayOrder="Western">
<GivenName>Friedemann</GivenName>
<FamilyName>Mattern</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff6">
<EditorName DisplayOrder="Western">
<GivenName>John</GivenName>
<GivenName>C.</GivenName>
<FamilyName>Mitchell</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff7">
<EditorName DisplayOrder="Western">
<GivenName>Moni</GivenName>
<FamilyName>Naor</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff8">
<EditorName DisplayOrder="Western">
<GivenName>Oscar</GivenName>
<FamilyName>Nierstrasz</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff9">
<EditorName DisplayOrder="Western">
<GivenName>C.</GivenName>
<FamilyName>Pandu Rangan</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff10">
<EditorName DisplayOrder="Western">
<GivenName>Bernhard</GivenName>
<FamilyName>Steffen</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff11">
<EditorName DisplayOrder="Western">
<GivenName>Madhu</GivenName>
<FamilyName>Sudan</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff12">
<EditorName DisplayOrder="Western">
<GivenName>Demetri</GivenName>
<FamilyName>Terzopoulos</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff13">
<EditorName DisplayOrder="Western">
<GivenName>Doug</GivenName>
<FamilyName>Tygar</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff14">
<EditorName DisplayOrder="Western">
<GivenName>Moshe</GivenName>
<GivenName>Y.</GivenName>
<FamilyName>Vardi</FamilyName>
</EditorName>
</Editor>
<Editor AffiliationIDS="Aff15">
<EditorName DisplayOrder="Western">
<GivenName>Gerhard</GivenName>
<FamilyName>Weikum</FamilyName>
</EditorName>
</Editor>
<Affiliation ID="Aff1">
<OrgName>Lancaster University</OrgName>
<OrgAddress>
<City>Lancaster</City>
<Country>UK</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff2">
<OrgName>Carnegie Mellon University</OrgName>
<OrgAddress>
<City>Pittsburgh</City>
<State>PA</State>
<Country>USA</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff3">
<OrgName>University of Surrey</OrgName>
<OrgAddress>
<City>Guildford</City>
<Country>UK</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff4">
<OrgName>Cornell University</OrgName>
<OrgAddress>
<City>Ithaca</City>
<State>NY</State>
<Country>USA</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff5">
<OrgName>ETH Zurich</OrgName>
<OrgAddress>
<City>Zurich</City>
<Country>Switzerland</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff6">
<OrgName>Stanford University</OrgName>
<OrgAddress>
<City>Stanford</City>
<State>CA</State>
<Country>USA</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff7">
<OrgName>Weizmann Institute of Science</OrgName>
<OrgAddress>
<City>Rehovot</City>
<Country>Israel</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff8">
<OrgName>University of Bern</OrgName>
<OrgAddress>
<City>Bern</City>
<Country>Switzerland</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff9">
<OrgName>Indian Institute of Technology</OrgName>
<OrgAddress>
<City>Madras</City>
<Country>India</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff10">
<OrgName>University of Dortmund</OrgName>
<OrgAddress>
<City>Dortmund</City>
<Country>Germany</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff11">
<OrgName>Massachusetts Institute of Technology</OrgName>
<OrgAddress>
<State>MA</State>
<Country>USA</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff12">
<OrgName>University of California</OrgName>
<OrgAddress>
<City>Los Angeles</City>
<State>CA</State>
<Country>USA</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff13">
<OrgName>University of California</OrgName>
<OrgAddress>
<City>Berkeley</City>
<State>CA</State>
<Country>USA</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff14">
<OrgName>Rice University</OrgName>
<OrgAddress>
<City>Houston</City>
<State>TX</State>
<Country>USA</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff15">
<OrgName>Max-Planck Institute of Computer Science</OrgName>
<OrgAddress>
<City>Saarbrücken</City>
<Country>Germany</Country>
</OrgAddress>
</Affiliation>
</EditorGroup>
</SeriesHeader>
<Book Language="En">
<BookInfo BookProductType="Proceedings" ContainsESM="No" Language="En" MediaType="eBook" NumberingDepth="2" NumberingStyle="ContentOnly" OutputMedium="All" TocLevels="0">
<BookID>978-3-642-15364-8</BookID>
<BookTitle>Database and Expert Systems Applications</BookTitle>
<BookSubTitle>21st International Conference, DEXA 2010, Bilbao, Spain, August 30 - September 3, 2010, Proceedings, Part I</BookSubTitle>
<BookVolumeNumber>6261</BookVolumeNumber>
<BookSequenceNumber>6261</BookSequenceNumber>
<BookDOI>10.1007/978-3-642-15364-8</BookDOI>
<BookTitleID>213114</BookTitleID>
<BookPrintISBN>978-3-642-15363-1</BookPrintISBN>
<BookElectronicISBN>978-3-642-15364-8</BookElectronicISBN>
<BookChapterCount>44</BookChapterCount>
<BookCopyright>
<CopyrightHolderName>Springer-Verlag Berlin Heidelberg</CopyrightHolderName>
<CopyrightYear>2010</CopyrightYear>
</BookCopyright>
<BookSubjectGroup>
<BookSubject Code="I" Type="Primary">Computer Science</BookSubject>
<BookSubject Code="I18040" Priority="1" Type="Secondary">Information Systems Applications (incl.Internet)</BookSubject>
<BookSubject Code="I21017" Priority="2" Type="Secondary">Artificial Intelligence (incl. Robotics)</BookSubject>
<BookSubject Code="I13022" Priority="3" Type="Secondary">Computer Communication Networks</BookSubject>
<BookSubject Code="I18032" Priority="4" Type="Secondary">Information Storage and Retrieval</BookSubject>
<BookSubject Code="I18024" Priority="5" Type="Secondary">Database Management</BookSubject>
<BookSubject Code="I18030" Priority="6" Type="Secondary">Data Mining and Knowledge Discovery</BookSubject>
<SubjectCollection Code="SUCO11645">Computer Science</SubjectCollection>
</BookSubjectGroup>
<BookContext>
<SeriesID>558</SeriesID>
</BookContext>
</BookInfo>
<BookHeader>
<EditorGroup>
<Editor AffiliationIDS="Aff16">
<EditorName DisplayOrder="Western">
<GivenName>Pablo</GivenName>
<GivenName>García</GivenName>
<FamilyName>Bringas</FamilyName>
</EditorName>
<Contact>
<Email>pablo.garcia.bringas@deusto.es</Email>
</Contact>
</Editor>
<Editor AffiliationIDS="Aff17">
<EditorName DisplayOrder="Western">
<GivenName>Abdelkader</GivenName>
<FamilyName>Hameurlain</FamilyName>
</EditorName>
<Contact>
<Email>hameur@irit.fr</Email>
</Contact>
</Editor>
<Editor AffiliationIDS="Aff18">
<EditorName DisplayOrder="Western">
<GivenName>Gerald</GivenName>
<FamilyName>Quirchmayr</FamilyName>
</EditorName>
<Contact>
<Email>Gerald.Quirchmayr@univie.ac.at</Email>
</Contact>
</Editor>
<Affiliation ID="Aff16">
<OrgDivision>DeustoTech Computing</OrgDivision>
<OrgName>University of Deusto</OrgName>
<OrgAddress>
<Street>Avda. Universidades, 24</Street>
<Postcode>48007</Postcode>
<City>Bilbao</City>
<Country>Spain</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff17">
<OrgDivision>Institut de Recherche en Informatique de Toulouse (IRIT)</OrgDivision>
<OrgName>Paul Sabatier University</OrgName>
<OrgAddress>
<Street>118, route de Narbonne</Street>
<Postcode>31062</Postcode>
<City>Toulouse Cedex</City>
<Country>France</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff18">
<OrgDivision>Faculty of Computer Science, Department of Distributed Systems and Multimedia Systems</OrgDivision>
<OrgName>University of Vienna</OrgName>
<OrgAddress>
<Street>Liebiggasse 4/3-4</Street>
<Postcode>1010</Postcode>
<City>Vienna</City>
<Country>Austria</Country>
</OrgAddress>
</Affiliation>
</EditorGroup>
</BookHeader>
<Part ID="Part5">
<PartInfo TocLevels="0">
<PartID>5</PartID>
<PartSequenceNumber>5</PartSequenceNumber>
<PartTitle>Decision Support Systems and Performance (Short Papers)</PartTitle>
<PartChapterCount>4</PartChapterCount>
<PartContext>
<SeriesID>558</SeriesID>
<BookTitle>Database and Expert Systems Applications</BookTitle>
</PartContext>
</PartInfo>
<Chapter ID="Chap17" Language="En">
<ChapterInfo ChapterType="OriginalPaper" ContainsESM="No" NumberingDepth="2" NumberingStyle="ContentOnly" TocLevels="0">
<ChapterID>17</ChapterID>
<ChapterDOI>10.1007/978-3-642-15364-8_17</ChapterDOI>
<ChapterSequenceNumber>17</ChapterSequenceNumber>
<ChapterTitle Language="En">Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses</ChapterTitle>
<ChapterFirstPage>231</ChapterFirstPage>
<ChapterLastPage>240</ChapterLastPage>
<ChapterCopyright>
<CopyrightHolderName>Springer-Verlag Berlin Heidelberg</CopyrightHolderName>
<CopyrightYear>2010</CopyrightYear>
</ChapterCopyright>
<ChapterGrants Type="Regular">
<MetadataGrant Grant="OpenAccess"></MetadataGrant>
<AbstractGrant Grant="OpenAccess"></AbstractGrant>
<BodyPDFGrant Grant="Restricted"></BodyPDFGrant>
<BodyHTMLGrant Grant="Restricted"></BodyHTMLGrant>
<BibliographyGrant Grant="Restricted"></BibliographyGrant>
<ESMGrant Grant="Restricted"></ESMGrant>
</ChapterGrants>
<ChapterContext>
<SeriesID>558</SeriesID>
<PartID>5</PartID>
<BookID>978-3-642-15364-8</BookID>
<BookTitle>Database and Expert Systems Applications</BookTitle>
</ChapterContext>
</ChapterInfo>
<ChapterHeader>
<AuthorGroup>
<Author AffiliationIDS="Aff19">
<AuthorName DisplayOrder="Western">
<GivenName>Joan</GivenName>
<FamilyName>Guisado-Gámez</FamilyName>
</AuthorName>
<Contact>
<Email>joan@ac.upc.edu</Email>
</Contact>
</Author>
<Author AffiliationIDS="Aff20">
<AuthorName DisplayOrder="Western">
<GivenName>Antoni</GivenName>
<FamilyName>Wolski</FamilyName>
</AuthorName>
<Contact>
<Email>antoni.wolski@fi.ibm.com</Email>
</Contact>
</Author>
<Author AffiliationIDS="Aff21">
<AuthorName DisplayOrder="Western">
<GivenName>Calisto</GivenName>
<FamilyName>Zuzarte</FamilyName>
</AuthorName>
<Contact>
<Email>calisto@ca.ibm.com</Email>
</Contact>
</Author>
<Author AffiliationIDS="Aff19">
<AuthorName DisplayOrder="Western">
<GivenName>Josep-Lluís</GivenName>
<FamilyName>Larriba-Pey</FamilyName>
</AuthorName>
<Contact>
<Email>larri@ac.upc.edu</Email>
</Contact>
</Author>
<Author AffiliationIDS="Aff19">
<AuthorName DisplayOrder="Western">
<GivenName>Victor</GivenName>
<FamilyName>Muntés-Mulero</FamilyName>
</AuthorName>
<Contact>
<Email>vmuntes@ac.upc.edu</Email>
</Contact>
</Author>
<Affiliation ID="Aff19">
<OrgDivision>DAMA-UPC, Departament d’Arquitectura de Computadors</OrgDivision>
<OrgName>Universitat Politècnica de Catalunya</OrgName>
<OrgAddress>
<Street>Campus Nord-UPC</Street>
<Postcode>08034</Postcode>
<City>Barcelona</City>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff20">
<OrgName>IBM Helsinki Laboratory</OrgName>
<OrgAddress>
<Country>Finland</Country>
</OrgAddress>
</Affiliation>
<Affiliation ID="Aff21">
<OrgName>IBM Toronto Laboratory</OrgName>
<OrgAddress>
<City>Markham</City>
<State>Ontario</State>
<Country>Canada</Country>
<Postcode>L6G 1C7</Postcode>
</OrgAddress>
</Affiliation>
</AuthorGroup>
<Abstract ID="Abs1" Language="En">
<Heading>Abstract</Heading>
<Para>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.</Para>
<Para>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
<Superscript>®</Superscript>
SolidDB
<Superscript>®</Superscript>
.</Para>
</Abstract>
<KeywordGroup Language="En">
<Heading>Keywords</Heading>
<Keyword>Hybrid tables</Keyword>
<Keyword>Main memory databases</Keyword>
<Keyword>DBMS performance</Keyword>
</KeywordGroup>
</ChapterHeader>
<NoBody></NoBody>
</Chapter>
</Part>
</Book>
</Series>
</Publisher>
</istex:document>
</istex:metadataXml>
<mods version="3.6">
<titleInfo lang="en">
<title>Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses</title>
</titleInfo>
<titleInfo type="alternative" contentType="CDATA" lang="en">
<title>Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses</title>
</titleInfo>
<name type="personal">
<namePart type="given">Joan</namePart>
<namePart type="family">Guisado-Gámez</namePart>
<affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</affiliation>
<affiliation>E-mail: joan@ac.upc.edu</affiliation>
<role>
<roleTerm type="text">author</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Antoni</namePart>
<namePart type="family">Wolski</namePart>
<affiliation>IBM Helsinki Laboratory, Finland</affiliation>
<affiliation>E-mail: antoni.wolski@fi.ibm.com</affiliation>
<role>
<roleTerm type="text">author</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Calisto</namePart>
<namePart type="family">Zuzarte</namePart>
<affiliation>IBM Toronto Laboratory, L6G 1C7, Markham, Ontario, Canada</affiliation>
<affiliation>E-mail: calisto@ca.ibm.com</affiliation>
<role>
<roleTerm type="text">author</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Josep-Lluís</namePart>
<namePart type="family">Larriba-Pey</namePart>
<affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</affiliation>
<affiliation>E-mail: larri@ac.upc.edu</affiliation>
<role>
<roleTerm type="text">author</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Victor</namePart>
<namePart type="family">Muntés-Mulero</namePart>
<affiliation>DAMA-UPC, Departament d’Arquitectura de Computadors, Universitat Politècnica de Catalunya, Campus Nord-UPC, 08034, Barcelona</affiliation>
<affiliation>E-mail: vmuntes@ac.upc.edu</affiliation>
<role>
<roleTerm type="text">author</roleTerm>
</role>
</name>
<typeOfResource>text</typeOfResource>
<genre type="conference" displayLabel="OriginalPaper"></genre>
<originInfo>
<publisher>Springer Berlin Heidelberg</publisher>
<place>
<placeTerm type="text">Berlin, Heidelberg</placeTerm>
</place>
<dateIssued encoding="w3cdtf">2010</dateIssued>
<copyrightDate encoding="w3cdtf">2010</copyrightDate>
</originInfo>
<language>
<languageTerm type="code" authority="rfc3066">en</languageTerm>
<languageTerm type="code" authority="iso639-2b">eng</languageTerm>
</language>
<physicalDescription>
<internetMediaType>text/html</internetMediaType>
</physicalDescription>
<abstract lang="en">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®.</abstract>
<relatedItem type="host">
<titleInfo>
<title>Database and Expert Systems Applications</title>
<subTitle>21st International Conference, DEXA 2010, Bilbao, Spain, August 30 - September 3, 2010, Proceedings, Part I</subTitle>
</titleInfo>
<name type="personal">
<namePart type="given">Pablo</namePart>
<namePart type="given">García</namePart>
<namePart type="family">Bringas</namePart>
<affiliation>DeustoTech Computing, University of Deusto, Avda. Universidades, 24, 48007, Bilbao, Spain</affiliation>
<affiliation>E-mail: pablo.garcia.bringas@deusto.es</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Abdelkader</namePart>
<namePart type="family">Hameurlain</namePart>
<affiliation>Institut de Recherche en Informatique de Toulouse (IRIT), Paul Sabatier University, 118, route de Narbonne, 31062, Toulouse Cedex, France</affiliation>
<affiliation>E-mail: hameur@irit.fr</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Gerald</namePart>
<namePart type="family">Quirchmayr</namePart>
<affiliation>Faculty of Computer Science, Department of Distributed Systems and Multimedia Systems, University of Vienna, Liebiggasse 4/3-4, 1010, Vienna, Austria</affiliation>
<affiliation>E-mail: Gerald.Quirchmayr@univie.ac.at</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<genre type="book-series" displayLabel="Proceedings"></genre>
<originInfo>
<copyrightDate encoding="w3cdtf">2010</copyrightDate>
<issuance>monographic</issuance>
</originInfo>
<subject>
<genre>Book-Subject-Collection</genre>
<topic authority="SpringerSubjectCodes" authorityURI="SUCO11645">Computer Science</topic>
</subject>
<subject>
<genre>Book-Subject-Group</genre>
<topic authority="SpringerSubjectCodes" authorityURI="I">Computer Science</topic>
<topic authority="SpringerSubjectCodes" authorityURI="I18040">Information Systems Applications (incl.Internet)</topic>
<topic authority="SpringerSubjectCodes" authorityURI="I21017">Artificial Intelligence (incl. Robotics)</topic>
<topic authority="SpringerSubjectCodes" authorityURI="I13022">Computer Communication Networks</topic>
<topic authority="SpringerSubjectCodes" authorityURI="I18032">Information Storage and Retrieval</topic>
<topic authority="SpringerSubjectCodes" authorityURI="I18024">Database Management</topic>
<topic authority="SpringerSubjectCodes" authorityURI="I18030">Data Mining and Knowledge Discovery</topic>
</subject>
<identifier type="DOI">10.1007/978-3-642-15364-8</identifier>
<identifier type="ISBN">978-3-642-15363-1</identifier>
<identifier type="eISBN">978-3-642-15364-8</identifier>
<identifier type="ISSN">0302-9743</identifier>
<identifier type="eISSN">1611-3349</identifier>
<identifier type="BookTitleID">213114</identifier>
<identifier type="BookID">978-3-642-15364-8</identifier>
<identifier type="BookChapterCount">44</identifier>
<identifier type="BookVolumeNumber">6261</identifier>
<identifier type="BookSequenceNumber">6261</identifier>
<identifier type="PartChapterCount">4</identifier>
<part>
<date>2010</date>
<detail type="part">
<title>Decision Support Systems and Performance (Short Papers)</title>
</detail>
<detail type="volume">
<number>6261</number>
<caption>vol.</caption>
</detail>
<extent unit="pages">
<start>231</start>
<end>240</end>
</extent>
</part>
<recordInfo>
<recordOrigin>Springer-Verlag Berlin Heidelberg, 2010</recordOrigin>
</recordInfo>
</relatedItem>
<relatedItem type="series">
<titleInfo>
<title>Lecture Notes in Computer Science</title>
</titleInfo>
<name type="personal">
<namePart type="given">David</namePart>
<namePart type="family">Hutchison</namePart>
<affiliation>Lancaster University, Lancaster, UK</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Takeo</namePart>
<namePart type="family">Kanade</namePart>
<affiliation>Carnegie Mellon University, Pittsburgh, PA, USA</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Josef</namePart>
<namePart type="family">Kittler</namePart>
<affiliation>University of Surrey, Guildford, UK</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Jon</namePart>
<namePart type="given">M.</namePart>
<namePart type="family">Kleinberg</namePart>
<affiliation>Cornell University, Ithaca, NY, USA</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Friedemann</namePart>
<namePart type="family">Mattern</namePart>
<affiliation>ETH Zurich, Zurich, Switzerland</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">John</namePart>
<namePart type="given">C.</namePart>
<namePart type="family">Mitchell</namePart>
<affiliation>Stanford University, Stanford, CA, USA</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Moni</namePart>
<namePart type="family">Naor</namePart>
<affiliation>Weizmann Institute of Science, Rehovot, Israel</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Oscar</namePart>
<namePart type="family">Nierstrasz</namePart>
<affiliation>University of Bern, Bern, Switzerland</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">C.</namePart>
<namePart type="family">Pandu Rangan</namePart>
<affiliation>Indian Institute of Technology, Madras, India</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Bernhard</namePart>
<namePart type="family">Steffen</namePart>
<affiliation>University of Dortmund, Dortmund, Germany</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Madhu</namePart>
<namePart type="family">Sudan</namePart>
<affiliation>Massachusetts Institute of Technology, MA, USA</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Demetri</namePart>
<namePart type="family">Terzopoulos</namePart>
<affiliation>University of California, Los Angeles, CA, USA</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Doug</namePart>
<namePart type="family">Tygar</namePart>
<affiliation>University of California, Berkeley, CA, USA</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Moshe</namePart>
<namePart type="given">Y.</namePart>
<namePart type="family">Vardi</namePart>
<affiliation>Rice University, Houston, TX, USA</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="given">Gerhard</namePart>
<namePart type="family">Weikum</namePart>
<affiliation>Max-Planck Institute of Computer Science, Saarbrücken, Germany</affiliation>
<role>
<roleTerm type="text">editor</roleTerm>
</role>
</name>
<originInfo>
<copyrightDate encoding="w3cdtf">2010</copyrightDate>
<issuance>serial</issuance>
</originInfo>
<identifier type="ISSN">0302-9743</identifier>
<identifier type="eISSN">1611-3349</identifier>
<identifier type="SeriesID">558</identifier>
<recordInfo>
<recordOrigin>Springer-Verlag Berlin Heidelberg, 2010</recordOrigin>
</recordInfo>
</relatedItem>
<identifier type="istex">DA869BC2E851E59C35E094D8F4B0415BF707D364</identifier>
<identifier type="DOI">10.1007/978-3-642-15364-8_17</identifier>
<identifier type="ChapterID">17</identifier>
<identifier type="ChapterID">Chap17</identifier>
<accessCondition type="use and reproduction" contentType="copyright">Springer-Verlag Berlin Heidelberg, 2010</accessCondition>
<recordInfo>
<recordContentSource>SPRINGER</recordContentSource>
<recordOrigin>Springer-Verlag Berlin Heidelberg, 2010</recordOrigin>
</recordInfo>
</mods>
</metadata>
<enrichments>
<json:item>
<type>multicat</type>
<uri>https://api.istex.fr/document/DA869BC2E851E59C35E094D8F4B0415BF707D364/enrichments/multicat</uri>
</json:item>
<istex:refBibTEI uri="https://api.istex.fr/document/DA869BC2E851E59C35E094D8F4B0415BF707D364/enrichments/refBib">
<teiHeader></teiHeader>
<text>
<front></front>
<body></body>
<back>
<listBibl>
<biblStruct xml:id="b0">
<analytic>
<title level="a" type="main">Main memory database systems: An overview</title>
<author>
<persName>
<forename type="first">H</forename>
<surname>Garcia-Molina</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">K</forename>
<surname>Salem</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="j">IEEE Transactions on knowledge and data engineering</title>
<imprint>
<biblScope unit="volume">4</biblScope>
<biblScope unit="issue">6</biblScope>
<biblScope unit="page" from="509" to="516"></biblScope>
<date type="published" when="1992"></date>
</imprint>
</monogr>
</biblStruct>
<biblStruct xml:id="b1">
<analytic>
<title level="a" type="main">Space/time trade-offs in hash coding with allowable errors</title>
<author>
<persName>
<forename type="first">B</forename>
<surname>Bloom</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="j">Communications of the ACM</title>
<imprint>
<biblScope unit="volume">13</biblScope>
<biblScope unit="issue">7</biblScope>
<biblScope unit="page">426</biblScope>
<date type="published" when="1970"></date>
</imprint>
</monogr>
</biblStruct>
<biblStruct xml:id="b2">
<analytic>
<title level="a" type="main">Dynamic adaptive data structures for monitoring data streams</title>
<author>
<persName>
<forename type="first">J</forename>
<surname>Aguilar-Saborit</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">P</forename>
<surname>Trancoso</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">V</forename>
<surname>Muntés-Mulero</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">J.-L</forename>
<surname>Larriba-Pey</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="j">Data Knowl. Eng</title>
<imprint>
<biblScope unit="volume">66</biblScope>
<biblScope unit="issue">1</biblScope>
<biblScope unit="page" from="92" to="115"></biblScope>
<date type="published" when="2008"></date>
</imprint>
</monogr>
</biblStruct>
<biblStruct xml:id="b3">
<analytic>
<title level="a" type="main">Implementation techniques for main memory database systems</title>
<author>
<persName>
<forename type="first">D</forename>
<surname>Dewitt</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">R</forename>
<surname>Katz</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">F</forename>
<surname>Olken</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">L</forename>
<surname>Shapiro</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">M</forename>
<surname>Stonebraker</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">D</forename>
<surname>Wood</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="m">Proceedings of the 1984 ACM SIGMOD International Conference on Management of Data</title>
<meeting>the 1984 ACM SIGMOD International Conference on Management of Data
<address>
<addrLine>New York</addrLine>
</address>
</meeting>
<imprint>
<publisher>ACM</publisher>
<date type="published" when="1984"></date>
<biblScope unit="page" from="1" to="8"></biblScope>
</imprint>
</monogr>
</biblStruct>
<biblStruct xml:id="b4">
<analytic>
<title level="a" type="main">SIREN: a memory-conserving, snapshot-consistent checkpoint algorithm for in-memory databases</title>
<author>
<persName>
<forename type="first">A</forename>
<surname>Liedes</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">A</forename>
<surname>Wolski</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="m">ICDE'06. Proceedings of the 22nd International Conference on Data Engineering</title>
<imprint>
<date type="published" when="2006"></date>
<biblScope unit="page">99</biblScope>
</imprint>
</monogr>
</biblStruct>
<biblStruct xml:id="b5">
<analytic>
<title level="a" type="main">The end of an architectural era it's time for a complete rewrite)</title>
<author>
<persName>
<forename type="first">M</forename>
<surname>Stonebraker</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">S</forename>
<surname>Madden</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">D</forename>
<surname>Abadi</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">S</forename>
<surname>Harizopoulos</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">N</forename>
<surname>Hachem</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">P</forename>
<surname>Helland</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="m">Proceedings of the 33rd International Conference on Very Large Data Bases, VLDB Endowment</title>
<meeting>the 33rd International Conference on Very Large Data Bases, VLDB Endowment</meeting>
<imprint>
<date type="published" when="2007"></date>
<biblScope unit="page" from="1150" to="1160"></biblScope>
</imprint>
</monogr>
</biblStruct>
<biblStruct xml:id="b6">
<analytic>
<title level="a" type="main">Breaking the memory wall in MonetDB 8 Implementation of storage manager in main memory database system altibase TM In-memory data management for consumer transactions the timesten approach</title>
<author>
<persName>
<forename type="first">P</forename>
<surname>Boncz</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">M</forename>
<surname>Kersten</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">S</forename>
<surname>Manegold</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">K</forename>
<surname>Jung</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">K</forename>
<surname>Lee</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">H</forename>
<surname>Bae</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="m">RTCSA 2003</title>
<editor>Chen, J., Hong, S.</editor>
<meeting>
<address>
<addrLine>Heidelberg ; Team, C</addrLine>
</address>
</meeting>
<imprint>
<publisher>Springer</publisher>
<date type="published" when="1999"></date>
<biblScope unit="page" from="499" to="512"></biblScope>
</imprint>
</monogr>
</biblStruct>
<biblStruct xml:id="b7">
<analytic>
<title level="a" type="main">Finding frequent items in data streams using ESBF</title>
<author>
<persName>
<forename type="first">S</forename>
<surname>Wang</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">X</forename>
<surname>Hao</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">H</forename>
<surname>Xu</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">Y</forename>
<surname>Hu</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="m">PAKDD 2007</title>
<editor>Washio, T., Zhou, Z.-H., Huang, J.Z., Hu, X., Li, J., Xie, C., He, J., Zou, D., Li, K.-C., Freire, M.M.</editor>
<meeting>
<address>
<addrLine>Heidelberg</addrLine>
</address>
</meeting>
<imprint>
<publisher>Springer</publisher>
<date type="published" when="2007"></date>
<biblScope unit="page" from="244" to="255"></biblScope>
</imprint>
</monogr>
</biblStruct>
<biblStruct xml:id="b8">
<analytic>
<title level="a" type="main">Network applications of bloom filters: A survey</title>
<author>
<persName>
<forename type="first">A</forename>
<surname>Broder</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">M</forename>
<surname>Mitzenmacher</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="j">Internet Mathematics</title>
<imprint>
<biblScope unit="volume">1</biblScope>
<biblScope unit="issue">4</biblScope>
<biblScope unit="page" from="485" to="509"></biblScope>
<date type="published" when="2004"></date>
</imprint>
</monogr>
</biblStruct>
<biblStruct xml:id="b9">
<analytic>
<title level="a" type="main">Scaling filename queries in a large-scale distributed file system</title>
<author>
<persName>
<forename type="first">J</forename>
<surname>Ledlie</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">L</forename>
<surname>Serban</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">D</forename>
<surname>Toncheva</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="j">Tech. rep</title>
<imprint>
<date type="published" when="2002"></date>
</imprint>
</monogr>
</biblStruct>
<biblStruct xml:id="b10">
<analytic>
<title level="a" type="main">Approximate frequency counts over data streams</title>
<author>
<persName>
<forename type="first">G</forename>
<surname>Manku</surname>
</persName>
</author>
<author>
<persName>
<forename type="first">R</forename>
<surname>Motwani</surname>
</persName>
</author>
</analytic>
<monogr>
<title level="m">Proceedings of the 28th International Conference on Very Large Data Bases, VLDB Endowment</title>
<meeting>the 28th International Conference on Very Large Data Bases, VLDB Endowment</meeting>
<imprint>
<date type="published" when="2002"></date>
<biblScope unit="page">357</biblScope>
</imprint>
</monogr>
</biblStruct>
</listBibl>
</back>
</text>
</istex:refBibTEI>
<json:item>
<type>refBibs</type>
<uri>https://api.istex.fr/document/DA869BC2E851E59C35E094D8F4B0415BF707D364/enrichments/refBibs</uri>
</json:item>
</enrichments>
</istex>
</record>

Pour manipuler ce document sous Unix (Dilib)

EXPLOR_STEP=$WICRI_ROOT/Ticri/CIDE/explor/CyberinfraV1/Data/Istex/Corpus
HfdSelect -h $EXPLOR_STEP/biblio.hfd -nk 000573 | SxmlIndent | more

Ou

HfdSelect -h $EXPLOR_AREA/Data/Istex/Corpus/biblio.hfd -nk 000573 | SxmlIndent | more

Pour mettre un lien sur cette page dans le réseau Wicri

{{Explor lien
   |wiki=    Ticri/CIDE
   |area=    CyberinfraV1
   |flux=    Istex
   |étape=   Corpus
   |type=    RBID
   |clé=     ISTEX:DA869BC2E851E59C35E094D8F4B0415BF707D364
   |texte=   Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses
}}

Wicri

This area was generated with Dilib version V0.6.25.
Data generation: Thu Oct 27 09:30:58 2016. Site generation: Sun Mar 10 23:08:40 2024