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.

Posted by:
Recommended For You close
10 Insights Into NoSQL

Read More »

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 138,000+ IT pros on our weekly newsletter

Resources
Free 30 Day Trial: SolarWinds® Log & Event Manager
Free 30 Day Trial: SolarWinds® Log & Event Manager:
Use this powerful SIEM to tackle compliance audits, perform root cause analysis and manage all logs in one place.
Free 30 Day Trial – VMTurbo Operations Manager
Free 30 Day Trial – VMTurbo Operations Manager:
Handles the scale and complexity of today’s virtual and cloud environments for you, keeping your application owners happy while maximizing...