Table 20.1. Client/Server Terms
|
| Column | A field. |
| DDL | A data definition language used to define and describe the database structure. |
| Foreign key | A value in one table that must be looked up in another table for validation. |
| Jet | The 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. |
| OLEDB | A 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 key | A set of fields that uniquely identifies a row. |
| Row | A record. |
| Schema | A 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 procedures | Compiled SQL statements, such as queries, stored on the database server. Can be called by an application. |
| Transaction | A set of actions that must be performed on a database. If any one action fails, all the actions are discarded. |
| Triggers | Pieces of code that execute in response to an action occurring on a table (insert, edit, or delete). |
لطفا منتظر باشید ...
