dc.contributor.author | Trancoso, Pedro | en |
dc.contributor.author | Torrellas, Josep | en |
dc.coverage.spatial | Austin, TX, USA | en |
dc.creator | Trancoso, Pedro | en |
dc.creator | Torrellas, Josep | en |
dc.date.accessioned | 2019-11-13T10:42:30Z | |
dc.date.available | 2019-11-13T10:42:30Z | |
dc.date.issued | 1999 | |
dc.identifier.uri | http://gnosis.library.ucy.ac.cy/handle/7/55083 | |
dc.description.abstract | Dramatic 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.source | International Conference on Computer Design (ICCD'99) | en |
dc.source.uri | https://www.scopus.com/inward/record.uri?eid=2-s2.0-0033299131&partnerID=40&md5=5e2ccf3e238132e68b3b202933159144 | |
dc.subject | Optimization | en |
dc.subject | Decision support systems | en |
dc.subject | Computer architecture | en |
dc.subject | Buffer storage | en |
dc.subject | Query languages | en |
dc.subject | Storage allocation (computer) | en |
dc.subject | Data blocking | en |
dc.subject | Memory resident databases | en |
dc.subject | Software prefetching | en |
dc.title | Cache optimization for memory-resident decision support commercial workloads | en |
dc.type | info:eu-repo/semantics/article | |
dc.description.startingpage | 546 | |
dc.description.endingpage | 554 | |
dc.author.faculty | 002 Σχολή Θετικών και Εφαρμοσμένων Επιστημών / Faculty of Pure and Applied Sciences | |
dc.author.department | Τμήμα Πληροφορικής / Department of Computer Science | |
dc.type.uhtype | Article | en |
dc.description.notes | <p>Sponsors: IEEE Computer Society | en |
dc.description.notes | Conference code: 56839 | en |
dc.description.notes | Cited By :6</p> | en |
dc.source.abbreviation | Proc IEEE Int Conf Comput Des VLSI Comput Process | en |
dc.contributor.orcid | Trancoso, Pedro [0000-0002-2776-9253] | |
dc.gnosis.orcid | 0000-0002-2776-9253 | |