Database application constitutes one of the largest and most important software domains in the world. Some classes or modules in such applications are responsible for database operations. Structured Query Language (SQL) is used to communicate with database middleware in these classes or modules. It can be issued interactively or embedded in a host language. This paper aims to predict the softwa...

The work reported in this paper is part of a project aimed at designing and prototyping a n application development environment that allows easy development of platform-independen t distributed applications . The main goals of th e database subproject are to investigate methods for (1) providing (SQL) database acces s and (2) supporting transaction managemen t within a distributed programming e...

In this paper, we present a detailed discussion on different SQL injection attacks and their prevention technique. In addition, we proposed a new technique for prevention of SQL injection attack for web application. To address the problems of SQL injections, we proposed a technique that uses a concept of filter called ―Smart Filter‖, that avoid the SQL injections with static matching and dynami...

The SQL Procedure contains many powerful and elegant language features for advanced SQL users. This paper presents SQL topics that will help programmers unlock the many hidden features, options, and other hard-to-find gems found in the SQL universe. Topics include CASE logic; the COALESCE function; SQL statement options _METHOD, _TREE, and other useful options; dictionary tables; automatic macr...

Primary cilia are microtubule-based organelles that have important sensory functions. For their function, cilia rely on the delivery of specific proteins, both by intracellular trafficking and intraflagellar transport (IFT). In the cilia of Caenorhabditis elegans, anterograde IFT is mediated by kinesin-II and OSM-3. Previously, we have shown that expression of a dominant active G protein α subu...

Thousands of organisations store important and confidential information related to them, their customers, and their business partners in databases all across the world. The stored data ranges from less sensitive (e.g. first name, last name, date of birth) to more sensitive data (e.g. password, pin code, and credit card information). Losing data, disclosing confidential information or even chang...

To realise a semantic Web of Things, the challenge of achieving efficient Resource Description Format (RDF) storage and SPARQL query performance on Internet of Things (IoT) devices with limited resources has to be addressed. State-of-the-art SPARQL-to-SQL engines have been shown to outperform RDF stores on some benchmarks. In this paper, we describe an optimisation to the SPARQL-to-SQL approach...

A wide-range of applications, including Publish/Subscribe, Workflow, and Web-site Personalization, require maintaining user’s interest in expected data as conditional expressions. This paper proposes to manage such expressions as data in Relational Database Systems (RDBMS). This is accomplished 1) by allowing expressions to be stored in a column of a database table and 2) by introducing a SQL E...