Row (database)

rowsrowrecordrecordsdatabase recorddatabase rowinstanceRecord (database)Record formatrecord in a database
In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a table.wikipedia
87 Related Articles

Relational database

relational database management systemRDBMSrelational databases
In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a table.
This model organizes data into one or more tables (or "relations") of columns and rows, with a unique key identifying each row.

Tuple

tuplesn-tuple5-tuple
In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a 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.
Relational databases may formally identify their rows (records) as tuples.

Table (database)

tabletablesdatabase table
In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a table.
It consists of columns, and rows.

Column (database)

columnscolumnAttribute
In simple terms, a database table can be thought of as consisting of rows and columns.
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.

Data

statistical datascientific datadatum
In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a table.

VAT identification number

P.IVAvalue added tax identification numberVAT number
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.

Relvar

Base relvarrelation variablerelvars
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.

Data type

typedatatypetypes
Each column expects a data value of a particular type.

Identifier

IDidentifiersidentification number
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.

Cent (currency)

centcents¢
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.

Record linkage

Identity resolutionentity resolutionobject identification/entity resolution/record linkage
Record linkage (RL) is the task of finding records in a data set that refer to the same entity across different data sources (e.g., data files, books, websites, and databases).

Database

database management systemdatabasesDBMS
These model data as rows and columns in a series of tables, and the vast majority use SQL for writing and querying data.

Shard (database architecture)

shardingshardedshard
Horizontal partitioning is a database design principle whereby rows of a database table are held separately, rather than being split into columns (which is what normalization and vertical partitioning do, to differing extents).

Data set

datasetdatasetsdata sets
In the case of tabular data, a data set corresponds to one or more database tables, where every column of a table represents a particular variable, and each row corresponds to a given record of the data set in question.

Log trigger

In relational databases, the Log trigger or History trigger is a mechanism for automatic recording of information about changes inserting or/and updating or/and deleting rows in a database table.

Cursor (databases)

Cursorcursorsdatabase cursor
In computer science, a database cursor is a control structure that enables traversal over the records in a database.

Delimiter

delimiter collisiondelimiteddelimit
For example, the CSV file format uses a comma as the delimiter between fields, and an end-of-line indicator as the delimiter between records:

Data vault modeling

Data Vault
This means that every row in a data vault must be accompanied by record source and load date attributes, enabling an auditor to trace values back to the source.

SQL syntax

Case (SQL)statementstwo flavours of conditional expressions

Table (information)

tabletabulartables
Database systems often store data in structures called tables; in which columns are data fields and rows represent data records.

Field (computer science)

fieldsfielddata fields
Relational databases arrange data as sets of database records, also called rows.

Primary key

Alternate keydefining database keykey
In the relational model of databases, a primary key is a specific choice of a minimal set of attributes (columns) that uniquely specify a tuple (row) in a relation (table).