Matches in SemOpenAlex for { <https://semopenalex.org/work/W2294832208> ?p ?o ?g. }
Showing items 1 to 78 of
78
with 100 items per page.
- W2294832208 endingPage "242" @default.
- W2294832208 startingPage "233" @default.
- W2294832208 abstract "A rangesum query to an array A is a pair (l, r) of range endpoints, which should be answered by Σl≤irA[i]. To compress A, we consider representing an array A lossily by a histogram, a function that is constant on each of a small number of buckets. We then answer range queries from H instead of from A, i.e., as Σl≤irH[i]. An optimal rangesum histogram H for this purpose is one whose bucket boundaries and constant heights within buckets are chosen to minimize the expected square error, El, r[(Σl≤irA[i]--Σl≤irH[i].)2], assuming each rangesum query is equally likely. Rangesum histograms find many applications in database systems.In a degenerate variation, all rangesum queries are over ranges of size one, namely, individual points; histograms optimal for this special case are called pointwise optimal histograms. Pointwise optimal histogram is a classical notion in statistics and approximation theory, but rangesum optimal histogram appears to be novel in these areas. While optimal pointwise histograms can be constructed efficiently by simple dynamic progrmming, no efficient (even approximate) general rangesmn histogram construction algorithms were previously known. In practice, all commercial database systems use heuristically built histograms for pointwise and rangesum queries.We present the first general algorithms for approximate rangesum histograms. Given parameter B, we denote by (α, β)-approximation an algorithm to produce a (αB)-bucket histogram with error at most β times the error of the optimal B-bucket histogram. We give a (2, 1)-approximation with runtime O(N2B), a (2, 1+∊)-approximation with runtime N + (B log(N)/∊)O(1) (1), and a (1, 1 + ∊)-approximation with runtime O(B3N4/∊2). We also consider the problem of dynamic maintenance of rangesum histograms for data updated by additive changes, and we give a (2, 1 + ∊)-approximation that uses space (Blog(N)/∊)O(1) and time (Blog(N)/∊)O(1) for update and query operations. The bounds are nearly competitive with some of the best known bounds for constructing pointwise optimal histograms modulo small additional number of buckets used; however, rangesum histograms are substantially harder to construct because of the long range dependence between subproblems." @default.
- W2294832208 created "2016-06-24" @default.
- W2294832208 creator A5028623121 @default.
- W2294832208 creator A5045502987 @default.
- W2294832208 date "2003-01-12" @default.
- W2294832208 modified "2023-09-24" @default.
- W2294832208 title "Rangesum histograms" @default.
- W2294832208 doi "https://doi.org/10.5555/644108.644148" @default.
- W2294832208 hasPublicationYear "2003" @default.
- W2294832208 type Work @default.
- W2294832208 sameAs 2294832208 @default.
- W2294832208 citedByCount "7" @default.
- W2294832208 crossrefType "proceedings-article" @default.
- W2294832208 hasAuthorship W2294832208A5028623121 @default.
- W2294832208 hasAuthorship W2294832208A5045502987 @default.
- W2294832208 hasConcept C11413529 @default.
- W2294832208 hasConcept C115961682 @default.
- W2294832208 hasConcept C121332964 @default.
- W2294832208 hasConcept C127449775 @default.
- W2294832208 hasConcept C134306372 @default.
- W2294832208 hasConcept C154945302 @default.
- W2294832208 hasConcept C159985019 @default.
- W2294832208 hasConcept C192562407 @default.
- W2294832208 hasConcept C199360897 @default.
- W2294832208 hasConcept C204323151 @default.
- W2294832208 hasConcept C2777027219 @default.
- W2294832208 hasConcept C2777984123 @default.
- W2294832208 hasConcept C33923547 @default.
- W2294832208 hasConcept C41008148 @default.
- W2294832208 hasConcept C53533937 @default.
- W2294832208 hasConcept C62520636 @default.
- W2294832208 hasConcept C72319582 @default.
- W2294832208 hasConceptScore W2294832208C11413529 @default.
- W2294832208 hasConceptScore W2294832208C115961682 @default.
- W2294832208 hasConceptScore W2294832208C121332964 @default.
- W2294832208 hasConceptScore W2294832208C127449775 @default.
- W2294832208 hasConceptScore W2294832208C134306372 @default.
- W2294832208 hasConceptScore W2294832208C154945302 @default.
- W2294832208 hasConceptScore W2294832208C159985019 @default.
- W2294832208 hasConceptScore W2294832208C192562407 @default.
- W2294832208 hasConceptScore W2294832208C199360897 @default.
- W2294832208 hasConceptScore W2294832208C204323151 @default.
- W2294832208 hasConceptScore W2294832208C2777027219 @default.
- W2294832208 hasConceptScore W2294832208C2777984123 @default.
- W2294832208 hasConceptScore W2294832208C33923547 @default.
- W2294832208 hasConceptScore W2294832208C41008148 @default.
- W2294832208 hasConceptScore W2294832208C53533937 @default.
- W2294832208 hasConceptScore W2294832208C62520636 @default.
- W2294832208 hasConceptScore W2294832208C72319582 @default.
- W2294832208 hasLocation W22948322081 @default.
- W2294832208 hasOpenAccess W2294832208 @default.
- W2294832208 hasPrimaryLocation W22948322081 @default.
- W2294832208 hasRelatedWork W111111965 @default.
- W2294832208 hasRelatedWork W1524387703 @default.
- W2294832208 hasRelatedWork W1822348499 @default.
- W2294832208 hasRelatedWork W1964482959 @default.
- W2294832208 hasRelatedWork W199677694 @default.
- W2294832208 hasRelatedWork W1996784330 @default.
- W2294832208 hasRelatedWork W1998244781 @default.
- W2294832208 hasRelatedWork W2008931591 @default.
- W2294832208 hasRelatedWork W2021850646 @default.
- W2294832208 hasRelatedWork W2047424291 @default.
- W2294832208 hasRelatedWork W2053075747 @default.
- W2294832208 hasRelatedWork W2080785753 @default.
- W2294832208 hasRelatedWork W2106163100 @default.
- W2294832208 hasRelatedWork W2110557355 @default.
- W2294832208 hasRelatedWork W2120108467 @default.
- W2294832208 hasRelatedWork W2122731071 @default.
- W2294832208 hasRelatedWork W2128869116 @default.
- W2294832208 hasRelatedWork W2133577012 @default.
- W2294832208 hasRelatedWork W2140115873 @default.
- W2294832208 hasRelatedWork W2212047990 @default.
- W2294832208 isParatext "false" @default.
- W2294832208 isRetracted "false" @default.
- W2294832208 magId "2294832208" @default.
- W2294832208 workType "article" @default.