Improvement of SQL Recommendation on Scientific Database

Query recommendation is critical to assisting first-time users, who may not have the knowledge necessary to know how to issue effective SQL queries, especially in scientific databases. To help users learn how to issue SQL queries, we turn to recommendation. In particular, we consider how to recommend SQL queries and other relevant features to users using nearest-neighbor collaborative filtering. This paper presents Skyrec Summary, an improved summary method which represents the number of resulting tuples queried from each session as an importance rating. The paper adopts SkyServer, an astronomy log dataset, and presents SkyServer Surfliner, a recommender system that supports interactive database exploration, for comparative evaluation of different summary methods. A user study on SkyServer Surfliner shows that Skyrec summary method can quickly provide helpful query recommendations.