Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
23 Cards in this Set
- Front
- Back
|
ACID
|
Atomicity, Consistency, Isolation, and Durability.Generally accepted requirements for the relaible processing of transaction in a database setting
|
|
|
Acivity ratio
|
the number of active records divided by the number of records in the file
|
|
|
Alias
|
different users call the same field different names
|
|
|
Atomicity
|
the ACID rule that says that either the entire transaction is completed or no part of it is completed
|
|
|
Attribute
|
synonym for Field
|
|
|
Branch
|
the connection between children and parent(s) in a tree structure
|
|
|
Children
|
lower-level elements in a tree diagram of a data structure that are connected to (i.e., part of) the parent element
|
|
|
Consistency
|
the Acid rule that requires that only valid data be written to the database
|
|
|
Database
|
a structured collection of data stored in a computer system or network
|
|
|
Database Administrator (DBA)
|
has overall responsibility for database administration
|
|
|
Database connector
|
another name for a database driver
|
|
|
database dictionary
|
a collection of all data item names in a database, along with a description of the standardized data representation form of these data items
|
|
|
Database driver
|
software that connects a given application program to a particular DBMS
|
|
|
Database management system (DBMS)
|
computer software and related database that enable a user to create and update, select, and retrieve data, and to generate various outputs and reports
|
|
|
Database model
|
synonym for schema
|
|
|
Database software
|
Software used to store,retrieve, and manipulate data in a database
|
|
|
Data description language (DDL)
|
the DDL is used to define the logical structure of the database (schema)
|
|
|
Data item
|
synonym for field
|
|
|
Data manipulation language (DML)
|
the commands for updating,editing, manipulating, and extracting data from a database
|
|
|
Data Query Language (DQL)
|
a user-friendly language or interface that allows users to request information from a database
|
|
|
Direct-access file
|
each record has a storage location (address) that bears some relationship to the record's key field, allowing direct retrieval of each record in the file
|
|
|
Disk access time
|
the time required for the CPU to retrieve a single block of data from the disk
|
|
|
Durability
|
the acid rule that requires that a transaction isn't undone if the system fails after it is completed
|
