Skip to main content

Relational Database

A relational database is a type of database that stores data in tabular form (columns and rows). Relational databases are based on the relational data model, thus allowing for a consistent method and language of querying: Structured Query Language (SQL). In relational databases, columns hold attributes of data (such as datatype) and rows hold instances called “records.” Relationships can be defined between tables using rules such as foreign key constraints which declare that a value in one table must come from an existing value in a separate table. Tables can be linked together (related) based on common data to support querying across multiple tables.

Relational DatabaseNoSQL Database
Low flexibility, high structureHigh flexibility, low structure
Effective for data storage on a single serverDesigned for use across distributed systems
Single query language: SQLQuery language specific to product


Further Resources