What is a relational database?
A relational database is a collection of information that organizes data in predefined relationships where data is stored in one or more tables (or "relations") of columns and rows, making it easy to see and understand how different data structures relate to each other. Relationships are a logical connection between different tables, established on the basis of interaction among these tables.
Ready to get started? Create a 90-day Cloud Spanner free trial instance with 10 GB of storage at no cost.
A relational database (RDB) is a way of structuring information in tables, rows, and columns. An RDB has the ability to establish links—or relationships–between information by joining tables, which makes it easy to understand and gain insights about the relationship between various data points.
The relational database model
Examples of relational databases
It’s easy to add, update, or delete tables, relationships, and make other changes to data whenever you need without changing the overall database structure or impacting existing applications.
Relational databases support ACID (Atomicity, Consistency, Isolation, Durability) performance to ensure data validity regardless of errors, failures, or other potential mishaps.
Ease of use
It’s easy to run complex queries using SQL, which enables even non-technical users to learn how to interact with the database.
Multiple people can operate and access data simultaneously. Built-in locking prevents simultaneous access to data when it’s being updated.
Role-based security ensures data access is limited to specific users.
Relational databases employ a design technique known as normalization that reduces data redundancy and improves data integrity.