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 you may ignore composite attributes from Lemahieu Chapter 9)
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
scalar reduction