click below
click below
Normal Size Small Size show me how
CUT5 12.2
Computers: Understanding Tech 5e 12.2
Term | Definition |
---|---|
key | An attribute that can be used to identify a set of information and therefore provide a means to search or sort a database. |
primary key | A database field that must contain only unique entries, such as unique ID numbers, so it can be used to locate records quickly. The database designer sets the most important field in a table as the primary key. |
data browsing | An act that involves moving through a database file, examining each record, and looking for information. |
file processing | Retrieving and performing some type of operation on database data. |
query tool | A tool included in database management systems to help users select matching information from within a larger set of data. |
query | A set of instructions that enables users to specify criteria designed to retrieve needed information from a database. |
Structured Query Language (SQL) | A popular query language that enables users to request information from a database. SQL works with most databases, and can bridge communications gaps between different database systems. |
SELECT command | The basic query command in SQL, which asks a database to return records that match specified criteria. |
Query by Example (QBE) | A process in which the user builds a query by selecting one or more tables, adding the fields to display in the results in a query grid, and then entering the entry to match or other criteria in applicable fields. |
joining | A situation in which a query returns data from more than one table by matching data from fields in the specified tables—commonly matching the primary key field in one table with the field holding the same type of data in another table. |
security measures | Methods used in a database management system to protect and safeguard data. |
metadata | Information about the elements in a database that describes the structure, specifications, and purpose of each element. Descriptive metadata also identifies other types of information, such as the metadata for a website. |
data dictionary | A metadata repository that collects the body of metadata for the entire database. |
legacy database | A database that runs using languages, platforms, or models that are no longer supported by an organization’s current database system. |
recovery | Restoration of data. In a database recovery, the database administrator uses the most recent backup, which typically contains the most recent and accurate data. |