Database Terminology

A database stores information in Tables. Each Table contains Columns and Rows (also referred to as Records) of data. Each Column has a name and a type, e.g., if a column called TagName is used to hold tag names, it would be of type Text.

Columns can also be indexed to improve searches for records e.g., by indexing a column called TagName, a search for a specific tag is greatly improved because of the efficiency added to the database due to the indexing.