Appendix F. Glossary

alias

Another name or term for a table or column.

ANSI

American National Standards Institute.

application

A set of menus, forms, reports, and code that performs a business function using a database.

buffer

An area in memory for editing or execution of SQL.

Cartesian product

The result of not joining tables in the WHERE clause of an SQL statement. When tables in a query are not joined, every row in one table is paired with every row in all other tables.

client

The client is typically a PC, but can be another server that is dependent on another computer for data, services, or processing.

column

A part of a table that has a name and a specific data type.

COMMIT

Makes changes to data permanent.

composite index

An ...

Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.