FRINK Linked Data Fragments server

Matches in SemOpenAlex for { <https://semopenalex.org/work/W1965893058> ?p ?o ?g. }

• W1965893058 endingPage "143" @default.
• W1965893058 startingPage "96" @default.
• W1965893058 abstract "As improvements in processor performance continue to far outpace improvements in storage performance, I/O is increasingly the bottleneck in computer systems, especially in large database systems that manage huge amoungs of data. The key to achieving good I/O performance is to thoroughly understand its characteristics. In this article we present a comprehensive analysis of the logical I/O reference behavior of the peak productiondatabase workloads from ten of the world's largest corporations. In particular, we focus on how these workloads respond to different techniques for caching, prefetching, and write buffering. Our findings include several broadly applicable rules of thumb that describe how effective the various I/O optimization techniques are for the production workloads. For instance, our results indicate that the buffer pool miss ratio tends to be related to the ratio of buffer pool size to data size by an inverse square root rule. A similar fourth root rule relates the write miss ratio and the ration of buffer pool size to data size. In addition, we characterize the reference characteristics of workloads similar to the Transaction Processing Performance Council (TPC) benchmarks C (TPC-C) and D(TPC-D), which are de facto standard performance measures for online transaction processing (OLTP) systems and decision support systems (DSS), respectively. Since benchmarks such as TPC-C and TPC-D can only be used effectively if their strengths and limitations are understood, a major focus of our analysis is to identify aspects of the benchmarks that stress the system differently than the production workloads. We discover that for the most part, the reference behavior of TPC-C and TPC-D fall within the range of behavior exhibited by the production workloads. However, there are some noteworthy exceptions that affect well-known I/O optimization techniques such as caching (LRU is further from the optimal for TPC-C, while there is little sharing of pages between transactions for TPC-D), prefetching (TPC-C exhibits no significant sequentiality), and write buffering (write buffering is lees effective for the TPC benchmarks). While the two TPC benchmarks generally complement one another in reflecting the characteristics of the production workloads, there remain aspects of the real workloads that are not represented by either of the benchmarks." @default.
• W1965893058 created "2016-06-24" @default.
• W1965893058 creator A5010726131 @default.
• W1965893058 creator A5031105971 @default.
• W1965893058 creator A5048407385 @default.
• W1965893058 date "2001-03-01" @default.
• W1965893058 modified "2023-10-16" @default.
• W1965893058 title "I/O reference behavior of production database workloads and the TPC benchmarks—an analysis at the logical level" @default.
• W1965893058 cites W1967063635 @default.
• W1965893058 cites W1974817122 @default.
• W1965893058 cites W1985264830 @default.
• W1965893058 cites W1985573567 @default.
• W1965893058 cites W1987225815 @default.
• W1965893058 cites W2007415020 @default.
• W1965893058 cites W2008633193 @default.
• W1965893058 cites W2013168034 @default.
• W1965893058 cites W2016231742 @default.
• W1965893058 cites W2035606364 @default.
• W1965893058 cites W2040823248 @default.
• W1965893058 cites W2042138964 @default.
• W1965893058 cites W2043213682 @default.
• W1965893058 cites W2046269252 @default.
• W1965893058 cites W2053129230 @default.
• W1965893058 cites W2053605412 @default.
• W1965893058 cites W2054308357 @default.
• W1965893058 cites W2061901770 @default.
• W1965893058 cites W2062756891 @default.
• W1965893058 cites W2064421917 @default.
• W1965893058 cites W2065077642 @default.
• W1965893058 cites W2083113964 @default.
• W1965893058 cites W2095562348 @default.
• W1965893058 cites W2101767459 @default.
• W1965893058 cites W2104954161 @default.
• W1965893058 cites W2107460938 @default.
• W1965893058 cites W2123829659 @default.
• W1965893058 cites W2138194829 @default.
• W1965893058 cites W2147853062 @default.
• W1965893058 cites W2153329411 @default.
• W1965893058 cites W2158237121 @default.
• W1965893058 cites W2159209233 @default.
• W1965893058 cites W2159316256 @default.
• W1965893058 cites W2185907055 @default.
• W1965893058 cites W2205436351 @default.
• W1965893058 cites W2242726375 @default.
• W1965893058 cites W4238684507 @default.
• W1965893058 cites W4243786774 @default.
• W1965893058 cites W4254126235 @default.
• W1965893058 doi "https://doi.org/10.1145/383734.383737" @default.
• W1965893058 hasPublicationYear "2001" @default.
• W1965893058 type Work @default.
• W1965893058 sameAs 1965893058 @default.
• W1965893058 citedByCount "66" @default.
• W1965893058 countsByYear W19658930582012 @default.
• W1965893058 countsByYear W19658930582013 @default.
• W1965893058 countsByYear W19658930582014 @default.
• W1965893058 countsByYear W19658930582015 @default.
• W1965893058 countsByYear W19658930582016 @default.
• W1965893058 countsByYear W19658930582017 @default.
• W1965893058 countsByYear W19658930582020 @default.
• W1965893058 countsByYear W19658930582023 @default.
• W1965893058 crossrefType "journal-article" @default.
• W1965893058 hasAuthorship W1965893058A5010726131 @default.
• W1965893058 hasAuthorship W1965893058A5031105971 @default.
• W1965893058 hasAuthorship W1965893058A5048407385 @default.
• W1965893058 hasConcept C111919701 @default.
• W1965893058 hasConcept C120665830 @default.
• W1965893058 hasConcept C121332964 @default.
• W1965893058 hasConcept C135572916 @default.
• W1965893058 hasConcept C139719470 @default.
• W1965893058 hasConcept C149635348 @default.
• W1965893058 hasConcept C162324750 @default.
• W1965893058 hasConcept C191087605 @default.
• W1965893058 hasConcept C192209626 @default.
• W1965893058 hasConcept C201932085 @default.
• W1965893058 hasConcept C26517878 @default.
• W1965893058 hasConcept C2778348673 @default.
• W1965893058 hasConcept C2780513914 @default.
• W1965893058 hasConcept C41008148 @default.
• W1965893058 hasConcept C72108876 @default.
• W1965893058 hasConcept C75949130 @default.
• W1965893058 hasConcept C77088390 @default.
• W1965893058 hasConceptScore W1965893058C111919701 @default.
• W1965893058 hasConceptScore W1965893058C120665830 @default.
• W1965893058 hasConceptScore W1965893058C121332964 @default.
• W1965893058 hasConceptScore W1965893058C135572916 @default.
• W1965893058 hasConceptScore W1965893058C139719470 @default.
• W1965893058 hasConceptScore W1965893058C149635348 @default.
• W1965893058 hasConceptScore W1965893058C162324750 @default.
• W1965893058 hasConceptScore W1965893058C191087605 @default.
• W1965893058 hasConceptScore W1965893058C192209626 @default.
• W1965893058 hasConceptScore W1965893058C201932085 @default.
• W1965893058 hasConceptScore W1965893058C26517878 @default.
• W1965893058 hasConceptScore W1965893058C2778348673 @default.
• W1965893058 hasConceptScore W1965893058C2780513914 @default.
• W1965893058 hasConceptScore W1965893058C41008148 @default.
• W1965893058 hasConceptScore W1965893058C72108876 @default.
• W1965893058 hasConceptScore W1965893058C75949130 @default.
• W1965893058 hasConceptScore W1965893058C77088390 @default.

• next