Page 280 - CISSO_Prep_ Guide

Application Security

Terms
▪ Transaction persistence = maintain transaction
across all systems (gives you the ability to roll
back).
▪ Hierarchical DBMS = parent/child relationship,
easy to search.
▪ Network DBMS = hierarchical with a network of
links. Includes records and sets (sets define the
relationship between record types).
▪ Relational DBMS = tables & relationships).
▪ Atomic = every row/column is exactly one
data value.
▪ Columns = attributes or fields.
▪ Rows = tuples or records.
▪ Data Definition Language (DDL) = used to
create and delete database views and
relations.
▪ Manipulation language = used to construct
database queries and modify data.
▪ Entity integrity = Two rules. 1) primary key
cannot be empty; 2) primary key must be
unique.
▪ Referential integrity = every entry in the
foreign key must correspond to an entry in
the primary key of another table.
▪ Deadlocking / deadly embrace = when two
or more processes are waiting for the other
to do something to release a lock.