Vector and matrix operations programmed with UDFs in a relational DBMS

International Conference on Information and Knowledge Management, Proceedings

Volumn , Issue , 2006, Pages 503-512

  Ordonez, Carlos ^a   García García, Javier ^b  

^a UNIVERSITY OF HOUSTON   (United States)

^b UNIVERSIDAD NACIONAL AUTÓNOMA DE MÉXICO   (Mexico)

Author keywords

Matrix; SQL; UDF; Vector

Indexed keywords

DATA MINING; LEARNING SYSTEMS; MATRIX ALGEBRA; STATISTICAL METHODS; USER INTERFACES; VECTORS;

MATRIX OPERATIONS; MEMORY MANAGEMENT; USER DEFINED FUNCTIONS (UDFS).;

RELATIONAL DATABASE SYSTEMS;

EID: 34547629569     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1183614.1183687     Document Type: Conference Paper

References (18)

1. C. Aggarwal and P. Yu. Finding generalized projected clusters in high dimensional spaces. In A CM SIGMOD Conference,pages 70-81, 2000.
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. J. Clear, D. Dunn, B. Harvey, M.L. Heytens, and P. Lohman. Non-stop SQL/MX primitives for knowledge discovery. In A CM KDD Conference,pages 425-429, 1999.
5. R. Elmasri and S.B. Navathe. Fundamentals of Database Systems.Addison-Wesley, 4th edition, 2003.
6. J. Gehrke, Venkatesh Ganti, and R. Ramakrishnan. Boat-optimistic decision tree construction. In ACM SIGMOD Conference,pages 169-180, 1999.
7. 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.
8. T. Hastie, R. Tibshirani, and J.H. Friedman. The Elements of Statistical Learning.Springer, New York, 1st edition, 2001.
9. S. Manegold, P.A. Boncz, and M.L. Kersten. Optimizing main-memory join on modern hardware. TKDE,14(4):709-730, 2002.
10. 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.
11. C. Ordonez. Horizontal aggregations for building tabular data sets. In ACM DMKD Conference,pages 35-42, 2004.
12. C. Ordonez. Programming the K-means clustering algorithm in SQL. In ACM KDD Conference,pages 823-828, 2004.
13. C. Ordonez. Vertical and horizontal percentage aggregations. In A CM SIGMOD Conference,pages 866-871, 2004.
14. C. Ordonez and P. Cereghini. SQLEM: Fast clustering in SQL using the EM algorithm. In ACM SIGMOD Conference,pages 559-570, 2000.
15. C. Ordonez and E. Omiecinski. FREM: Fast and robust EM clustering for large data sets. In ACM CIKM Conference,pages 590-599, 2002.
16. 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.
17. K. Sattler and O. Dunemann. SQL database primitives for decision tree classifiers. In ACM CIKM Conference,pages 379-386, 2001.
18. 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.