Efficient Implementation of Apriori in SQL Hard to get good performance out of pure SQL (SQL-92) based approaches alone Make use of object-relational extensions like UDFS BLOBs Table functions etc Get orders of magnitude improvement S Sarawagi, s. Thomas, andR. Agrawal. Integrating association rule mining with relational database systems: Alternatives and implications. In SIGMOD98 February 4, 2021 Data Mining: Concepts and Techniques 18February 4, 2021 Data Mining: Concepts and Techniques 18 Efficient Implementation of Apriori in SQL ◼ Hard to get good performance out of pure SQL (SQL-92) based approaches alone ◼ Make use of object-relational extensions like UDFs, BLOBs, Table functions etc. ◼ Get orders of magnitude improvement ◼ S. Sarawagi, S. Thomas, and R. Agrawal. Integrating association rule mining with relational database systems: Alternatives and implications. In SIGMOD’98