Encyclopedia > Relational database management system

  Article Content

Relational database management system

A relational database management system is a database management system that is based on the relational model as introduced by Edgar F. Codd. Strictly speaking it should also satisfy Codd's 12 rules[?] but in practice there is no DBMS that satisfies all these rules. In fact, most succesful DMBSs (and the query language SQL) that are considered to be relational violate the relational model in several important ways. However, most database practitioners and researchers use the term in a loose way such that most databases that support SQL are also included.

The first released RDBMS that was a relatively faithful implementation of the relational model was the Multics Relational Data Store, first sold in 1978. Others have been Berkeley Ingres QUEL and IBM BS12.

Today, popular commercial RDBMS's for large databases include Oracle, Microsoft SQL Server, Sybase SQL Server, and IBM's DB2. The most commonly used free RDBMS's are MySQL and PostgreSQL.

Links

  • http://www.dbdebunk.com argues that it is important that the predicate relational should be reserved for those DBMSs that are fully faithful to the relational model. However, this is not common practice.



All Wikipedia text is available under the terms of the GNU Free Documentation License

 
  Search Encyclopedia

Search over one million articles, find something about almost anything!
 
 
  
  Featured Article
French resistance

... Many groups were not enthusiastic at first. When Germans initiated a forced labor draft in France in the beginning of 1943, thousands of young men fled and joined ...

 
 
 
This page was created in 25.6 ms