Show simple item record

dc.contributor.authorTrancoso, Pedroen
dc.contributor.authorTorrellas, Josepen
dc.coverage.spatialAustin, TX, USAen
dc.creatorTrancoso, Pedroen
dc.creatorTorrellas, Josepen
dc.description.abstractDramatic increases in the main-memory size of computers is allowing some applications to shift their main data storage area from disk to main memory and, as a result, increase their performance. This trend is at work in some databases, resulting in what is called memory-resident databases. However, because of the increasing gap between processor and main memory speed, in these systems, effective use of the cache hierarchy is crucial to high performance. Unfortunately, there has been relatively little work on building cache-friendly database systems. In this paper, we present several cache-oriented optimizations to enable effective exploitation of caches in memory-resident decision support databases. The main optimization involves developing a query optimizer that includes the cost of cache misses in its cost metrics. The other optimizations are sophisticated data blocking and software prefetching. These optimizations require no custom-designed hardware support and are effective for the more complicated TPC-D queries. In a simple database, these queries run about 13% faster with the cache-oriented optimizer and blocking, and a total of 31% faster if, in addition, we add prefetching. The effectiveness of these optimizations is stable across a range of cache sizes, cache line sizes, and miss penalties.en
dc.sourceInternational Conference on Computer Design (ICCD'99)en
dc.subjectDecision support systemsen
dc.subjectComputer architectureen
dc.subjectBuffer storageen
dc.subjectQuery languagesen
dc.subjectStorage allocation (computer)en
dc.subjectData blockingen
dc.subjectMemory resident databasesen
dc.subjectSoftware prefetchingen
dc.titleCache optimization for memory-resident decision support commercial workloadsen
dc.description.endingpage554 Σχολή Θετικών και Εφαρμοσμένων Επιστημών / Faculty of Pure and Applied SciencesΤμήμα Πληροφορικής / Department of Computer Science
dc.description.notes<p>Sponsors: IEEE Computer Societyen
dc.description.notesConference code: 56839en
dc.description.notesCited By :6</p>en
dc.source.abbreviationProc IEEE Int Conf Comput Des VLSI Comput Processen
dc.contributor.orcidTrancoso, Pedro [0000-0002-2776-9253]

Files in this item


There are no files associated with this item.

This item appears in the following Collection(s)

Show simple item record