• DocumentCode
    1591311
  • Title

    Can we rely on SQL?

  • Author

    ter Bekke, J.H.

  • Author_Institution
    Dept. of Inf. Syst., Delft Univ. of Technol., Netherlands
  • fYear
    1997
  • Firstpage
    378
  • Lastpage
    383
  • Abstract
    It is important for any data language that it enables many people to derive correct information from a databases in a simple, effective way with predictable performance. In an analysis, is shown that SQL cannot fulfill these essential preconditions. It is caused by insufficient structural semantics of the relational model and the related operations in SQL. This follows from a comparison with results obtained from application of the semantic Xplain data language. The consequences of these shortcomings are an extreme performance degradation and a growing uncertainty among SQL users
  • Keywords
    SQL; query languages; relational algebra; software performance evaluation; software reliability; SQL; Xplain; data language; database operations; incorrect information derivation; performance degradation; relational model; reliability; structural semantics; unpredictable performance; Data models; Degradation; Hardware; Information systems; Modems; Pain; Relational databases; Software performance; Uncertainty; Vehicles;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Database and Expert Systems Applications, 1997. Proceedings., Eighth International Workshop on
  • Conference_Location
    Toulouse
  • Print_ISBN
    0-8186-8147-0
  • Type

    conf

  • DOI
    10.1109/DEXA.1997.617316
  • Filename
    617316