One-pass Data Mining Algorithms in a DBMS with UDFs

Summary: One-pass data mining inside a DBMS using SQL + UDFs; shows SQL-based mining can beat external tools. UDF-driven algorithms process data in a single pass with linear scalability, delivering significantly faster analysis of large datasets. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4537
Venue: SIGMOD
Year: 2011
Pagerank: 5.21582e-05
Overall Rank: 9,804 | 32.74%
DOI: 10.1145/1989323.1989458

Incoming Non-self Citations Over Time

Authors

1. Carlos Ordonez (University of Houston)
2. Sasi K. Pitchaimalai (University of Houston)

BibTeX Citation

@inproceedings{ordonez_sigmod11,
        title = {{One-pass Data Mining Algorithms in a DBMS with UDFs}},
        author = {Ordonez, Carlos and Pitchaimalai, Sasi K.},
        series = {{SIGMOD} '11},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1989323.1989458},
        url = {https://dl.acm.org/doi/10.1145/1989323.1989458},
        year = {2011}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,250	Data Management in Machine Learning: Challenges, Techniques, and Systems	2017	SIGMOD	0.00011485301

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
8,678	Building Statistical Models and Scoring with UDFs	2007	SIGMOD	5.3864318e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,678	Building Statistical Models and Scoring with UDFs	2007	SIGMOD
2	558	An Efficient Algorithm for Mining Association Rules in Large Databases	1995	VLDB
3	14,007	Query Processing Concepts and Techniques to Support Business Intelligence Applications	2002	VLDB
4	5,500	Combi-Operator – Database Support for Data Mining Applications	2003	VLDB
5	9,917	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB
6	12,510	Fast and Dynamic OLAP Exploration Using UDFs	2009	SIGMOD
7	13,626	Data Mining Algorithms as a Service in the Cloud: Exploiting Relational Database Systems	2013	SIGMOD
8	8,096	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB
9	4,273	User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases	2022	VLDB
10	13,712	Database Systems Research on Data Mining	2010	SIGMOD