• DocumentCode
    1553069
  • Title

    SQL Test Suite goes online

  • Author

    Sullivan, Joan

  • Author_Institution
    Software Diagnostics & Conformance Testing Div., Nat. Inst. of Stand. & Technol., USA
  • Volume
    30
  • Issue
    6
  • fYear
    1997
  • fDate
    6/1/1997 12:00:00 AM
  • Abstract
    Does your relational database speak SQL fluently? It´s easy to find out, because the SQL (Structured Query Language) Test Suite is now free on the Web. SQL is the standard that lets DBMS products from different vendors interoperate. It defines common data structures (tables, columns, views, and so on) and provides a data manipulation language to populate, update, and query those structures. Accessing structured data with SQL is quite different from searching the full text of documents on the Web. Structured data in the relational model means data that can be represented in tables. Each row represents a different item, and the columns represent various attributes of the item. Columns have names and integrity constraints that specify valid values. Because the column values are named and represented in a consistent format, you can select rows precisely, on the basis of their contents. This is especially helpful in dealing with numeric data. You can also join data from different tables on the basis of matching column values. It is possible to do useful types of analysis too, listing items that are in one table and are missing, present, or have specific attributes in a related table. You can extract from a large table precisely those rows of interest, regroup them, and generate simple statistics on them
  • Keywords
    Internet; SQL; data integrity; factographic databases; information retrieval; relational databases; Internet; SQL Test Suite; Structured Query Language; World Wide Web; common data structures; consistent format; data manipulation language; integrity constraints; numeric data; relational database; relational model; searching; structured data access; ANSI standards; Books; Buildings; Computer science; Databases; ISO standards; Internet; NIST; Testing; User-generated content;
  • fLanguage
    English
  • Journal_Title
    Computer
  • Publisher
    ieee
  • ISSN
    0018-9162
  • Type

    jour

  • DOI
    10.1109/2.587557
  • Filename
    587557