Instead of writing SQL queries directly, programmers often prefer writing all their code in a general purpose programming language like Java and having their programs be automatically rewritten to use database queries. Traditional tools such as object-relational mapping tools are able to automatically translate simple navigational queries written in object-oriented code to SQL. More recently, t...

Declarative technologies have made great strides in expressivity between SQL and SBVR. SBVR models are more expressive that SQL schemas, but not as imminently executable yet. In this paper, we complete the architecture of a system that can execute SBVR models. We do this by describing how SBVR rules can be transformed into SQL DML so that they can be automatically checked against the database u...

Entanglement preparation and signal accumulation are essential for quantum parameter estimation, which pose significant challenges to both theories experiments. Here, we propose how utilize chaotic dynamics in a periodically driven Bose-Josephson system achieving high-precision measurement beyond the standard limit (SQL). Starting from an initial non-entangled state, generates entanglement simu...

Providing a query interface for querying " schema-less " JSON documents using SQL as declarative query language [1] is finally gaining momentum (e.g. [4], [5]). The approach proposed in [2] called JSON SQL, however, represents an alternative approach as it adheres to the following principles: • extends the SQL 92 grammar ([3]) without changing the existing grammar rules, but by strictly adding ...

This paper presents an improvement of the SCMAS architecture aimed at securing SQL-run databases. The main goal of such architecture is the detection and prevention of SQL injection attacks. The improvement consists in the incorporation of unsupervised projection models for the visual inspection of SQL traffic. Through the obtained projections, SQL injection queries can be identified and subseq...

We use constraint technology as a basis for SQL/TP, a sound temporal extension of SQL. In contract to most of the earlier proposals, SQL/TP has clean syntax that is consistent with standard SQL, and unambiguous semantics that is rooted in the theory of constraint databases. We also deene a meaningful way of handling aggregation and duplicates, and provide an eecient implementation path on top o...

Database applications constitute 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...

SQL standard provides SQL/XML publishing functions to publish the result of an SQL query as XML values but it does not provide any SQL/XML publishing function that can publish the result of a recursive SQL query as recursively structured XML values. Therefore, to publish transitively connected relational tuples as recursively structured XML values with the use of appropriate SQL/XML publishing ...

The size of the structured query language (SQL) continuously increases. Extensions of SQL for special domains like stream processing or sensor networks come with own extensions, more or less unrelated to the standard. In general, underlying DBMS support only a subset of SQL plus vendor specific extensions. In this paper, we analyze application domains where special SQL dialects are needed or ar...