Database

A database is a structured, organized collection of data stored on a computer system. Databases typically store information in multiple linked tables that keep relevant data for each record in dedicated fields. Database management system (DBMS) software maintains the relationships between tables, adds and updates records, and displays data in response to queries.

Most modern databases are relational databases, which link multiple tables together by creating relationships between primary key fields. For example, a business may keep a database that tracks customer information (like their name and email address) in one table, orders in another, and products for sale in a third table. Each record in these tables has a primary key field containing a unique ID that records in other tables can refer to; every order links to the CustomerID for the customer that placed the order and to the ProductID for each product purchased.

Early databases were known as "flat file" databases. These databases kept everything in a single table, like in a spreadsheet.

Looking up information in a database is called a query. Most databases use the structured query language (SQL) standard for queries, which lets you access and update records across multiple tables in a database. For example, a query to a database could display all customers in a particular ZIP code, all orders placed within the past week, or which customers have purchased a specified product more than once.

An SQL query displaying records that meet the search criteria
An SQL query displaying records that meet the search criteria

Databases are used for countless purposes in business, education, healthcare, and government. E-commerce, social media, news sites, and other dynamic websites use databases as a backend to store their content, generating pages containing content from their databases on demand. Finally, while early databases could only handle plain text, modern databases can store other data types like pictures, audio, and video.

Updated April 18, 2023 by Brian P.

quizTest Your Knowledge

An standard bitmap image has what file extension?

A
.BIT
0%
B
.BMP
0%
C
.MAP
0%
D
.IMG
0%
Correct! Incorrect!     View the BMP definition.
More Quizzes →

The Tech Terms Computer Dictionary

The definition of Database 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.