dbms - cmu db user group

July 30, 2022 · 1 min read · tech, systems

sources

• CMU database group

relational model

Relation is unordered set of tuples. A tuple is a set of attribute values.

primary keys

Synthetic Ids created to identify a tuple. Some dbs autogenerate these keys.

foreign keys:

Defines mapping between two tables.

data manipulation language (dml)

• Procedural
  • The query specifies the strategy to fetch the data.
• Non-Procedural
  • The query only specifies only what data is wanted and not how to find it.