Building Statistical Models and Scoring with UDFs
Summary: Inside-DBMS computation of multidimensional models (correlation, regression, PCA, clustering) using SQL+UDFs with a single-table scan for building and scoring. Models rely on compact summary matrices (sums, cross-products); aggregate UDFs and scalar UDFs outperform SQL and C++ by avoiding data export. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,645 | A Relational Matrix Algebra and its Implementation in a Column Store | 2020 | SIGMOD | 4.9735157e-05 |
| 9,586 | One-pass Data Mining Algorithms in a DBMS with UDFs | 2011 | SIGMOD | 4.31773e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 13 | Mining Association Rules between Sets of Items in Large Databases | 1993 | SIGMOD | 0.0010863639 |
| 33 | BIRCH: An Efficient Data Clustering Method for Very Large Databases | 1996 | SIGMOD | 0.00077399244 |
| 277 | Automatic Subspace Clustering of High Dimensional Data for Data Mining Applications | 1998 | SIGMOD | 0.00029356968 |
| 454 | An Overview of Query Optimization in Relational Systems | 1998 | PODS | 0.00022796106 |
| 902 | Integrating Association Rule Mining with Relational Database Systems: Alternatives and Implications | 1998 | SIGMOD | 0.00015458733 |
| 1,375 | SQLEM: Fast Clustering in SQL using the EM Algorithm | 2000 | SIGMOD | 0.00012321024 |
| 1,547 | Spreadsheets in RDBMS for OLAP | 2003 | SIGMOD | 0.00011417795 |
| 2,220 | On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS | 1998 | SIGMOD | 9.2614686e-05 |
| 2,689 | BOAT—Optimistic Decision Tree Construction | 1999 | SIGMOD | 8.2965064e-05 |
| 5,078 | Combi-Operator – Database Support for Data Mining Applications | 2003 | VLDB | 5.708568e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 10,469 | UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines | 2025 | SIGMOD | 4.1905499e-05 |
| 13,526 | Database Systems Research on Data Mining | 2010 | SIGMOD | - |
| 6,191 | Accelerating Python UDFs in Vectorized Query Execution | 2022 | CIDR | 5.1598046e-05 |
| 4,022 | Exploiting Correlations for Expensive Predicate Evaluation | 2015 | SIGMOD | 6.5185189e-05 |
| 638 | Towards a Unified Architecture for in-RDBMS Analytics | 2012 | SIGMOD | 0.00018810785 |
| 1,361 | SQL/MapReduce: A practical approach to self-describing, polymorphic, and parallelizable user-defined functions | 2009 | VLDB | 0.00012393719 |
| 9,765 | The UDFBench Benchmark for General-purpose UDF Queries | 2025 | VLDB | 4.2815042e-05 |
| 8,580 | Efficient Execution of User-Defined Functions in SQL Queries | 2023 | VLDB | 4.4876382e-05 |
| 12,324 | Fast and Dynamic OLAP Exploration Using UDFs | 2009 | SIGMOD | 4.1905499e-05 |
| 9,586 | One-pass Data Mining Algorithms in a DBMS with UDFs | 2011 | SIGMOD | 4.31773e-05 |