SQL Injection attacks and Cross-Site Scripting attacks are the two most common attacks on web application. Proposed method is a new policy based Proxy Agent, which classifies the request as a scripted request, or query based request, and then, detects the respective type of attack, if any in the request. This method detects both SQL injection attack as well as the Cross-Site Scripting attacks. ...

Migrating applications from conventional to temporal database management technology has received scant mention in the research literature. This paper formally defines three increasingly restrictive notions of upward compatibility which capture properties of a temporal SQL with respect to conventional SQL that, when satisfied, provide for a smooth migration of legacy applications to a temporal s...

Benchmarks are important tools to evaluate systems, as long as their results are transparent, reproducible and they are conducted with due diligence. Today, many SQL-on-Hadoop vendors use the data generators and the queries of existing TPC benchmarks, but fail to adhere to the rules, producing results that are not transparent. As the SQL-on-Hadoop movement continues to gain more traction, it is...

This paper introduces SQL+i, a temporal relational database management system (TRDBMS) whose aim is to incorporate both determinate, indeterminate, and relative temporal facts which may be declared at multiple and even mixed levels of granularity in a uniform, natural, and unambiguous manner. We use the SQL query language as the basis for the SQL+i query language, utilising a temporal algebra w...

IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3 normal form with all relevant data constraints. SQL Generator is an IIS*Case tool t...

IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3 normal form with all relevant data constraints. SQL Generator is an IIS*Case tool t...

Test suites for database applications depend on adequate test data and real-world test faults for success. An automated tool is available that quantifies test data coverage for database queries written in SQL. An automated tool is also available that mimics realworld faults by mutating SQL, however tests have revealed that these simulated faults do not completely represent real-world faults. Th...

Abstract Text-to-SQL is the problem of converting a user question into an SQL query, when and database are given. In this article, we present neural network approach called RYANSQL (Recursively Yielding Annotation Network for SQL) to solve complex tasks cross-domain databases. Statement Position Code (SPC) defined transform nested query set non-nested SELECT statements; sketch-based slot fillin...

Conversational text-to-SQL is designed to translate multi-turn natural language questions into their corresponding SQL queries. Most advanced conversational methods are incompatible with generative pre-trained models (PLMs), such as T5. In this paper, we present a two-stage unified MultI-task Generation frAmework (MIGA) that leverages PLMs’ ability tackle text-to-SQL. the pre-training stage, MI...