A database system can be described as essentially nothing more than a computerized record-keeping system. A database, then, is simply a collection of structured data files and any associated indexes. The user of such a system must be able to add, insert, retrieve, update, and delete data and files as necessary. Although the SQL Standard doesn't actually define the nebulous concept "database", SQL provides all of these functions and more.
In this chapter, we'll briefly discuss SQL's fundamental concepts — how the language fits into its overall environment, the data Objects you can expect to work with, and how SQL-data and SQL statements are structured.
-
Set Theory1
Georg Cantor was a German. He invented Set Theory. He was committed to a me... -
Recap: The Relational Model
A relational database is one which appears to be nothing more than a collec... -
The SQL-environment
The SQL Standard says that all SQL operations are executed within an SQL-en... -
SQL Objects
The SQL Standard describes the concepts on which SQL is based in terms of O... -
SQL Data Types
Every data value belongs to some SQL <data type>. The logical representatio... -
SQL Language Elements
The SQL Standard has numerous rules for such basic issues as what makes a l...