Term
|
Definition
| The combination of the database, the database system management system, and the application programs that access the database through the database system. |
|
|
Term
|
Definition
| Very large databases that contain both detailed and summarized data for a number of years and that are used for analysis rather than transaction processing. |
|
|
Term
|
Definition
| Accessing information stored in a data warehouse through statistical analysis intellingence techniques to "discover" unhypothesized relationships in the data. |
|
|
Term
|
Definition
| A document that illustrates the arrangement of items of data in input, output, and file records. |
|
|
Term
|
Definition
| The manner in which a user or programmer conceptually organizes, views, and understands the relationships among data items. |
|
|
Term
|
Definition
| A description of the types of data elements that are in the database, the relationships among the data elements, and the structure or overall logical model used to organize and describe the data. |
|
|
Term
|
Definition
| The organization-wide view of the entire database. It lists all data elements in the database and the realtionships between them. Contrast with external-level schema and internal-level schema. |
|
|
Term
|
Definition
| An individual user's or application program's view of a subset of the organization's database. Each of these views is also referred to as a subschema. |
|
|
Term
|
Definition
| (1)A subset of the schema that includes only those data items used in a particular application program or by a particular user. (2) The way the user defines the data and the data relationships. |
|
|
Term
|
Definition
| A low-level view of the entire database describing how the data are actually stored and accessed. It includes information about record layouts, definitions, addresses, indexes and so forth. |
|
|
Term
| data-manipulation language(DML) |
|
Definition
| A database management system language used for data maintenance, which includes such operations as updating, inserting, add deleting portions of the database. |
|
|
Term
| data query language (DQL) |
|
Definition
| A high-level, English-like command language that is used to interrogate a database. The DQL retrieves, sorts orders and presents subsets of the database in response to user queries. |
|
|
Term
|
Definition
| A language that simplifies report creation. Typically, users need only specify which data elements they want printed and how the report should be formatted. |
|
|
Term
|
Definition
| An abstract representation of the contents of a database. |
|
|
Term
|
Definition
| A database model in which all data elements are logically viewed as being stored in the form of two-dimensional tables called "relations". In these tables each row represents a unique entity or record. |
|
|
Term
|
Definition
| The attribute, or combination of attributes, that uniquely identifies a specific row in a database table. The primary key is used to distinguish, order and reference records in a database. |
|
|
Term
|
Definition
| An attribute appearing in one table that is itself the primary key of the table. Foreign keys are used to link tables. |
|
|
Term
|
Definition
| A database management system that uses the relational data model. |
|
|
Term
|
Definition
| The process of following the guidelines for properly designing a relational database that is free from delete,insert,and update anomalies. |
|
|
Term
| database management system (DBMS) |
|
Definition
| The specialized computer program that manages and controls the data and interfaces between the data and the application programs. |
|
|
