What are the advantages and disadvantages of SQL?
What will be an ideal response?
Advantages
? Satisfies ideals for database language
? (Relatively) Easy to learn
? Portability
? SQL standard exists
? Both interactive and embedded access
? Can be used by specialist and non-specialist.
Disadvantages
? Impedance mismatch - mixing programming paradigms with embedded access
? Lack of orthogonality - many different ways to express some queries
? Language is becoming enormous (SQL-92 is 6 times larger than predecessor)
? Handling of nulls in aggregate functions
? Result tables are not strictly relational - can contain duplicate tuples, imposes an ordering on
both columns and rows.
Computer Science & Information Technology