SQL Standard - Whitemarsh is SQL Standards, Metabase Software Products and Services to achieve Enterprise Database, through Data Quality, and sound Database Design. (original) (raw)
Key Readings:
SQL 2003 Paper
This is a new paper regarding some of the new features in the SQL 2003 standard, including: new datatypes, enhancements to SQL-invoked routines, extensions to the CREATE TABLE statement, a new MERGE statement, a new schema object - the sequence generator, and two new sorts of columns - identity columns and generated columns
SQL 2003 Documents
This set of files represents an almost indistinguishable delta on the actual SQL 2003 database standard. It was replaced by the 2008 SQL standard. The working draft of SQL documents based on the SQL 2008 Standard are in the next section.
SQL:20nn Working Draft Documents
This points to the documents that are the current set being worked on by SC32, and in the United States, by DM 32.2 (the renamed committee for ANSI INCITS H2 Technical Committee on Database. For those who track names, H2 is the renamed committee for X3H2 that was started in 1978.
SQL Multisets
This SQL standards paper proposes multisets as a new kind of collection type.
WG3 Tutorial
A tutorial about the work and projects of the ISO SC32 WG3 Database Languages Working Group.
Essential Paradigm for IT Standards Success
The effect of SQL database standards and SQL conformance tests on competition and innovation in the digital age is significant. Recent history has shown that without publicly arrived-at, voluntary-consensus standards that are validated through robust and enforced conformance tests, a single dominant market share vendor is able to control its market area. This paper, through examples, identifies the requirements for successful IT standards and clearly identifies the proper role of Government within this community.
Great News, The Relational Model is Dead (159K)
This 24 page paper shows how SQL 1999 standard is clearly NO LONGER relational. Rather it includes aspects of the Codasyl network, hierarchical, and independent logical file data models as well.
SQL Standards:SQL Standard-SQL/XML Functionality: Integration of SQL and XML, sql to XML datatypes, publishing SQL data with XML, mapping SQL data and metadata to XML; and SQL and X-Query: integration of the xquery data model; XML constructor functions, querying XML values. New!!!
IBM's SQL 1999 Presentation
This SQL 1999 standards presentation was created by number of very well respected database researchers from IBM who are on the ANSI and ISO database standards committees. This file was created during the Spring of 1999 and is thus slightly out of synch with the actual SQL 1999 standard. If an updated SQL 1999 presentation becomes available it will be posted. You will notice that I have "borrowed" liberally from IBM's slides for the Whitemarsh SQL 1999 presentations.
Oracle's SQL:1999 Presentation
This additional SQL 1999 standards presentation was created by Jim Melton who is the Editor of the ANSI and ISO database standards committee base documents. This file was created during the Summer of 1999 and is thus more recent, but still slightly out of synch with the actual SQL 1999 standard. Again, if an updated SQL 1999 presentation becomes available it will be posted. You will ALSO notice that I have "borrowed" liberally from IBM's slides for the Whitemarsh SQL 1999 presentations.
DAMA 2000 SQL1999 Talk
From 1986 through 1999, ANSI SQL standards have been based on two-dimensional tables. This made SQL's data model relational, in the main. SQL1999, the new ANSI database languages standard, has dramatically broken from the relational model and has specified complex, nested data structures, its own programming language, Spatial and Full Text processing facilities, and even Codasyl sets.
The purpose of this talk is to review these "new" facilities and to identify the impact they will have on database design, data administration, database administration, and database application development. Finally the talk presents the results of an informal survey among the key vendors as to their SQL1999 implementation directions.
SQL:1999, The Presentation (736K)
This 70+ page presentation presents the materials from the Great News paper and includes overheads that show examples of some of the syntax and data structures possible under SQL 1999. You can get the SQL 1999 standard for a nominal fee from INCITS (International Committee for IT Standards).
SQL1999 Bill of Materials (1.41M)
The SQL 1999 Bill of Materials database application provides both a database of the SQL 1999 standard features. The database unfolds like a set of nested directories and each item includes some level of explanatory text. This software is NOT contained within an installer. You must UnZip the files and place them into a drive and directory of your choice. Once there, you merely execute the program, SQL_BOM.exe. Software items here are 32 bit. They have been tested on Windows 95/98/00 and NT.
Relational Data Model "RIP" overhead (70K)
Presenting SQL 1999. This overhead will be great to use when focusing your screen. Do NOT use this overhead with groups that think that Codd and _od rhyme.
Various SQL Readings:
SQLJ Part 1--SQL Routines
This paper specifies the manner in which SQL routines may be created using the Java programming language.
SQLJ Part 2--SQL Types
This paper specifies the manner in which SQL datatypes may be created using the Java programming language.
SQL and Java FDIS Ballot Document SQL Routines and Types Using the Java Programming Language.
SQL/XML:
(XSQL or SQLX) Standards Papers: