SQL3

Also found in: Dictionary.

SQL3

(database, standard, language)

A draft standard for another extension of SQL. The latest SQL3 Working Draft addresses the requirement for objects and "object identifiers" in SQL and also specifies supporting features such as encapsulation, subtypes, inheritance, and polymorphism.

In the USA, SQL3 is being processed as both an ANSI Domestic ("D") project and as an ISO project. It is expected to be complete in 1998.

November 1992 paper.

Working draft.

[ISO/IEC SQL Revision. ISO-ANSI Working Draft Database Language SQL (SQL3), Jim Melton - Editor, document ISO/IEC JTC1/SC21 N6931, ANSI, July 1992].

This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

Mentioned in ?

References in periodicals archive ?

1995], the goal was to develop a proposal for the SQL/ Temporal part of SQL3 [Snodgrass et al.

Earlier decendants of the work described in this article are the change proposals submitted to the SQL/Temporal part of SQL3 [Snodgrass et al.

Temporal Statement Modifiers

"SQL3 Final Committee Draft Editing Meeting," Database.

Databases as Information Management Tools

We should perhaps emphasize the fact that despite (or perhaps because of) the last point, our model is not what is sometimes referred to as "subtables and supertables." We regard the subtables and supertables idea (which is currently supported in SQL3) as a totally separate phenomenon, one that might be interesting (though we are skeptical) but which has nothing to do with type inheritance per se.

SQL3 Committee Drafts can be found at the SQL website: ftp://jerry.ece.umassd, edu/isowg3/ dbl/BASEdocs/public

Toward a Model of Type Inheritance

Collections of objects in SQL3. In Proceedings of the Nineteenth International Conference on Very Large Data Bases (VLDB '93, Dublin, Ireland, Aug.).

Optimizing Object Queries Using an Effective Calculus

The specification of triggers in SQL:1999 (formerly known as SQL3) has migrated significantly over the years (e.g., see the SQL3 draft descriptions in Widom and Ceri [1996] versus Kulkarni et al.

Earlier versions of the SQL3 draft specified compile-time syntactic restrictions on trigger definition to guarantee termination of trigger execution [Widom and Ceri 1996].

An Algebraic Approach to Static Analysis of Active Database Rules

--Data manipulation events are captured by simple row-level granularity triggers as currently defined in the SQL3 standard; each Chimera-Exc data manipulation event is translated into a corresponding database trigger [Cochrane et al.

Active rules in these systems support basic functionality and are inspired by the forthcoming SQL3 standard [Cochrane et al.

Specification and Implementation of Exceptions in Workflow Management Systems

Finally, we show that the approach is general, by applying it to the temporal query language constructs being proposed for SQL3.

In this section, we consider a variant of TSQL2 that is being proposed for incorporation into the SQL3 standard [Snodgrass et al.