Home : Bits and Bytes : Record Definition

Record

A record is a database entry that may contain one or more values. Groups of records are stored in a table, which defines what types of data each record may contain. Databases may contain multiple tables which may each contain multiple records.

Records are often called rows since each new record creates a new row in the table. Individual fields are sometimes called columns since they are the same for each record within a table. While the words "record" and "row" are often used interchangeably, most DBMSes use the word "row" for database queries and error messages. Therefore, if you see an error message on a website that says "Unable to jump to row 89," for example, it means the record was not found in the database.

Records are an efficient way to store and access data. Since each record may contain multiple data types, a single record may include many different types of information. For example, a personnel record may contain an ID number, name, birthdate, and photo, which are all different data types. Individual fields within the personnel record can be easily accessed or compared with other records using a database query. Additionally, records can be easily created, modified, and deleted without affecting other data in the database.

NOTE: The word "record" is also a verb (pronounced "re-cord"), which means to capture and save audio and/or video data.

Updated: August 25, 2012

Cite this definition:

https://techterms.com/definition/record

TechTerms - The Tech Terms Computer Dictionary

This page contains a technical definiton of Record. It explains in computing terminology what Record means and is one of many computing terms in the TechTerms dictionary.

All definitions on the TechTerms website are written to be technically accurate but also easy to understand. If you find this Record definition to be helpful, you can reference it using the citation links above. If you think a term should be updated or added to the TechTerms dictionary, please email TechTerms!