Matches in SemOpenAlex for { <https://semopenalex.org/work/W2081593332> ?p ?o ?g. }
- W2081593332 endingPage "43" @default.
- W2081593332 startingPage "1" @default.
- W2081593332 abstract "Automatic recycling of intermediate results to improve both query response time and throughput is a grand challenge for state-of-the-art databases. Tuples are loaded and streamed through a tuple-at-a-time processing pipeline, avoiding materialization of intermediates as much as possible. This limits the opportunities for reuse of overlapping computations to DBA-defined materialized views and function/result cache tuning. In contrast, the operator-at-a-time execution paradigm produces fully materialized results in each step of the query plan. To avoid resource contention, these intermediates are evicted as soon as possible. In this article we study an architecture that harvests the byproducts of the operator-at-a-time paradigm in a column-store system using a lightweight mechanism, the recycler. The key challenge then becomes the selection of the policies to admit intermediates to the resource pool, to determine their retention period, and devise the eviction strategy when facing resource limitations. The proposed recycling architecture has been implemented in an open-source system. An experimental analysis against the TPC-H ad-hoc decision support benchmark and a complex, real-world application (SkyServer) demonstrates its effectiveness in terms of self-organizing behavior and its significant performance gains. The results indicate the potentials of recycling intermediates and charts a route for further development of database kernels." @default.
- W2081593332 created "2016-06-24" @default.
- W2081593332 creator A5027344604 @default.
- W2081593332 creator A5041092741 @default.
- W2081593332 creator A5067082480 @default.
- W2081593332 creator A5090507213 @default.
- W2081593332 date "2010-10-12" @default.
- W2081593332 modified "2023-10-18" @default.
- W2081593332 title "An architecture for recycling intermediates in a column-store" @default.
- W2081593332 cites W1605782097 @default.
- W2081593332 cites W1973382888 @default.
- W2081593332 cites W1987238352 @default.
- W2081593332 cites W1989163741 @default.
- W2081593332 cites W1992977903 @default.
- W2081593332 cites W2038176938 @default.
- W2081593332 cites W2061751973 @default.
- W2081593332 cites W2068010682 @default.
- W2081593332 cites W2084961399 @default.
- W2081593332 cites W2096307514 @default.
- W2081593332 cites W2106105896 @default.
- W2081593332 cites W2119946100 @default.
- W2081593332 cites W2124624809 @default.
- W2081593332 cites W2134912727 @default.
- W2081593332 cites W2140453381 @default.
- W2081593332 cites W2164591245 @default.
- W2081593332 cites W2166391486 @default.
- W2081593332 cites W2170515491 @default.
- W2081593332 cites W2171492933 @default.
- W2081593332 cites W2951321531 @default.
- W2081593332 cites W4205167958 @default.
- W2081593332 doi "https://doi.org/10.1145/1862919.1862921" @default.
- W2081593332 hasPublicationYear "2010" @default.
- W2081593332 type Work @default.
- W2081593332 sameAs 2081593332 @default.
- W2081593332 citedByCount "33" @default.
- W2081593332 countsByYear W20815933322012 @default.
- W2081593332 countsByYear W20815933322013 @default.
- W2081593332 countsByYear W20815933322014 @default.
- W2081593332 countsByYear W20815933322015 @default.
- W2081593332 countsByYear W20815933322016 @default.
- W2081593332 countsByYear W20815933322017 @default.
- W2081593332 countsByYear W20815933322018 @default.
- W2081593332 countsByYear W20815933322020 @default.
- W2081593332 countsByYear W20815933322021 @default.
- W2081593332 countsByYear W20815933322022 @default.
- W2081593332 crossrefType "journal-article" @default.
- W2081593332 hasAuthorship W2081593332A5027344604 @default.
- W2081593332 hasAuthorship W2081593332A5041092741 @default.
- W2081593332 hasAuthorship W2081593332A5067082480 @default.
- W2081593332 hasAuthorship W2081593332A5090507213 @default.
- W2081593332 hasBestOaLocation W20815933322 @default.
- W2081593332 hasConcept C111919701 @default.
- W2081593332 hasConcept C115537543 @default.
- W2081593332 hasConcept C118615104 @default.
- W2081593332 hasConcept C118930307 @default.
- W2081593332 hasConcept C120314980 @default.
- W2081593332 hasConcept C123657996 @default.
- W2081593332 hasConcept C13280743 @default.
- W2081593332 hasConcept C142362112 @default.
- W2081593332 hasConcept C148840519 @default.
- W2081593332 hasConcept C153349607 @default.
- W2081593332 hasConcept C157764524 @default.
- W2081593332 hasConcept C173608175 @default.
- W2081593332 hasConcept C185798385 @default.
- W2081593332 hasConcept C18903297 @default.
- W2081593332 hasConcept C205649164 @default.
- W2081593332 hasConcept C206345919 @default.
- W2081593332 hasConcept C206588197 @default.
- W2081593332 hasConcept C31258907 @default.
- W2081593332 hasConcept C33923547 @default.
- W2081593332 hasConcept C41008148 @default.
- W2081593332 hasConcept C43521106 @default.
- W2081593332 hasConcept C54239708 @default.
- W2081593332 hasConcept C555944384 @default.
- W2081593332 hasConcept C56800130 @default.
- W2081593332 hasConcept C77088390 @default.
- W2081593332 hasConcept C86803240 @default.
- W2081593332 hasConcept C98199447 @default.
- W2081593332 hasConceptScore W2081593332C111919701 @default.
- W2081593332 hasConceptScore W2081593332C115537543 @default.
- W2081593332 hasConceptScore W2081593332C118615104 @default.
- W2081593332 hasConceptScore W2081593332C118930307 @default.
- W2081593332 hasConceptScore W2081593332C120314980 @default.
- W2081593332 hasConceptScore W2081593332C123657996 @default.
- W2081593332 hasConceptScore W2081593332C13280743 @default.
- W2081593332 hasConceptScore W2081593332C142362112 @default.
- W2081593332 hasConceptScore W2081593332C148840519 @default.
- W2081593332 hasConceptScore W2081593332C153349607 @default.
- W2081593332 hasConceptScore W2081593332C157764524 @default.
- W2081593332 hasConceptScore W2081593332C173608175 @default.
- W2081593332 hasConceptScore W2081593332C185798385 @default.
- W2081593332 hasConceptScore W2081593332C18903297 @default.
- W2081593332 hasConceptScore W2081593332C205649164 @default.
- W2081593332 hasConceptScore W2081593332C206345919 @default.
- W2081593332 hasConceptScore W2081593332C206588197 @default.
- W2081593332 hasConceptScore W2081593332C31258907 @default.
- W2081593332 hasConceptScore W2081593332C33923547 @default.
- W2081593332 hasConceptScore W2081593332C41008148 @default.