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

Chapter 20. Developing Multiuser and Ent... > 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.
DDLA data 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.
JetThe native database engine used by Microsoft Access.
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.
OLEDBA new standard for connecting to relational and nonrelational data sources.
DAO (Data Access Objects)A method of manipulating data. It is being replaced by ADO and was optimized for accessing Jet databases.
ADO (ActiveX Data Objects)A COM-based object model that allows you to easily manipulate OLE DB data sources. It is the data access methodology that replaces DAO.
Primary keyA set of fields that uniquely identifies a row.
RowA record.
SchemaA blueprint of the entire database. Includes table definitions, relationships, security, and other important information about the database.
SQL (Structured Query Language)A 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