Difference between revisions of "Relational database"
Jump to navigation
Jump to search
m (MySQL) |
(Added example (copied from SQL article)) |
||
| (9 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | '''Relational | + | '''Relational databases''' are the most popular [[database]]s. The software manages information in tables, as well as the links between related records in these [[Database table|tables]]. |
| + | "Dr. Edgar Frank Codd invented the relational database while working for IBM in 1970."<ref>[http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.pdf Get It Done With MySQL]</ref> | ||
| + | What an example relational database table looks like: | ||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | ! customer_id !! last_name !! first_name !! city | ||
| + | |- | ||
| + | | 10039 || Smith || John || Huston | ||
| + | |- | ||
| + | | 10178 || Cole || Christen || Wortham | ||
| + | |- | ||
| + | | 10052 || Franks || Andrew || Austin | ||
| + | |- | ||
| + | | 10131 || Klinfelt || Mark || Thornberry | ||
| + | |- | ||
| + | | 10014 || Franklin || Mary || Austin | ||
| + | |} | ||
| + | |||
| + | |||
| + | ==Well-known Relational Databases== | ||
The most well-known '''relational database management systems''' (RDBMS) are: | The most well-known '''relational database management systems''' (RDBMS) are: | ||
| − | *DB2, developed by IBM, which also formalized the Structured Query Language (SQL) which became the industry standard. | + | *[[DB2]], developed by IBM, which also formalized the Structured Query Language ([[SQL]]) which became the industry standard. |
| − | *Sybase | + | *[[Sybase]] |
| − | *Oracle | + | *[[Oracle]] |
*Microsoft SQL Server | *Microsoft SQL Server | ||
*[[MySQL]] | *[[MySQL]] | ||
| + | |||
| + | ==Notes== | ||
| + | {{reflist}} | ||
| + | |||
| + | [[Category:Software]] | ||
Latest revision as of 21:35, April 21, 2021
Relational databases are the most popular databases. The software manages information in tables, as well as the links between related records in these tables. "Dr. Edgar Frank Codd invented the relational database while working for IBM in 1970."[1]
What an example relational database table looks like:
| customer_id | last_name | first_name | city |
|---|---|---|---|
| 10039 | Smith | John | Huston |
| 10178 | Cole | Christen | Wortham |
| 10052 | Franks | Andrew | Austin |
| 10131 | Klinfelt | Mark | Thornberry |
| 10014 | Franklin | Mary | Austin |
Well-known Relational Databases
The most well-known relational database management systems (RDBMS) are:
- DB2, developed by IBM, which also formalized the Structured Query Language (SQL) which became the industry standard.
- Sybase
- Oracle
- Microsoft SQL Server
- MySQL