Difference between revisions of "Relational database"
Jump to navigation
Jump to search
m (Add links) |
(Added example (copied from SQL article)) |
||
| Line 2: | Line 2: | ||
"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> | "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. | ||
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