中文深度万维网结构化数据的搜索-TsinghuaUniversity.ppt

SQL Generation * * SQL Suggestion, ICDE 2011 Precisions on the DBLife data set Query: database Jim Gray Record Retrieval * * SQL Suggestion, ICDE 2011 Precisions on the DBLife data set Query: count author mining Advantages of SQL Suggestion Support aggregation functions Support meta-data matching Efficiency * * SQL Suggestion, ICDE 2011 Efficiency Comparison (DBLife) Scalability * * SQL Suggestion, ICDE 2011 Scalability (DBLP) Outline Motivation Overview of SQL Query Suggestion Queryable Template Suggestion SQL Generation from Templates Experiments Conclusion * * SQL Suggestion, ICDE 2011 Conclusion An effective and user-friendly keyword-based method Assist users to formulate SQL queries Suggest templates relevant to keyword queries Generate SQL queries from templates Extensive experiments * * SQL Suggestion, ICDE 2011 Future Work This study opens many new interesting and challenging problems Cardinality estimation of suggested SQL queries Personalized SQL suggestion * * SQL Suggestion, ICDE 2011 * SQL Suggestion, ICDE 2011 * Thanks Demo: /sqlsugg My Homepage: /fanju Comparison with Existing Work CN-Based Methods Better template ranking SQL Generation Aggregation functions, range queries, etc. * * SQL Suggestion, ICDE 2011 * Modify the list of paper, author, write. * SQL Suggestion, ICDE 2011 SQL Suggestion, ICDE 2011 SQL Suggestion, ICDE 2011 SQL Suggestion, ICDE 2011 SQL Suggestion, ICDE 2011 SQL Suggestion, ICDE 2011 Interactive SQL Query Suggestion Ju Fan, Guoliang Li, and Lizhu Zhou Database Research Group, Tsinghua University ICDE 2011 – Apr. 13, Hanover Making Databases User-Friendly Database Research Group Outline Motivation Overview of SQL Query Suggestion Template Suggestion SQL Generation Experiments Conclusion * * SQL Suggestion, ICDE 2011 Outline Motivation Overview of SQL Query Suggestion Template S