scholarly journals SQL query extensions for imprecise questions

2021 ◽  
pp. 101944
Author(s):  
Marie Le Guilly ◽  
Jean-Marc Petit ◽  
Vasile-Marian Scuturici
Keyword(s):  
2021 ◽  
Vol 1873 (1) ◽  
pp. 012065
Author(s):  
Huiran Zhang ◽  
Cheng Zhang ◽  
Rui Hu ◽  
Xi Liu ◽  
Dongbo Dai

Author(s):  
K. T. Sridhar ◽  
M. A. Sakkeer ◽  
Shiju Andrews ◽  
Jimson Johnson
Keyword(s):  

2016 ◽  
Vol 10 (8) ◽  
pp. 11-15
Author(s):  
Yasien Ghallab ◽  
Hager Saleh ◽  
Mohamed Helmy
Keyword(s):  

Author(s):  
Yu Zeng ◽  
Yan Gao ◽  
Jiaqi Guo ◽  
Bei Chen ◽  
Qian Liu ◽  
...  

Neural semantic parsers usually fail to parse long and complicated utterances into nested SQL queries, due to the large search space. In this paper, we propose a novel recursive semantic parsing framework called RECPARSER to generate the nested SQL query layer-by-layer. It decomposes the complicated nested SQL query generation problem into several progressive non-nested SQL query generation problems. Furthermore, we propose a novel Question Decomposer module to explicitly encourage RECPARSER to focus on different components of an utterance when predicting SQL queries of different layers. Experiments on the Spider dataset show that our approach is more effective compared to the previous works at predicting the nested SQL queries. In addition, we achieve an overall accuracy that is comparable with state-of-the-art approaches.


2018 ◽  
Vol 21 ◽  
pp. 81-85
Author(s):  
Henrihs Gorskis

Based on the usage of previously proposed database concepts as mapping point to a database in a domain ontology, the present paper describes the process of constructing SQL queries from them. The proposed database concepts allow for the mapping of domain concept to the source of data from a database. The paper describes the process of traversing the class hierarchy in an ontology for gathering these database concepts and constructing the SQL query. The purpose of the constructed SQL query is to obtain data from a database to populate the ontology with instances related to a selected ontology concept. The described process begins with the selection of one ontology concept, obtaining all directly related concepts, filtering and collecting database concepts, and finally constructing the SQL query.


2020 ◽  
Vol 4 (1) ◽  
pp. 8-13
Author(s):  
Zulkifli ◽  
Samsir

Kemanan website akses jaringan internet  merupakan hal yang perlu diperhatikan sangat serius. Serangan yang diakibatkan oleh sql injection mampu membobol sistem pertahanan website yang kita miliki jika tidak dilengkapai dengan pengamanan yang kuat.  Mengingat website ini dapat diakses secara luas, maka dinilai perlu memperhatikan keamanan website. Terdapat beberapa cara yang dapat digunakan untuk melakukan pengujian terhadap kemanan website, salah satunya adalah dengan melakukan SQL Injection. SQL injection adalah kerentanan yang terjadi ketika penyerang memiliki kemampuan untuk mempengaruhi Structured Query Language (SQL) query yang melewati suatu aplikasi ke database back-end. Dengan diadakannya penelitian ini, diharapkan dapat diperoleh kelemahan dari website. Kelemahan tersebut akan dianalisa sehingga memperoleh solusi kedepan guna pengembangan website yang lebih aman.


Sign in / Sign up

Export Citation Format

Share Document