ALERT

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

Database Column

Definition - What does Database Column mean?

In the context of relational databases, a column is a set of data values, all of a single type, in a table. Columns define the data in a table, while rows populate data into the table.

Most databases also allow columns to contain complex data like images, whole documents, or even video clips. So, a column allowing data values of a single type does not necessarily mean it only has simple text values like. Some databases go even further and allow the data to be stored as a file on the Operating System, while the column data only contains a pointer or link to the actual file. This is done for the purposes of keeping the overall database size manageable -- a smaller database size means less time taken for backups and less time to search for data within the database

Techopedia explains Database Column

A simple example is a table that stores customer information for a bank. The columns in this table may take the form of: Customer Name; Customer Phone Number; Customer Date of Birth; Customer ID; Postal Code; Address; City; ID Number. A row of data will be each horizontal set that contains data for all the columns listed above, one row for each customer. For example Andrew Jones; 134532452; 12-Jun-1970; 4356; 0100; 12 Maple Drive; New York; 657367.

The term “field” is usually used interchangeably with ”column,” but database purists prefer to use the word “field” to denote a particular value or single item of a column. Thus, a field is the intersection of a row and a column. In the bank example above, a field is formed by the intersection of a row with the column “Customer Name” to form “Andrew Jones”. However, this distinction is ignored by most.

Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
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.