ALERT

[FREE DEMO] Deploy Your Enterprise Cloud in Minutes

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.

Techopedia Deals

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