Reverse engineering database queries from examples: State-of-the-art, challenges, and research opportunities

作者：

Highlights：

• A systematic literature review of Query By Example approaches is presented.

• A framework of example acquisition, query learning, query ranking, and feedback strategies.

• Identified QBE applications include data exploration, analytics, integration, and retrieval.

• QBE challenges include minimizing user intervention and considering diverse user preferences.

摘要

•A systematic literature review of Query By Example approaches is presented.•A framework of example acquisition, query learning, query ranking, and feedback strategies.•Identified QBE applications include data exploration, analytics, integration, and retrieval.•QBE challenges include minimizing user intervention and considering diverse user preferences.

论文关键词：Reverse engineering database queries,Databases,Query discovery,Query synthesis,Query learning

论文评审过程：Received 28 February 2018, Revised 10 December 2018, Accepted 4 March 2019, Available online 12 March 2019, Version of Record 14 March 2019.

论文官网地址：https://doi.org/10.1016/j.is.2019.03.002