We propose a new approach to temporal extensions of SQL. Unlike the current proposals, e.g., SQL/Temporal, we use point-based references to time as the basis of our approach. The proposed language| SQL/TP|extends the syntax and semantics of SQL/92 in a very natural way: by adding a single data type to represent a linearly ordered universe of individual time instants. Such an extension allows th...

Formulating SQL queries involving joins is tedious, error-prone, and requires in-depth schema knowledge. We demonstrate a modified version of SQL [2] that does not require specification of table references and joins. The Schema-Free SQL system can expresses queries not supported in keyword-based searches [1]. Unlike Universal Relation approaches, the system is scaleable to large schemas, and it...

This paper introduces the algorithm that MatBase (an intelligent knowledge and database management system prototype) uses for enforcing acyclicities of binary Cartesian function products, characterizes it -proving is complete, sound, optimal, linear- and, besides its pseudocode embedding SQL, also provides an example implementation in standard ANSI-99 SQL MS VBA.

SD-SQL Server is a scalable distributed DBS using internally the SQL Server. The relational tables of SD-SQL Server scale through splits transparently for the application. SD-SQL Server is the only DBS with this capability at present. It constitutes an important step beyond the current technology of a parallel DBMS, long awaited by the users. The splitting and addressing principles of our syste...

1 Abstract Masque is a powerful and portable natural language front-end for Prolog databases. It answers written English questions by generating Prolog queries, which are evaluated against the Prolog database. This paper describes a modiied version of Masque, called Masque/sql, which answers English questions by generating and executing SQL code. Masque/sql maintains the full linguistic coverag...

Current database systems supporting recursive SQL impose restrictions on queries such as linearity, and do not implement mutual recursion. In a previous work we presented the language and prototype R-SQL to overcome those drawbacks. Now we introduce a formalization and an implementation of the database system HR-SQL that, in addition to extended recursion, incorporates hypothetical reasoning in...

SQL attacks are growing concerns for the security threats to Web applications. The attackers use the SQL to manipulate the applications and manage to penetrate into the databases underlying the applications. This leads to unauthorized access to the potentially sensitive information. In this paper, we intend to discuss various methods through which SQL injection can be done. Also, we purport the...

Masque is a powerful and portable natural language front-end for Prolog databases. It answers written English questions by generating Prolog queries, which are evaluated against the Prolog database. This paper describes a modi ed version ofMasque, called Masque/sql, which answers English questions by generating and executing SQL code. Masque/sql maintains the full linguistic coverage of the ori...