New standard for stored procedures in SQL

  title={New standard for stored procedures in SQL},
  author={Andrew David Eisenberg},
  journal={SIGMOD Rec.},
In the example above, it is possible that the first insert statement succeeds, and the second insert statement fails due to the failure of a uniqueness constraint. Any partial work of the second insert statement is undone, because SQL considers all DML statements to be atomic. The work of the first statement would not be undone, because the compound statement is a non-atomic statement (as are all of the other flow-of-control statements that will be discussed shortly). PSM-96 provides a second… 

A design and implementation of savepoints and partial rollbacks considering transaction isolation levels of SQL2

The paper considers the correctness of savepoints and partial rollbacks under the circumstances of supporting the four transaction isolation levels of SQL2 and proposes the concept of the mini-savepoint that preserves the atomicity of update operations of the SQL level.

SQL: 1999, formerly known as SQL3

The proposed SQL:1999 is much more than merely SQL-92 plus object technology, and involves additional features that the authors consider to fall into SQL's relational heritage, as well as a total restructuring of the standards documents themselves with an eye towards more effective standards progression in the future.

Using interpreted CompositeCalls to improve operating system services

The CompositeCall pattern is identified which modifies the traditional client/server interaction model so that clients are able to build compound requests that are evaluated in the server domain.

Active Components as a Method for Coupling Data and Services - A Database-Driven Application Development Process

This work proposes an approach where regular database objects containing the data and so-called active components storing metadata about specific services are distinguished, which simplifies the design of highly interactive systems, but also improves the reuse of existing components across different systems.

Handling Iterations in Distributed Dataflow Systems

This survey reviews the research literature and identifies how DDS handle control flow, such as iteration, from both the programming model and execution level perspectives and will be of interest for both users and designers of DDS.

Extending database task schedulers for multi-threaded application code

It is shown that multi-threaded application code can render the database's workload scheduling ineffective and decrease the core throughput of the database by up to 50% and a general approach is presented to address this issue by integrating shared memory programming solutions into the task schedulers of databases.

The New and Improved SQL

This paper gives an overview of the most important new features in SQL:2016.

Tuning an SQL-based PDM system in a worldwide client/server environment

This paper shows how a more sophisticated utilization of the (advanced) SQL features coming along with SQL:1999 can help to cut down response times significantly.

Standards in practice

This column is going to examine the subject of information technology standards in a broader sense, look at some recent notable failures and successes, and attempt to predict how this is likely to shake out in the next few years.

Object Databases : an Analytical Approach

This paper explores reasons as to why object databases, exhibiting the object model, have not gained as much popularity as their programming counterpart while examining issues in definition, motivation, alternatives, performance, benefits, and drawbacks of these systems.


Condition handling in SQL persistent stored modules

Condition handling is a major new feature of SQL/PSM (henceforth referred to as PSM), although the style and comprehensiveness of the specification is still an issue in further progression of the standard.