Jim Melton
Abstract
Regular readers of this column will have become familiar with database language SQL -- indeed, most readers are already familiar with it. We have also discussed the fact that the SQL standard is being published in multiple parts and have even discussed one of those parts in some detail[l].Another standard, based on SQL and its structured user-defined types[2], has been developed and published by the International Organization for Standardization (ISO). This standard, like SQL, is divided into multiple parts (more independent than the parts of SQL, in fact). Some parts of this other standard, known as SQL/MM, have already been published and are currently in revision, while others are still in preparation for initial publication.In this issue, we introduce SQL/MM and review each of its parts, necessarily at a high level.
- {1} Jim Melton, Jan-Eike Michels, Vanja Josifovski, Krishna, Kulkarni, Peter Schwarz, Kathy Zeidenstein, SQL and Management of External Data, SIGMOD Record, Mar., 2001. Google Scholar
Digital Library
- {2} Jim Melton and Andrew Eisenberg, SQL: 1999, formerly known as SQL3, SIGMOD Record, Feb. 1999.Google Scholar
- {3} ISO/IEC 13249-1:2000, Information technology -- Database languages -- SQL Multimedia and Application Packages -- Part 1: Framework, International Organization for Standardization, 2000.Google Scholar
- {4} ISO/IEC 13249-2:2000, Information technology -- Database languages -- SQL Multimedia and Application Packages -- Part 2: Full-Text, International Organization For Standardization, 2000.Google Scholar
- {5} ISO/IEC 13249-3:1999, Information technology -- Database languages -- SQL Multimedia and Application Packages -- Part 3: Spatial, International Organization For Standardization, 2000.Google Scholar
- {6} ISO/IEC 13249-5:2001, Information technology -- Database languages -- SQL Multimedia and Application Packages -- Part 5: Still Image, International Organization For Standardization, 2001.Google Scholar
- {7} (ISO/IEC) FCD 13249-6, Information technology -- Database languages -- SQL Multimedia and Application Packages -- Part 6: Data Mining. {FCD = Final Committee Draft for ballot}Google Scholar
- {1} National Committee for Information Technology Standards (NCITS): http://www.ncits.orgGoogle Scholar
- {2} NCITS H2 - Database Committee: http://www.ncits.org/tc_home/h2.htmGoogle Scholar
- {3} ISO/IEC JTC 1/SC 32: http://www.jtc1sc32.orgGoogle Scholar
- {4} ANSI's Electronic Standards Store: http://webstore.ansi.orgGoogle Scholar
- {5} NCITS' Standards Store: http://www.cssinfo.com/ncits.htmlGoogle Scholar
- {6} ISO/IEC JTC 1/SC 32 (primarly WG 3, WG 4, and WG 5) archives: ftp://www.sqlstandards.org/SC32/Google Scholar
Recommendations
SQL: 1999, formerly known as SQL3
For several years now, you've been hearing and reading about an emerging standard that everybody has been calling SQL3. Intended as a major enhancement of the current second generation SQL standard, commonly called SQL-92 because of the year it was ...
Comments