Relational Database Column

A Relational Database Column is a Tuple or a Relational Data Record that corresponds to the transpose of a relational database row.

• AKA: Database Column, Table Column, Column.
• Example(s):
  • columns in a 2-column table:

	Column 1	Column 2
Row 1	Row 1, Column 1	Row 1, Column 2
Row 2	Row 2, Column 1	Row 2, Column 2
Row 3	Row 3, Column 1	Row 3, Column 2

• columns in a 3-row array's such as in python source-code:

  from numpy import *

  x = array([[1, 2, 3], [4, 5, 6]])

  column1=x[:,0]

  column2=x[:,1]

  column2=x[:,2]

• Counter Example(s):
  • a Relational Database Row.
• See: Relational Database, Structured Data, Vector, Array, Database, Datatype, Identifier, Row-Major Order, Flat File Database.

---

---

References

2020

• (Wikipedia, 2020) ⇒ https://en.wikipedia.org/wiki/Column_(database) Retrieved:2020-3-21.
  • In a relational database, a column is a set of data values of a particular simple type, one value for each row of the database. A column may contain text values, numbers, or even pointers to files in the operating system. Some relational database systems allow columns to contain more complex data types; whole documents, images or even video clips are examples. A column can also be called an attribute.

    Each row would provide a data value for each column and would then be understood as a single structured data value. For example, a database that represents company contact information might have the following columns: ID, Company Name, Address Line 1, Address Line 2, City, and Postal Code. More formally, each row can be interpreted as a relvar, composed of a set of tuples, with each tuple consisting of the relevant column and its value, for example, the tuple ('Address 1', '12345 West Example Street').

---