UoCCL - Databases Course

Don't forget to read the recommended chapters of Lemahieu.

UoCCL - Databases Course - Glossary 1 - First half of the course

ACID vs BASE
attribute (field)
backup
Candidate key
Cartesian product
CRUD operations
DBMS, rDBMS, oDBMS, gDBMS
discriminator
entity (E/R diagram)
Equijoin
foreign key
index
intersection
multi-valued attribute (but not a composite attribute)
natural, cross, equi, outer, inner, left, right joins
natural key
predicate
primary Key
project, select, groupby
query
record
referential Integrity
relational, relation (table)
relation - databases, weak relation
relation - maths, ternary relation,
schema
semantic dependence
semi-structured data
SQL
sub-entity
superkey
synthetic key
transaction
tuple (record)
union
update
value
value atomicity
view
weak entity
weak entity and discriminator

Operating Systems/General Glossary

big data (djg definition: too big to fit in main memory/primary store/core)
distributed system
disk drive
filesystem
heap
primary store (main memory) vs secondary store
SSD
volatile

UoCCL - Databases Course - Glossary 2 - Added later to this document

arity (size of a set or length of a list)
one-to-many, many-to-one, one-to-one, many-to-many
transitive, commutative, associative
JSON and or XML (differences are not very important)
key/value pair, key/value store
path-oriented query
identifier, unique identifier
composition (of functions or relations)
domain set and range set of a function
three-valued logic (true/false/null)
regular expression (once lectured in discrete maths)
graph (directed, node/vertice, edge/arc)
serialising (marshalling or pickling) and its inverse
shredded
sharded
OLAP vs OLTP
normal form
fixed-point (as in least fixed-point)
transaction
data redundancy