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 by Per C.

quizTest Your Knowledge

How many bits are in a megabit?

A
One hundred
0%
B
One thousand
0%
C
One million
0%
D
One billion
0%
Correct! Incorrect!     View the Megabit definition.
More Quizzes →

The Tech Terms Computer Dictionary

The definition of Record on this page is an original definition written by the TechTerms.com team. If you would like to reference this page or cite this definition, please use the green citation links above.

The goal of TechTerms.com is to explain computer terminology in a way that is easy to understand. We strive for simplicity and accuracy with every definition we publish. If you have feedback about this definition or would like to suggest a new technical term, please contact us.

Sign up for the free TechTerms Newsletter

How often would you like to receive an email?

You can unsubscribe or change your frequency setting at any time using the links available in each email.

Questions? Please contact us.