Relation - Row (Tuple, Record, Struct)

Data System Architecture


A row in a relational database can model:

Rows are components of a relation (table). They are located on its X axis.

A row is also known as:

It is a list (ordered collection) of elements of different types. The elements are called field. The fields of all records form the columns

Relational Data Model


The row identifier (rowId) is called a primary key.


Documentation / Reference

Recommended Pages
Relational Data Model
(Relation|Table) - Tabular data

A Relation is a logical data structure composed of tuple (row) attribute (column, field) The following data structure are a relation: a table, a materialized view (query) (store data) a query,...
Card Puncher Data Processing
(Statistics|Machine Learning|Data Mining) - (Unit|Individual|Case|Subject|Observation|Instance|Input)

in Statistics. Each member of a sample is also known as: a unit an individual a case a subject an instance an observation input data Data contains values grouped into variables and observations....
Data System Architecture
Collection - (Tuple|Vector|Row)

A tuple is: a finite list of elements (fields) - It can only contain a specific number of elements. ordered by position that may have different types. and still be completely typesafe. You can...
Data System Architecture
Data Partition - Horizontal

Horizontal partitions cuts the data by row. Vertical partition Partition is what enable parallelism. Do not under partition - Partitioning on columns with only a few values can cause few partitions...
Data System Architecture
Database - Document Database

A document database is a database that can store and retrieve a document (generally a json document) at once. The data unit is generally not the record as in a relational database but the document. ...
Dimensional Data Modeling - Fact

A fact is a row in a fact table and represents an events. A fact table represents a serie of facts. fact In an event driven architecture,...
Form Tabular Data Illustration
How to create a HTML form for tabular data (rows)

This article shows you how to create a HTML form for tabular data (rows)
Data System Architecture
Logical Data Modeling - Entity (Row | Tuple | Member | Unit | Instance )

An entity isone thing which can be distinctly identified. Example: A specific person A specific company A specific group of persons, A specific place, A specific event It's a concept to...
Erd Entity Instance
Logical Data Modeling - Entity Set (Class, Table)

An entity set is a set of entity. An entity set is implemented: in a relational database by a table and an entity by a row in code by a Class and an instance by an object entity of a language...
Data System Architecture
Phantom read/update problem

Phantom problem is a phenomena. A data problem during concurrency update. In the phantom problem, a transaction accesses a relation more than once with the same predicate in the same transaction, but...

Share this page:
Follow us:
Task Runner