What were the original purposes of SQL, and does SQL as we know it today live up to those standards?
What will be an ideal response?
The following were the original purposes of SQL:
1. To specify the syntax and semantics of SQL data definition and manipulation languages
2. To define the data structures and basic operations for designing, accessing, maintaining, controlling, and protecting an SQL database
3. To provide a vehicle for portability of database definition and application modules between conforming DBMSs
4. To specify both minimal (Level 1 ) and complete (Level 2 ) standards, which permit different degrees of adoption in products
5. To provide an initial standard, although incomplete, that will be enhanced later to include specifications for handling such topics as referential integrity, transaction management, user-defined functions, join operators beyond the equi-join, and national character sets
While SQL as we know it today does have some variants, there is a basic standard which is adhered to. As mentioned in the text, it seems that industry lags behind the standards somewhat. Each vendor has its own set of proprietary features which differ from the standard.
You might also like to view...
Matt is one of those consistently upbeat, optimistic people. He always looks on the bright side of things and sees the glass as half-full, rather than half-empty. These characteristics describe Matt's _____.
Fill in the blank(s) with the appropriate word(s).
Explain the eight-step traditional, analytical model of decision-making
What will be an ideal response?