We consider the efficiency of queries generated by XML to SQL translation. We first show that published XML-to-SQL query translation algorithms are suboptimal in that they often translate simple path expressions into complex SQL queries even when much simpler equivalent SQL queries exist. There are two logical ways to deal with this problem. One could generate suboptimal SQL queries using a fai...

Formal specification and verification is required for high security level DBMS in the top level specification design. The specification and verification towards SQL operations is important especially. In this paper, we propose a novel approach to solve the specification and verification issues towards SQL operations. Firstly, we formally define the SQL operations in FTLS; then, we give the defi...

MayBMS [4, 1, 3, 2] is a data management system for incomplete information developed at Saarland University. Its main features are a simple and compact representation system for incomplete information and a language called I-SQL with explicit operations for handling uncertainty. MayBMS is currently an extension of PostgreSQL and manages both complete and incomplete data and evaluates I-SQL quer...

Current search engines can hardly cope adequately with complex preferences. The biggest problem of search engines directly implemented with standard SQL is that SQL does not directly understand the notion of preferences. Preference SQL extends standard SQL by a preference model based on strict partial orders, where preference queries behave like soft selection constraints. A variety of built-in...

Structured Query Language (SQL) is an ANSI and ISO standard declarative query language for querying and manipulating relational databases. It is easy to write SQL queries but very difficult to validate them. Often students conclude that a SQL query is correct simply because the query compiles, executes, and fetches data. Therefore, it is crucial that SQL assessment tasks are carefully designed ...

Among the various types of software vulnerabilities, command injection is the most common type of threat in web applications. In command injection, SQL injection type of attacks are extremely prevalent, and ranked as the second most common form of attack on web. SQL injection attacks involve the construction of application’s input data that will result in the execution of malicious SQL statemen...

Most of the common proposals for temporal extensions of SQL (e.g., ATSQL2 or SQL/Tem-poral) use explicit interval-based references to time (interval attributes). In this paper we propose a diierent approach: we use point-based references to time as a basis for a temporal extension of SQL. The proposed language|SQL/TP|extends the syntax and semantics of SQL/92 in a very natural way: by adding a ...

With the benefit of multimedia and the learning cycle approach in promoting effective active learning, this paper proposed a learning cycle approach–based, multimedia-supplemented instructional unit for Structured Query Language (SQL) for second-year undergraduate students with the aim of enhancing their basic knowledge of SQL and ability to apply SQL to a database. The students were engaged in...