A Relational Database is a digital database whose organization is based on the relational model of data, as proposed by E. F. Codd in 1970.1 The various software systems used to maintain relational databases are known as a relational database management system (RDBMS). Virtually all relational database systems use SQL (Structured Query Language) as the language for querying and maintaining the database.1
SQL (Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data where there are relations between different entities/variables of the data. SQL offers two main advantages over older read/write APIs like ISAM or VSAM: first, it introduced the concept of accessing many records with one single command; and second, it eliminates the need to specify how to reach a record, e.g. with or without an index.2
Relational Database Servers
- MariaDB
- SQLite
- LibreOffice Base
- PostgreSQL
- Amazon Relational Database Service (RDS)
- Microsoft SQL Server
Related Topics
- MariaDB : MariaDB Community Server is the open source relational database loved by developers all over the world.
- MySQL : MySQL Community Edition is the freely downloadable version of the world's most popular open source database.
- PostgreSQL : PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloa
- SQLite : SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
- Microsoft SQL Server : Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing.
Books
![]() |
![]() |
Resources
- C.J. Date has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). C.J. is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience.3
- Edgar Frank "Ted" Codd was an English computer scientist who, while working for IBM, invented the relational model for database management, the theoretical basis for relational databases and relational database management systems.4
- Dr. E. F. Codd's 12 rules - For defining a fully relational database
- Joe Celko is an American relational database expert from Austin, Texas. He has participated on the ANSI X3H2 Database Standards Committee, and helped write the SQL-89 and SQL-92 standards. He is the author of a Morgan-Kaufmann series of books on SQL, and over 1200 published articles on SQL and other database topics. He had been a full-time statistician for several years.5
- The History of SQL Standards
Tools
- DataGrip - The Cross-Platform IDE for Databases and SQL - DataGrip, database IDE that is tailored to suit the specific needs of professional SQL developers.
- phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.6