+
Related Flashcards
Related Topics
Cards In This Set
| Front | Back |
|
Field
|
A grouping of characters into a word, a group of words, or a complete number, such as a person's name or age.
|
|
Record
|
A group of related fields.
|
|
File
|
A group of records of the same type.
|
|
Database
|
A group of related files.
|
|
Attribute
|
A piece of information describing a particular entity.
|
|
Key field
|
A field in a record that uniquely identifies instances of that record so that it can be retrieved, updated, or sorted.
|
|
Database (rigorous definition)
|
A collection of data organized to service many applications at the same time by storing and managing data so that they appear to be in one location.
|
|
Database management system (DBMS)
|
Special software to create and maintain a database and enable individual business applications to extract the dataa they need without having to create separate files or data definitions in their computer programs.
|
|
Data definition language
|
The component of a database management system that defines each data element as it appears in the database.
|
|
Structured Query Language (SQL)
|
The standard data manipulation laguage for relational database management systems.
|
|
Data Dictionary
|
An automated or manual tool for storing and organizing information about the data maintained in a database.
|
|
Tuple
|
A row or record in a relational database.
|
|
Data Warehouse
|
A database, with reporting and query tools, that stores current and historical data extracted from various operational systems and consolidated for management reporting and analysis.
|
|
Data mart
|
A small data warehouse containing only a portion of the organization's data for a speciied function or population of users.
|
|
Datamining
|
Analysis of large pools of sdata to find patterns and rules that can be used to guide decisionmaking and predict future behavior.
|
