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: h6779816168783469
Venue: VLDB
Year: 2009
Pagerank: 5.1868213e-05
Overall Rank: 9,387 | 36.89%
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
12,255	Efficient Haar+ Synopsis Construction for the Maximum Absolute Error Measure	2018	VLDB	4.9793485e-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
37	Improved Histograms for Selectivity Estimation of Range Predicates	1996	SIGMOD	0.00047731453
103	Selectivity Estimation Without the Attribute Value Independence Assumption	1997	VLDB	0.00033894985
119	Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries	1988	SIGMOD	0.0003137356
138	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00029627449
169	Wavelet-Based Histograms for Selectivity Estimation	1998	SIGMOD	0.00027134723
193	Locally Adaptive Dimensionality Reduction for Indexing Large Time Series Databases	2001	SIGMOD	0.00025648171
222	Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets	1999	SIGMOD	0.00024218831
255	The History of Histograms (abridged)	2003	VLDB	0.00022981861
275	Optimal Histograms with Quality Guarantees	1998	VLDB	0.00022413521
283	Balancing Histogram Optimality and Practicality for Query Result Size Estimation	1995	SIGMOD	0.00022214789
309	Approximate Query Processing Using Wavelets	2000	VLDB	0.00021384073
371	STHoles: A Multidimensional Workload-Aware Histogram	2001	SIGMOD	0.00019829769
448	Histogram-Based Approximation of Set-Valued Query Answers	1999	VLDB	0.00018129161
454	Self-tuning Histograms: Building Histograms Without Looking at Data	1999	SIGMOD	0.00017962189
806	Universality of Serial Histograms	1993	VLDB	0.00013792174
1,741	Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation	1999	VLDB	9.7382372e-05
3,163	REHIST: Relative Error Histogram Construction Algorithms	2004	VLDB	7.5789852e-05
4,272	One-Pass Wavelet Synopses for Maximum-Error Metrics	2005	VLDB	6.6925708e-05
7,512	Compact Histograms for Hierarchical Identifiers	2006	VLDB	5.504973e-05

Semantically Similar Papers

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