Cisco CloudCenter: Get the Hybrid IT Advantage


Definition - What does Key mean?

A key is a field, or combination of fields, in a database table used to retrieve and sort rows in the table based on certain requirements. Keys are defined to speed up access to data and, in many cases, to create links between different tables.

Techopedia explains Key

Relational databases mostly involve primary and foreign keys. While primary keys enforce entity integrity and hold unique values, foreign keys maintain referential integrity, creating an association between two tables.

A primary key is an attribute (or group of attributes) that is unique for each row in a database table. To qualify as a primary key, a field should not have null values and should be unique for each row. These values must not change or become null during the entire life of the database table. Primary keys with two or more attributes are referred to as composite keys. A surrogate primary key has no descriptive values, while a substitute primary key has descriptive values. A foreign key is a column or a group of columns in a database table that enforces links between data in two tables. It acts as a cross-reference between two tables because it references the primary key of another table, and thus establishing a link between the two.

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.