FRINK Linked Data Fragments server

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

• W2151454464 abstract "Database systems use precomputed synopses of data to estimate the cost of alternative plans during query optimization. A number of alternative synopsis structures have been proposed, but histograms are by far the most commonly used. While histograms have proved to be very effective in (cost estimation for) single-table selections, queries with joins have long been seen as a challenge; under a model where histograms are maintained for individual tables, a celebrated result of Ioannidis and Christodoulakis observes that errors propagate exponentially with the number of joins in a query.In this paper, we make two main contributions. First, we study the space complexity of using synopses for query optimization from a novel information-theoretic perspective. In particular, we offer evidence in support of histograms for single-table selections, and illustrate their limitations for join queries. Second, for a broad class of common queries involving joins (specifically, all queries involving only key-foreign key joins) we show that the strategy of storing a small pre-computed sample of the database yields probabilistic guarantees that are almost space-optimal, in the sense that in order to provide the same guarantee as sampling, any strategy requires almost the same amount of space. This is an important property if these samples are to be used as database statistics. This is the first such optimality result, to our knowledge, and suggests that pre-computed samples might be an effective way to circumvent the error propagation problem for queries with key-foreign key joins. We support this result empirically through an experimental study that demonstrates the effectiveness of pre-computed samples, and also shows the increasing difference in the effectiveness of samples versus multi-dimensional histograms as the number of joins in the query grows." @default.
• W2151454464 created "2016-06-24" @default.
• W2151454464 creator A5012670075 @default.
• W2151454464 creator A5017678555 @default.
• W2151454464 creator A5051301731 @default.
• W2151454464 creator A5091173524 @default.
• W2151454464 date "2004-01-01" @default.
• W2151454464 modified "2023-09-27" @default.
• W2151454464 title "Synopses for query optimization" @default.
• W2151454464 cites W1495007564 @default.
• W2151454464 cites W1589269155 @default.
• W2151454464 cites W1590291442 @default.
• W2151454464 cites W1592355944 @default.
• W2151454464 cites W1822348499 @default.
• W2151454464 cites W1964857063 @default.
• W2151454464 cites W1968829657 @default.
• W2151454464 cites W1977570286 @default.
• W2151454464 cites W1987175217 @default.
• W2151454464 cites W1991271936 @default.
• W2151454464 cites W199677694 @default.
• W2151454464 cites W1998244781 @default.
• W2151454464 cites W2002501531 @default.
• W2151454464 cites W2005188603 @default.
• W2151454464 cites W2007069074 @default.
• W2151454464 cites W2008931591 @default.
• W2151454464 cites W2010890196 @default.
• W2151454464 cites W2011679994 @default.
• W2151454464 cites W2013092187 @default.
• W2151454464 cites W2018666252 @default.
• W2151454464 cites W2020584928 @default.
• W2151454464 cites W2026896584 @default.
• W2151454464 cites W2046437776 @default.
• W2151454464 cites W2060091058 @default.
• W2151454464 cites W2064379477 @default.
• W2151454464 cites W2066623874 @default.
• W2151454464 cites W2073476719 @default.
• W2151454464 cites W2084812512 @default.
• W2151454464 cites W2110557355 @default.
• W2151454464 cites W2112227848 @default.
• W2151454464 cites W2118229812 @default.
• W2151454464 cites W2120108467 @default.
• W2151454464 cites W2148706674 @default.
• W2151454464 cites W2151310484 @default.
• W2151454464 cites W2153329411 @default.
• W2151454464 cites W2154198326 @default.
• W2151454464 cites W2161463763 @default.
• W2151454464 cites W2171903035 @default.
• W2151454464 cites W2340787257 @default.
• W2151454464 cites W2981264952 @default.
• W2151454464 cites W2982720039 @default.
• W2151454464 cites W3097169496 @default.
• W2151454464 cites W605043455 @default.
• W2151454464 cites W69989483 @default.
• W2151454464 doi "https://doi.org/10.1145/1055558.1055586" @default.
• W2151454464 hasPublicationYear "2004" @default.
• W2151454464 type Work @default.
• W2151454464 sameAs 2151454464 @default.
• W2151454464 citedByCount "7" @default.
• W2151454464 countsByYear W21514544642018 @default.
• W2151454464 countsByYear W21514544642019 @default.
• W2151454464 crossrefType "proceedings-article" @default.
• W2151454464 hasAuthorship W2151454464A5012670075 @default.
• W2151454464 hasAuthorship W2151454464A5017678555 @default.
• W2151454464 hasAuthorship W2151454464A5051301731 @default.
• W2151454464 hasAuthorship W2151454464A5091173524 @default.
• W2151454464 hasConcept C115961682 @default.
• W2151454464 hasConcept C124101348 @default.
• W2151454464 hasConcept C148840519 @default.
• W2151454464 hasConcept C154945302 @default.
• W2151454464 hasConcept C157692150 @default.
• W2151454464 hasConcept C199360897 @default.
• W2151454464 hasConcept C23123220 @default.
• W2151454464 hasConcept C26517878 @default.
• W2151454464 hasConcept C2778692605 @default.
• W2151454464 hasConcept C38652104 @default.
• W2151454464 hasConcept C41008148 @default.
• W2151454464 hasConcept C45235069 @default.
• W2151454464 hasConcept C49937458 @default.
• W2151454464 hasConcept C53533937 @default.
• W2151454464 hasConcept C54239708 @default.
• W2151454464 hasConcept C77088390 @default.
• W2151454464 hasConcept C80444323 @default.
• W2151454464 hasConceptScore W2151454464C115961682 @default.
• W2151454464 hasConceptScore W2151454464C124101348 @default.
• W2151454464 hasConceptScore W2151454464C148840519 @default.
• W2151454464 hasConceptScore W2151454464C154945302 @default.
• W2151454464 hasConceptScore W2151454464C157692150 @default.
• W2151454464 hasConceptScore W2151454464C199360897 @default.
• W2151454464 hasConceptScore W2151454464C23123220 @default.
• W2151454464 hasConceptScore W2151454464C26517878 @default.
• W2151454464 hasConceptScore W2151454464C2778692605 @default.
• W2151454464 hasConceptScore W2151454464C38652104 @default.
• W2151454464 hasConceptScore W2151454464C41008148 @default.
• W2151454464 hasConceptScore W2151454464C45235069 @default.
• W2151454464 hasConceptScore W2151454464C49937458 @default.
• W2151454464 hasConceptScore W2151454464C53533937 @default.
• W2151454464 hasConceptScore W2151454464C54239708 @default.
• W2151454464 hasConceptScore W2151454464C77088390 @default.
• W2151454464 hasConceptScore W2151454464C80444323 @default.
• W2151454464 hasLocation W21514544641 @default.

• next