Read-Optimized, Cache-Conscious, Page Layouts for Temporal Relational Data
Jouini, Khaled; Jomier, Geneviève; Kaboré, Patrick (2008), Read-Optimized, Cache-Conscious, Page Layouts for Temporal Relational Data, in Wagner, Roland; Küng, Josef; Bhowmick, Sourav, Database and Expert Systems Applications 19th International Conference, DEXA 2008, Springer : Berlin, p. 581-595. 10.1007/978-3-540-85654-2_49
Type
Communication / ConférenceDate
2008Conference title
19th International Conference DEXA 2008Conference date
2008-09Conference city
TurinConference country
ItalyBook title
Database and Expert Systems Applications 19th International Conference, DEXA 2008Book author
Wagner, Roland; Küng, Josef; Bhowmick, SouravPublisher
Springer
Series title
Lecture Notes in Computer ScienceSeries number
5181Published in
Berlin
ISBN
978-3-540-85653-5
Pages
581-595
Publication identifier
Metadata
Show full item recordAuthor(s)
Jouini, KhaledLaboratoire d'analyse et modélisation de systèmes pour l'aide à la décision [LAMSADE]
Jomier, Geneviève
Laboratoire d'analyse et modélisation de systèmes pour l'aide à la décision [LAMSADE]
Kaboré, Patrick
Abstract (EN)
The efficient management of temporal data is crucial for many traditional and emerging database applications. A major performance bottleneck for database systems is the memory hierarchy. The performance of the memory hierarchy is directly related to how the content of disk pages maps to the L2 cache lines, i.e. to the organization of data within a page or the page layout. The prevalent page layout in database systems is the N-ary Storage Model (NSM). As demonstrated in this paper, using NSM for temporal data deteriorates memory hierarchy performance for query-intensive workloads. This paper proposes, new cache-conscious, read-optimized, page layouts specifically tailored for temporal data. The proposed page layouts optimize accesses to all levels of the memory hierarchy by avoiding fetching the same data several times (as opposed to NSM). Experiments show that the proposed page layouts are substantially faster than NSM.Subjects / Keywords
page layout; Databases; temporal dataRelated items
Showing items related by title and author.
-
Jomier, Geneviève; Jouini, Khaled (2008) Communication / Conférence
-
Jouini, Khaled; Jomier, Geneviève (2009) Chapitre d'ouvrage
-
Jouini, Khaled; Jomier, Geneviève (2007) Communication / Conférence
-
Jomier, Geneviève; Jouini, Khaled (2006) Communication / Conférence
-
Jomier, Geneviève; Jouini, Khaled (2010) Article accepté pour publication ou publié