Building statistical models and scoring with UDFs

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2007, Pages 1005-1016

  Ordonez, Carlos ^a  

^a UNIVERSITY OF HOUSTON   (United States)

Author keywords

DBMS; SQL; Statistical model; UDF

Indexed keywords

DATA MINING; DATA WAREHOUSES; MATHEMATICAL MODELS; PRINCIPAL COMPONENT ANALYSIS; QUERY LANGUAGES; USER INTERFACES;

MULTIDIMENSIONAL STATISTICAL MODELS; SUMMARY MATRICES;

DISTRIBUTED DATABASE SYSTEMS;

EID: 35448943619     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1247480.1247599     Document Type: Conference Paper

References (22)

1. R. Agrawal, J. Gehrke, D. Gunopolos, and P. Raghavan. Automatic subspace clustering of high dimensional data for data mining applications. In ACM SIGMOD Conference, pages 94-105, 1998.
2. R. Agrawal, T. Imielinski, and A. Swami. Mining association rules between sets of items in large databases. In ACM SIGMOD Conference, pages 207-216, 1993.
3. P. Bradley, U. Fayyad, and C. Reina. Scaling clustering algorithms to large databases. In ACM KDD Conference, pages 9-15, 1998.
4. S. Chaudhuri. An overview of query optimization in relational systems. In ACM PODS Conference, pages 84-43, 1998.
5. J. Clear, D. Dunn, B. Harvey, M.L. Heytens, and P. Lohman. Non-stop SQL/MX primitives for knowledge discovery. In ACM KDD Conference, pages 425-429, 1999.
6. R. Elmasri and S. B. Navathe. Fundamentals of Database Systems. Addison/Wesley, Redwood City, California, 3rd edition, 2000.
7. J. Gehrke, Venkatesh Ganti, and R. Ramakrishnan. Boat-optimistic decision tree construction. In ACM SIGMOD Conference, pages 169-180, 1999.
8. A. Ghazal, A. Crolotte, and R. Bhashyam. Outer join elimination in the Teradata RDBMS. In DEXA Conference, pages 730-740, 2004.
9. G. Graefe, U. Fayyad, and S. Chaudhuri. On the efficient gathering of sufficient statistics for classification from large SQL databases. In ACM KDD Conference, pages 204-208, 1998.
10. T. Hastie, R. Tibshirani, and J.H. Friedman. The Elements of Statistical Learning. Springer, New York, 1st edition, 2001.
11. A. Hinneburg, D. Habich, and W. Lehner. Combi-operator-database support for data mining applications. In VLDB Conference, pages 429-439, 2003.
12. M. Jadicke and B. Mitschang. On parallel processing of aggregate and scalar functions in object-relational DBMS. In ACM SIGMOD Conference, pages 379-389, 1998.
13. R. Meo, G. Psaila, and S. Ceri. An extension to SQL for mining association rules. Data Min. Knowl. Discov, 2(2):195-224, 1998.
14. A. Netz, S. Chaudhuri, U. Fayyad, and J. Berhardt. Integrating data mining with SQL databases: OLE DB for data mining. In IEEE ICDE Conference, 2001.
15. C. Ordonez. Integrating K-means clustering with a relational DBMS using SQL. IEEE TKDE, 18(2):188-201, 2006.
16. C. Ordonez and P. Cereghini. SQLEM: Fast clustering in SQL using the EM algorithm. In ACM SIGMOD Conference, pages 559-570, 2000.
17. C. Ordonez and J. García-García. Vector and matrix operations programmed with UDFs in a relational DBMS. In ACM CIKM Conference, 2006.
18. S. Roweis and Z. Ghahramani. A unifying review of linear Gaussian models. Neural Computation, 11:305-345, 1999.
19. S. Sarawagi, S. Thomas, and R. Agrawal. Integrating association rule mining with relational database systems: Alternatives and implications. In ACM SIGMOD Conference, pages 343-354, 1998.
20. K. Sattler and O. Dunemann. SQL database primitives for decision tree classifiers. In ACM CIKM Conference, pages 379-386, 2001.
21. A. Witkowski, S. Bellamkonda, T. Bozkaya, G. Dorman, N. Folkert, A. Gupta, L. Sheng, and S. Subramanian. Spreadsheets in RDBMS for OLAP. In ACM SIGMOD Conference, pages 52-63, 2003.
22. T. Zhang, R. Ramakrishnan, and M. Livny. BIRCH: An efficient data clustering method for very large databases. In ACM SIGMOD Conference, pages 103-114, 1996.