• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 20. Client/Server Techniques > Learning the Client/Server Buzzwords

Learning the Client/Server Buzzwords

People who talk about client/server technology use many terms that are unfamiliar to the average database developer. To get a full appreciation of client/server technology and what it offers, you must have at least a general understanding of the terminology. Table 20.1 lists the most commonly used terms.

Table 20.1. Client/server terms.
ColumnA field.
DDLData-definition language used to define and describe the database structure.
Foreign keyA value in one table that must be looked up in another table for validation.
ODBC (Open Database Connectivity)A standard proposed by Microsoft that provides access to a variety of back-end databases through a common interface. In essence, ODBC is a translator.
Primary keyA set of fields that uniquely identify a row.
RowA record.
SchemaBlueprint of the entire database. Includes table definitions, relationships, security, and other important information about the database.
SQL (Structured Query Language)Type of data-manipulation language commonly used to talk to tables residing on a server.
Stored proceduresCompiled SQL statements, such as queries, stored on the database server. Can be called by an application.
TransactionA set of actions that must be performed on a database. If any one action fails, all the actions are discarded.
TriggersPieces of code that execute in response to an action occurring on a table (insert, edit, or delete).



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint