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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.