Relational Database Row

From GM-RKB
(Redirected from relational database row)
Jump to navigation Jump to search

A Relational Database Row is a Relational Data Record that represents a single and complete structured dataset item in a Relational Database 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
  • a 2-row array's such as in python source-code:

    from numpy import *

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

    row1=x[0,:]

    row2=x[1,:]



References

2020

  • (Wikipedia, 2020) ⇒ https://en.wikipedia.org/wiki/Row_(database) Retrieved:2020-3-21.
    • In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a table. In simple terms, a database table can be thought of as consisting of rows and columns. [1] Each row in a table represents a set of related data, and every row in the table has the same structure.

      For example, in a table that represents companies, each row would represent a single company. Columns might represent things like company name, company street address, whether the company is publicly held, its VAT number, etc.. In a table that represents the association of employees with departments, each row would associate one employee with one department.

      The implicit structure of a row, and the meaning of the data values in a row, requires that the row be understood as providing a succession of data values, one in each column of the table. The row is then interpreted as a relvar composed of a set of tuples, with each tuple consisting of the two items: the name of the relevant column and the value this row provides for that column.

      Each column expects a data value of a particular type. For example, one column might require a unique identifier, another might require text representing a person's name, another might require an integer representing hourly pay in cents.

  1. "What is a database row?" Cory Janssen, Techopedia, retrieved 27 June 2014

2020