EOSDIS Alternative Architecture

List of Errata

Terminology for SQL used in the report:

Usage Meaning

SQL Generic query language with core syntax select .. into .. from .. where

SQL-89 The language defined in ANSI X3.168-1989, ìDatabase Language Embedded SQL.î

SQL-92 The language defined in ANSI X3.135-1992, ìDatabase Language SQL.î

SQL-2 An interim name for the second revision to ANSI SQL. SQL2 became SQL-92. Also is written SQL2.

SQL-3 The working name for the third revsion to the original 1986 standard. Work on SQL-3 has been underway since 1992, and the hope is that a standard will be published in 1995 or 1996. Also is written SQL3.

SQL-* The ANSI standard that will follow SQL-3. Used also to denote that standard, augmented with EOSDIS features. This is not to be confused with Oracleís SQL*STAR product.

  • p ES-2, para 3
  • replace ì2+150î with ì2+250 DAACî
  • p 1-10, footnote

    replace ìDistributed Data Archiveîwith ìDistributed Active Archiveî

  • p 3-9, last para
  • replace ìHMSî with ìHSMî
  • p 3-12, code fragment at next to last line
  • insert a comma ì,î after ìSpectrumî
  • p 3-13, code fragment that begins ìselect clip(regrid ..î
  • delete the second ì)î in ìdata))î
  • p 3-13, code fragment at bottom
  • change ìinsert toî to ìinsert intoî
  • p 3-18, third line from bottom
  • delete ODBC
  • p 3-25, 3rd paragraph
  • replace ìInformation Blockî with ìInformation Baseî
  • p 5-3, two lines before section head 5.1.1
  • replace ì(16-Mb to 256-Mb)î with ì(4-Mb to 64-MB)î
  • p 5-4, Table 5-3

    Columns 2 and 3 give the storage capacity at EACH DAAC. The last two

    columns give the costs for BOTH DAACs.

  • p 5-12, sentence before Table 5-11
  • replace ìyields 14î with ìyields 21î
  • p 5-16, Table 5-14, last two rows
  • replace ì5.4.3î with ì5.4.1î (both occurrences)
  • p A2-10, last paragraph
  • replace ìabout how far oneî with ìabout whether oneî
  • replace ìshared memory to 10sî with ìshared memory multiprocessors to 10sî
  • p A2-11, first paragraph

    replace ìIBMís SP2 typifyî with ìIBMís SP2 and Sysplex typifyî

  • p A5-1, paragraph 2
  • delete the paragraph
  • p A5-4, section ìEstimation of the Load ...î
  • delete the section
  • p A5-6, next to last paragraph

    replace ìThis tableî at the start of the paragraph with ìTable A5-2î

    p A5, Tables A5-2, 3, 4, 5, heading of column 7

    replace the ìSî in ìS(0-2)î with the Greek, capital sigma (denoting summation)

  • p A6-2, Table A6-2, next to last row
  • replace ì24.5î in column 3 with ì8.4î