Matches in SemOpenAlex for { <https://semopenalex.org/work/W1999883293> ?p ?o ?g. }
Showing items 1 to 84 of
84
with 100 items per page.
- W1999883293 abstract "Column store databases allow for various tuple reconstruction strategies (also called materialization strategies). Early materialization is easy to implement but generally performs worse than late materialization. Late materialization is more complex to implement, and usually performs much better than early materialization, although there are situations where it is worse. We identify these situations, which essentially revolve around joins where neither input fits in memory (also called spilling joins). Sideways information passing techniques provide a viable solution to get the best of both worlds. We demonstrate how early materialization combined with sideways information passing allows us to get the benefits of late materialization, without the bookkeeping complexity or worse performance for spilling joins. It also provides some other benefits to query processing in Vertica due to positive interaction with compression and sort orders of the data. In this paper, we report our experiences with late and early materialization, highlight their strengths and weaknesses, and present the details of our sideways information passing implementation. We show experimental results of comparing these materialization strategies, which highlight the significant performance improvements provided by our implementation of sideways information passing (up to 72% on some TPC-H queries)." @default.
- W1999883293 created "2016-06-24" @default.
- W1999883293 creator A5002810936 @default.
- W1999883293 creator A5049046541 @default.
- W1999883293 creator A5078763446 @default.
- W1999883293 creator A5079213222 @default.
- W1999883293 creator A5079515510 @default.
- W1999883293 creator A5083195789 @default.
- W1999883293 date "2013-04-01" @default.
- W1999883293 modified "2023-09-25" @default.
- W1999883293 title "Materialization strategies in the Vertica analytic database: Lessons learned" @default.
- W1999883293 cites W2043934800 @default.
- W1999883293 cites W2069944651 @default.
- W1999883293 cites W2087796842 @default.
- W1999883293 cites W2100542992 @default.
- W1999883293 cites W2102639991 @default.
- W1999883293 cites W2116436709 @default.
- W1999883293 cites W2123845384 @default.
- W1999883293 cites W2144839430 @default.
- W1999883293 cites W2146709231 @default.
- W1999883293 cites W2153485419 @default.
- W1999883293 cites W2167631575 @default.
- W1999883293 doi "https://doi.org/10.1109/icde.2013.6544909" @default.
- W1999883293 hasPublicationYear "2013" @default.
- W1999883293 type Work @default.
- W1999883293 sameAs 1999883293 @default.
- W1999883293 citedByCount "18" @default.
- W1999883293 countsByYear W19998832932014 @default.
- W1999883293 countsByYear W19998832932015 @default.
- W1999883293 countsByYear W19998832932016 @default.
- W1999883293 countsByYear W19998832932017 @default.
- W1999883293 countsByYear W19998832932018 @default.
- W1999883293 countsByYear W19998832932019 @default.
- W1999883293 countsByYear W19998832932021 @default.
- W1999883293 countsByYear W19998832932022 @default.
- W1999883293 countsByYear W19998832932023 @default.
- W1999883293 crossrefType "proceedings-article" @default.
- W1999883293 hasAuthorship W1999883293A5002810936 @default.
- W1999883293 hasAuthorship W1999883293A5049046541 @default.
- W1999883293 hasAuthorship W1999883293A5078763446 @default.
- W1999883293 hasAuthorship W1999883293A5079213222 @default.
- W1999883293 hasAuthorship W1999883293A5079515510 @default.
- W1999883293 hasAuthorship W1999883293A5083195789 @default.
- W1999883293 hasConcept C111472728 @default.
- W1999883293 hasConcept C118615104 @default.
- W1999883293 hasConcept C118930307 @default.
- W1999883293 hasConcept C138885662 @default.
- W1999883293 hasConcept C199360897 @default.
- W1999883293 hasConcept C2522767166 @default.
- W1999883293 hasConcept C2778692605 @default.
- W1999883293 hasConcept C33923547 @default.
- W1999883293 hasConcept C41008148 @default.
- W1999883293 hasConcept C63882131 @default.
- W1999883293 hasConcept C77088390 @default.
- W1999883293 hasConcept C88548561 @default.
- W1999883293 hasConceptScore W1999883293C111472728 @default.
- W1999883293 hasConceptScore W1999883293C118615104 @default.
- W1999883293 hasConceptScore W1999883293C118930307 @default.
- W1999883293 hasConceptScore W1999883293C138885662 @default.
- W1999883293 hasConceptScore W1999883293C199360897 @default.
- W1999883293 hasConceptScore W1999883293C2522767166 @default.
- W1999883293 hasConceptScore W1999883293C2778692605 @default.
- W1999883293 hasConceptScore W1999883293C33923547 @default.
- W1999883293 hasConceptScore W1999883293C41008148 @default.
- W1999883293 hasConceptScore W1999883293C63882131 @default.
- W1999883293 hasConceptScore W1999883293C77088390 @default.
- W1999883293 hasConceptScore W1999883293C88548561 @default.
- W1999883293 hasLocation W19998832931 @default.
- W1999883293 hasOpenAccess W1999883293 @default.
- W1999883293 hasPrimaryLocation W19998832931 @default.
- W1999883293 hasRelatedWork W2065180665 @default.
- W1999883293 hasRelatedWork W2356233976 @default.
- W1999883293 hasRelatedWork W2361224859 @default.
- W1999883293 hasRelatedWork W2369009739 @default.
- W1999883293 hasRelatedWork W2374348909 @default.
- W1999883293 hasRelatedWork W2511282645 @default.
- W1999883293 hasRelatedWork W2748952813 @default.
- W1999883293 hasRelatedWork W2972818405 @default.
- W1999883293 hasRelatedWork W3004832935 @default.
- W1999883293 hasRelatedWork W3017281951 @default.
- W1999883293 isParatext "false" @default.
- W1999883293 isRetracted "false" @default.
- W1999883293 magId "1999883293" @default.
- W1999883293 workType "article" @default.