:PROPERTIES: :ID: aa5f9771-0f2b-4920-bf43-626f05b470b4 :mtime: 20231010031811 :ctime: 20231010031631 :END: #+title: Database Terms #+filetags: :public:project: * About These are terms related to databases * Terms - Value - Field: A place to hold a value. Also called an *attribute* or a *column*. - Record: A tuple or product type - Schema: A specifcation on how data is stored, as well as some rules/constraints (e.g. air pressure cannot be negative). - Key: The field used to locate a record - Index: A derived structure for quick lookup - Query: lookup information in a database - Update: modify the data - Transaction: An atomic change to data.