Optimality and Scalability in Lattice Histogram Construction

Summary: Dynamic-programming to construct an optimal lattice histogram (LH) under a max-error bound. A scalable greedy method delivers near-optimal accuracy with far lower time/space, applicable to space-bounded problems; experiments on real data show strong performance. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10043
Venue: VLDB
Year: 2009
Pagerank: 5.3058708e-05
Overall Rank: 9,209 | 36.82%
DOI: 10.14778/1687627.1687703

Incoming Non-self Citations Over Time

Authors

1. Panagiotis Karras (National University of Singapore)

BibTeX Citation

@article{karras_vldb09,
        title = {{Optimality and Scalability in Lattice Histogram Construction}},
        author = {Karras, Panagiotis},
        journal = {PVLDB},
        series = {{VLDB} '09},
        doi = {10.14778/1687627.1687703},
        url = {https://doi.org/10.14778/1687627.1687703},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
11,957	Efficient Haar+ Synopsis Construction for the Maximum Absolute Error Measure	2018	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
35	Improved Histograms for Selectivity Estimation of Range Predicates	1996	SIGMOD	0.00048481081
101	Selectivity Estimation Without the Attribute Value Independence Assumption	1997	VLDB	0.00034376651
118	Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries	1988	SIGMOD	0.00031922279
136	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00030123303
168	Wavelet-Based Histograms for Selectivity Estimation	1998	SIGMOD	0.00027541029
190	Locally Adaptive Dimensionality Reduction for Indexing Large Time Series Databases	2001	SIGMOD	0.00026105472
213	Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets	1999	SIGMOD	0.00024723025
257	The History of Histograms (abridged)	2003	VLDB	0.00023154793
267	Optimal Histograms with Quality Guarantees	1998	VLDB	0.00022798161
274	Balancing Histogram Optimality and Practicality for Query Result Size Estimation	1995	SIGMOD	0.00022645621
307	Approximate Query Processing Using Wavelets	2000	VLDB	0.00021792475
365	STHoles: A Multidimensional Workload-Aware Histogram	2001	SIGMOD	0.00020041735
435	Histogram-Based Approximation of Set-Valued Query Answers	1999	VLDB	0.000185063
448	Self-tuning Histograms: Building Histograms Without Looking at Data	1999	SIGMOD	0.00018292618
786	Universality of Serial Histograms	1993	VLDB	0.00014053885
1,729	Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation	1999	VLDB	9.908788e-05
3,111	REHIST: Relative Error Histogram Construction Algorithms	2004	VLDB	7.7470414e-05
4,188	One-Pass Wavelet Synopses for Maximum-Error Metrics	2005	VLDB	6.8448865e-05
7,375	Compact Histograms for Hierarchical Identifiers	2006	VLDB	5.6299286e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,819	Space efficiency in Synopsis construction algorithms	2005	VLDB
2	11,632	Data-Independent Space Partitionings for Summaries	2021	PODS
3	4,405	DigitHist: a Histogram-Based Data Summary with Tight Error Bounds	2017	VLDB
4	3,575	Optimal Histograms for Hierarchical Range Queries (Extended Abstract)	2000	PODS
5	9,825	Multiscale Histograms: Summarizing Topological Relations in Large Spatial Datasets	2003	VLDB
6	723	Dynamic Multidimensional Histograms	2002	SIGMOD
7	267	Optimal Histograms with Quality Guarantees	1998	VLDB
8	1,668	Global Optimization of Histograms	2001	SIGMOD
9	5,421	Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms	2015	PODS
10	4,889	Fast Algorithms For Hierarchical Range Histogram Construction	2002	PODS