Database Reference
In-Depth Information
Higher software Quality:
SQL brings higher software quality
to the software engineering arena. By using more powerful
SQL statements, than would be possible in traditional high
level languages, the software engineer is likely to produce
shorter code with fewer errors. The descriptive nature of the
language is useful in this regard.
Higher Productivity:
SQL brings higher productivity to
businesses by providing superior database management
features than possible in systems developed with traditional
high-level languages alone. These superior database
management features include the following:
•
Faster access to data
•
Larger files
•
Set-at-a-time access instead of record-by-record access
•
Powerful data aggregation facilities to provide meaningful
end-user information
•
Facilitation of logical views to provide meaningful end-user
information
•
Facilities for the enforcement of data integrity constraints,
independent of application programs
•
Facilities for logically reorganizing data to provide useful
information to end users
•
Facilities for the enforcement of database security constraints
Data Independence:
SQL helps DBMS suites to meet the
objective of data independence, with its associated benefits
(review chapter 1).
Standardization:
SQL facilitates standardization among
competing software development tools, since they all are
forced to support the language.
10.3 Summary and Concluding Remarks
Let us summarize what we have covered in this chapter:
•
SQL is the universe database language. It consists of various
statements for creating and administering a database. These
statements can be classified as DDL statements, DML statement,
and DCL statements.
