Interactive SQL query suggestion: Making databases user-friendly

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2011, Pages 351-362

  Fan, Ju ^a   Li, Guoliang ^a   Zhou, Lizhu ^a  

^a TSINGHUA UNIVERSITY   (China)

Author keywords

[No Author keywords available]

Indexed keywords

EFFICIENT METHOD; KEYWORD-BASED METHODS; MATCHINGS; RANKING MODEL; REAL DATA SETS; RELATIONAL DATABASE; SQL QUERY; TEMPLATE-BASED;

USER INTERFACES;

QUERY LANGUAGES;

EID: 79957868733     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2011.5767843     Document Type: Conference Paper

References (23)

1. S. Agrawal, S. Chaudhuri, and G. Das. Dbxplorer: A system for keyword-based search over relational databases. In ICDE, pages 5-16, 2002. (Pubitemid 34278692)
2. G. Bhalotia, A. Hulgeri, C. Nakhe, S. Chakrabarti, and S. Sudarshan. Keyword searching and browsing in databases using banks. In ICDE, pages 431-440, 2002. (Pubitemid 34278752)
3. S. Brin and L. Page. The anatomy of a large-scale hypertextual web search engine. Computer Networks, 30(1-7):107-117, 1998.
4. E. Chu, A. Baid, X. Chai, A. Doan, and J. F. Naughton. Combining keyword search and forms for ad hoc querying of databases. In SIGMOD Conference, pages 349-360, 2009.
5. V. Chvatal. A greedy heuristic for the set-covering problem. Mathematics of Operations Research, 4(3):233235, 1979.
6. R. Fagin, A. Lotem, and M. Naor. Optimal aggregation algorithms for middleware. In PODS, 2001.
7. H. He, H. Wang, J. Yang, and P. S. Yu. Blinks: ranked keyword searches on graphs. In SIGMOD Conference, pages 305-316, 2007. (Pubitemid 47630816)
8. V. Hristidis, L. Gravano, and Y. Papakonstantinou. Efficient ir-style keyword search over relational databases. In VLDB, pages 850-861, 2003.
9. V. Hristidis and Y. Papakonstantinou. Discover: Keyword search in relational databases. In VLDB, pages 670-681, 2002.
10. M. Jayapandian and H. V. Jagadish. Automated creation of a formsbased database query interface. PVLDB, 1(1):695-709, 2008.
11. V. Kacholia, S. Pandit, S. Chakrabarti, S. Sudarshan, R. Desai, and H. Karambelkar. Bidirectional expansion for keyword search on graph databases. In VLDB, pages 505-516, 2005. (Pubitemid 43991029)
12. B. Kimelfeld and Y. Sagiv. Efficiently enumerating results of keyword search over data graphs. Inf. Syst., 33(4-5):335-359, 2008.
13. G. Li, B. C. Ooi, J. Feng, J.Wang, and L. Zhou. Ease: an effective 3-in-1 keyword search method for unstructured, semi-structured and structured data. In SIGMOD Conference, pages 903-914, 2008.
14. G. Li, X. Zhou, J. Feng, and J. Wang. Progressive keyword search in relational databases. In ICDE, 2009.
15. H. Lu, H. C. Chan, and K. K. Wei. A survey on usage of sql. SIGMOD Rec., 22(4):60-65, 1993.
16. C. Lund and M. Yannakakis. On the hardness of approximating minimization problems. J. ACM, 41(5):960-981, 1994.
17. Y. Luo, X. Lin, W. Wang, and X. Zhou. Spark: top-k keyword query in relational databases. In SIGMOD Conference, pages 115-126, 2007. (Pubitemid 47630801)
18. Y. Luo, W. Wang, and X. Lin. Spark: A keyword search engine on relational databases. In ICDE, pages 1552-1555, 2008.
19. S. Tata and G. M. Lohman. Sqak: doing more with keywords. In SIGMOD Conference, pages 889-902, 2008.
20. X. Yang, C. M. Procopiuc, and D. Srivastava. Summarizing relational databases. PVLDB, 2(1):634-645, 2009.
21. C. Zhai. Statistical language models for information retrieval: A critical review. Foundations and Trends in Information Retrieval, 2(3):137-213, 2008.
22. J. Zhang, Z. Peng, S. Wang, and H. Nie. Clascn: Candidate network selection for efficient top- keyword queries over databases. J. Comput. Sci. Technol., 22(2):197-207, 2007. (Pubitemid 46627073)
23. B. Zhou and J. Pei. Answering aggregate keyword queries on relational databases using minimal group-bys. In EDBT, pages 108-119, 2009.