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: 4214
Venue: SIGMOD
Year: 2009
Pagerank: 4.1905499e-05
Overall Rank: 12,324 | 14.35%
DOI: -

Incoming Non-self Citations Over Time

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

Authors

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
13,412	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,195	Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration	2003	VLDB	9.3239483e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
247	On the Computation of Multidimensional Aggregates	1996	VLDB	0.00030923842
5,012	Dynamically Optimizing Queries over Large Scale Data Platforms	2014	SIGMOD	5.7543101e-05
762	Explaining differences in multidimensional aggregates	1999	VLDB	0.00016984985
368	An Array-Based Algorithm for Simultaneous Multidimensional Aggregates	1997	SIGMOD	0.00025508459
9,765	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB	4.2815042e-05
1,547	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	0.00011417795
825	Simultaneous Optimization and Evaluation of Multiple Dimensional Queries	1998	SIGMOD	0.00016171735
9,586	One-pass Data Mining Algorithms in a DBMS with UDFs	2011	SIGMOD	4.31773e-05
3,162	High-Dimensional OLAP: A Minimal Cubing Approach	2004	VLDB	7.4622284e-05
8,580	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB	4.4876382e-05