Relational database management system

A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Edgar F. Codd.

=History of the term=

Codd introduced the term in his seminal paper [http://www.acm.org/classics/nov95/toc.html A Relational Model of Data for Large Shared Data Banks ]. In this paper and later papers he defined what he meant by relational. One well-known definition of what constitutes a relational database system is Codd s 12 rules. However, many of the early implementations of the relational model did not conform to all of Codd s rules, so the term gradually came to describe a broader class of database systems. At a minimum, these systems:

*presented the data to the user as relations (a presentation in tabular form, i.e. as a collection of tables with each table consisting of a set of rows and columns, can satisfy this property) *provided relational operators to manipulate the data in tabular form

The first 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.

=Current usage=

There is some disagreement about what can or cannot be called a relational DBMS.

The most popular definition of a RDBMS is relatively imprecise; some argue that merely presenting a view of data as a collection of rows and columns is sufficient to qualify as a RDBMS. Typically, products that qualify as a RDBMS under this interpretation implement some of Codd s 12 rules, but most popular database systems do not support them all.

A second school of thought argues that if a database does not implement all of Codd s rules, it is not relational. This view, shared by many theorists and other strict adherents to Codd s principles, would disqualify many database systems from being considered truly relational . In fact, any database that uses the SQL (Structured Query Language) to access and modify data is not an RDBMS under this definition. Advocates of this philosophy refer to systems that follow some but not all of the rules as Pseudo-Relational Database Management Systems (PRDBMS). For clarification, they often refer to RDBMSs that do follow all of the rules as Truly-Relational Database Management Systems (TRDBMS).

Today, almost all databases that are called RDBMSs employ SQL as their query language but alternatives have been proposed and implemented. Alphora s Dataphor is a commercially-available RDBMS that follows all of Codd s rules, and is considered a RDBMS by both groups.

=See also=

*List of SQL database management systems *List of truly relational database management systems *Comparison of SQL database management systems *Comparison of truly relational database management systems

=External links=

*[http://www.dbdebunk.com Database Debunkings] - Critical point of view that argues that it is important that the predicate relational should be reserved for those database systems that are fully faithful to the relational model.

*[http://www.handels.gu.se/epc/archive/00002948/ Are SQL Server, DB2, and Oracle really relational] - An article by Itoi Blomgren, Michiko. (2003)

*[http://www.mountainman.com.au/software/history/ A Brief History of IT Management and the RDBMS] - A brief history of modern RDBMS technology from the operational perspective of information technology management practice.