Adding Subqueries to MySQL, or What Does it Take to Have a Decision-Support Engine?

(Antonio Badia, Matt Chanda and Bin Cao) MySQL is an OLTP system without the ability to handle SQL subqueries. As part of our project in query optimization, we add subquery processing to MySQL through rewriting. First, we incorporate the ability to handle subqueries in the FROM clause; then rewr

Read More - Register for Free Membership