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...

One of the critical deficiencies of SQL is the lack of support for array and spreadsheet like calculations which are frequent in OLAP and Business Modeling applications. Applications relying on SQL have to emulate these calculations using joins, UNION operations, Window Functions and complex CASE expressions. The designated place in SQL for algebraic calculations is the SELECT clause, which is ...

Monitoring a large number of SQL Servers in an enterprise is a difficult task. The SQL Server administrators have to deal with a large amount of very dynamic and diverse information, and many other complicating factors. We found that the age-old principle of management by exception provides an effective framework in organizing our monitoring efforts. This paper describes our experience in using...

Completely handling SQL injection consists of two activities: properly protecting the system from malicious input, and preventing any resultant error messages caused by SQL injection from revealing sensitive information. The goal of this research is to assess the relative effectiveness of unit and system level testing of web applications to reveal both error message information leak and SQL inj...

In this review, the authors study how a hybrid optomechanical system (OMS), in which quantum micro- or nano-mechanical oscillator is coupled to electromagnetic radiation pressure, consisting of an ensemble ultracold atoms atomic Bose–Einstein condensate, can be used as ultraprecision sensor for measuring very weak signals. As well-known any precise measurement, competition between shot noise an...

Comparing two databases that were upgraded from Sql Server 2008 R2 to Sql Schema & Data Comparison work well when Sql Client is 2012 SP1, but not. Diffing Your Microsoft SQL Server Database Structures It was lightning-fast, taking less than 8 seconds to compare two databases on different servers. SQL server database project creation using Visual Studio 2013, Author: The work is tougher when we ...

Future users of large, interconnected databases and data warehouses will increasingly require schematic transparency of data manipulation systems, in that (i) data from heterogeneous sources must be compared and interrelated and (ii) data must be queried and extracted by distant users having minimal knowledge of its logical structure. A query language that abstracts over meta-data as well as or...