Qex: Symbolic SQL Query Explorer

2010 ◽  
pp. 425-446 ◽  
Author(s):  
Margus Veanes ◽  
Nikolai Tillmann ◽  
Jonathan de Halleux
Keyword(s):  
Sql Query

scholarly journals Unified SQL Query Middleware for Heterogeneous Databases

2021 ◽  
Vol 1873 (1) ◽  
pp. 012065
Author(s):  
Huiran Zhang ◽  
Cheng Zhang ◽  
Rui Hu ◽  
Xi Liu ◽  
Dongbo Dai
Keyword(s):  
Heterogeneous Databases ◽  
Sql Query

SQL query optimization through nested relational algebra

2007 ◽  
Vol 32 (3) ◽  
pp. 18 ◽  
Author(s):  
Bin Cao ◽  
Antonio Badia
Keyword(s):  
Query Optimization ◽  
Relational Algebra ◽  
Sql Query

MPP SQL Query Optimization with RTCG

2018 ◽  
pp. 228-249
Author(s):  
K. T. Sridhar ◽  
M. A. Sakkeer ◽  
Shiju Andrews ◽  
Jimson Johnson
Keyword(s):  
Query Optimization ◽  
Sql Query

scholarly journals Advanced SQL Query To Flink Translator

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

scholarly journals RECPARSER: A Recursive Semantic Parsing Framework for Text-to-SQL Task

2020 ◽  
Author(s):  
Yu Zeng ◽  
Yan Gao ◽  
Jiaqi Guo ◽  
Bei Chen ◽  
Qian Liu ◽  
...  
Keyword(s):  
State Of The Art ◽  
Search Space ◽  
Layer By Layer ◽  
Semantic Parsing ◽  
Query Generation ◽  
Sql Query ◽  
Generation Problem

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.

scholarly journals SQL Query Construction from Ontology Concept Descriptions

2018 ◽  
Vol 21 ◽  
pp. 81-85
Author(s):  
Henrihs Gorskis
Keyword(s):  
Domain Ontology ◽  
Class Hierarchy ◽  
Ontology Concept ◽  
Sql Query ◽  
Mapping Point ◽  
Domain Concept ◽  
Selection Of

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.

scholarly journals Implementasi Sistem Keamanan SQL Injection Dalam berbasis web

2020 ◽  
Vol 4 (1) ◽  
pp. 8-13
Author(s):  
Zulkifli ◽  
Samsir
Keyword(s):  
Query Language ◽  
Sql Injection ◽  
Structured Query Language ◽  
Sql Query

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