[WEBINAR] Bulletproof: How Today's Business Leaders Stay on Top

Database Row

Definition - What does Database Row mean?

In relational databases, a row is a data record within a table. Each row, which represents a complete record of specific item data, holds different data within the same structure.

A row is occasionally referred to as a tuple.

Techopedia explains Database Row

I've you've used Excel or any other spreadsheet, you have some idea what a table might look like. Relational tables have a very similar but more complex structure, as each table column represents a certain table property.

Let's use an example of a table called CUSTOMER_MASTER that stores basic customer data. It might contain a CUSTOMER_LASTNAME column, which, as the name implies is used to store the last name of customers. 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 (e.g., first name, physical address, e-mail address, date of birth and gender, etc). Like Excel, each item is neatly slotted into designated corresponding columns. Thus, each customer row or record is one horizontal line of data that holds a collection of items.

Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
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.