DBScholar

Back to papers

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)

Paper ID
3987
Venue
SIGMOD
Year
2007
Pagerank
5.3864318e-05
Overall Rank
8,678 | 40.47%
DOI
10.1145/1247480.1247599

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{ordonez_sigmod07,
        title = {{Building Statistical Models and Scoring with UDFs}},
        author = {Ordonez, Carlos},
        series = {{SIGMOD} '07},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1247480.1247599},
        url = {https://dl.acm.org/doi/10.1145/1247480.1247599},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank Citing Paper Year Venue Pagerank
6,514 A Relational Matrix Algebra and its Implementation in a Column Store 2020 SIGMOD 5.8559163e-05
9,804 One-pass Data Mining Algorithms in a DBMS with UDFs 2011 SIGMOD 5.21582e-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.0006567919
31 BIRCH: An Efficient Data Clustering Method for Very Large Databases 1996 SIGMOD 0.00050347119
290 An Overview of Query Optimization in Relational Systems 1998 PODS 0.0002227038
304 Automatic Subspace Clustering of High Dimensional Data for Data Mining Applications 1998 SIGMOD 0.00021917388
980 Integrating Association Rule Mining with Relational Database Systems: Alternatives and Implications 1998 SIGMOD 0.00012844074
1,687 Spreadsheets in RDBMS for OLAP 2003 SIGMOD 0.00010005718
2,002 SQLEM: Fast Clustering in SQL using the EM Algorithm 2000 SIGMOD 9.3312236e-05
2,810 BOAT—Optimistic Decision Tree Construction 1999 SIGMOD 8.0985732e-05
3,036 On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS 1998 SIGMOD 7.8287552e-05
5,500 Combi-Operator – Database Support for Data Mining Applications 2003 VLDB 6.1968585e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,927 In-Database Learning with Sparse Tensors 2018 PODS
2 13,712 Database Systems Research on Data Mining 2010 SIGMOD
3 5,791 Accelerating Python UDFs in Vectorized Query Execution 2022 CIDR
4 3,945 Exploiting Correlations for Expensive Predicate Evaluation 2015 SIGMOD
5 518 Towards a Unified Architecture for in-RDBMS Analytics 2012 SIGMOD
6 1,264 SQL/MapReduce: A practical approach to self-describing, polymorphic, and parallelizable user-defined functions 2009 VLDB
7 9,917 The UDFBench Benchmark for General-purpose UDF Queries 2025 VLDB
8 8,096 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB
9 12,510 Fast and Dynamic OLAP Exploration Using UDFs 2009 SIGMOD
10 9,804 One-pass Data Mining Algorithms in a DBMS with UDFs 2011 SIGMOD