ALERT

[WEBINAR] Building a Business-Driven Data Architecture

Record

Definition - What does Record mean?

In relational databases, a record is a group of related data held within the same structure. More specifically, a record is a grouping of fields within a table that reference one particular object. The term record is frequently used synonymously with row.

For example, a customer record may include items, such as first name, physical address, email address, date of birth and gender.

A record is also known as a tuple.

Techopedia explains Record

Tables contain columns and rows that, to simplify, are similar in structure to Microsoft Excel. Relational tables have a very similar but more complex structure, as each table column represents a certain table property.

Let's say there is a table named CUSTOMER_MASTER, which stores basic customer data. It might contain a CUSTOMER_SURNAME column, which is used to store customer surnames. This column may have certain parameters, e.g., each surname must be 30 characters or less and only comprised of alphabetical characters. Thus, each customer surname added to the CUSTOMER_MASTER table must meet these parameters.

However, each complete customer row or record also includes other items, such as first name, physical address, email address, date of birth and gender, etc. Each item is categorized into its designated corresponding column. Thus, each customer row or record is one horizontal line of data that holds a collection of items.

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.