Fast and Dynamic OLAP Exploration Using UDFs

Summary: OLAP exploration inside a modern DBMS using standard SQL and UDFs, eliminating the need for external OLAP servers or data export. Evaluates plain SQL, lattice UDF, and star-cube UDF; UDFs outperform SQL for subcube extraction, enabling integrated OLAP with DBMS security and fault tolerance. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4275
Venue: SIGMOD
Year: 2009
Pagerank: 5.093636e-05
Overall Rank: 12,510 | 14.17%
DOI: 10.1145/1559845.1559989

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Zhibo Chen (University of Houston)
2. Carlos Ordonez (University of Houston)
3. Carlos Garcia-Alvarado (University of Houston)

BibTeX Citation

@inproceedings{chen_sigmod09,
        title = {{Fast and Dynamic OLAP Exploration Using UDFs}},
        author = {Chen, Zhibo and Ordonez, Carlos and Garcia-Alvarado, Carlos},
        series = {{SIGMOD} '09},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1559845.1559989},
        url = {https://dl.acm.org/doi/10.1145/1559845.1559989},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
13,600	ONTOCUBO: Cube-based Ontology Construction and Exploration	2014	SIGMOD	-

Outgoing Citations (Sorted by Pagerank)

Showing 1 of 1 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
2,496	Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration	2003	VLDB	8.5025699e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	207	On the Computation of Multidimensional Aggregates	1996	VLDB
2	4,481	Dynamically Optimizing Queries over Large Scale Data Platforms	2014	SIGMOD
3	700	Explaining differences in multidimensional aggregates	1999	VLDB
4	324	An Array-Based Algorithm for Simultaneous Multidimensional Aggregates	1997	SIGMOD
5	9,917	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB
6	1,687	Spreadsheets in RDBMS for OLAP	2003	SIGMOD
7	1,107	Simultaneous Optimization and Evaluation of Multiple Dimensional Queries	1998	SIGMOD
8	9,804	One-pass Data Mining Algorithms in a DBMS with UDFs	2011	SIGMOD
9	3,753	High-Dimensional OLAP: A Minimal Cubing Approach	2004	VLDB
10	8,096	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB