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
Link To Document