Relational Database Management System (RDBMS)

Wikipedia: RDBMS


Relational database management system

From Wikipedia, the free encyclopedia
Jump to: navigation, search
Globe icon.
The examples and perspective in this article may not represent a worldwide view of the subject. Please improve this article and discuss the issue on the talk page.
Question book-new.svg
This article needs additional citations for verification.
Please help improve this article by adding reliable references. Unsourced material may be challenged and removed. (March 2009)
Please help improve this article by expanding it. Further information might be found on the talk page. (March 2009)

A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Most popular commercial and open source databases currently in use are based on the relational database model.

A short definition of an RDBMS may be a DBMS in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables.
Contents
[hide]

* 1 Historical usage of the term
* 2 Market structure
* 3 See also
* 4 External links

[edit] Historical usage of the term

E. F. Codd introduced the term in his seminal paper "A Relational Model of Data for Large Shared Data Banks", published in 1970. 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 systems that were relatively faithful implementations of the relational model were from the University of Michigan; Micro DBMS (1969) and from IBM UK Scientific Centre at Peterlee; IS1 (1970–72) and its followon PRTV (1973–79). The first system sold as an RDBMS was Multics Relational Data Store, first sold in 1978. Others have been Berkeley Ingres QUEL and IBM BS12.

The most popular definition of an RDBMS is a product that presents a view of data as a collection of rows and columns, even if it is not based strictly upon relational theory. By this definition, RDBMS products typically implement some but not all of Codd's 12 rules.

A second, theory-based school of thought argues that if a database does not implement all of Codd's rules (or the current understanding on the relational model, as expressed by Christopher J Date, Hugh Darwen and others), it is not relational. This view, shared by many theorists and other strict adherents to Codd's principles, would disqualify most DBMSs as not relational. For clarification, they often refer to some RDBMSs as Truly-Relational Database Management Systems (TRDBMS), naming others Pseudo-Relational Database Management Systems (PRDBMS).

As of 2009, most commercial relational DBMSes employ SQL as their query language. Alternative query languages have been proposed and implemented, notably the pre-1996 implementation of Berkeley Ingres QUEL. With standardization of the SQL, both commercial and open source DBMSes have adopted some degree of standards compliance.
[edit] Market structure

While relational database systems remain the dominant choice for both transactional and analytical applications, newer structures are competing with RDBMSs in data warehouse applications including column-oriented and correlation database systems.
[edit] See also

* List of relational database management systems
* Comparison of relational database management systems
* Comparison of object-relational database management systems
* Structured Query Language (SQL)
* Life cycle of a relational database
* Navigational Database

[edit] External links

* Database Debunkings - by Fabian Pascal. 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.
* Database Vendors Directory - A list of RDBMS and related products.
* 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.
* Analysis of modern DBMS design Blog by an industry analyst who has become a true-relational skeptic.
* What is the Difference between DBMS and RDBMS? The misconception of the difference between DBMS & RDBMS clarified.

[hide]
v • d • e
Database management systems
Database models · Database normalization · Database storage · Distributed DBMS · Federated database system · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Object-relational database · Transaction processing
Concepts
Database · ACID · CRUD · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key · Armstrong's axioms
Objects
Relation (Table) · View · Transaction · Log · Trigger · Index · Stored procedure · Cursor · Partition
Components
Concurrency control · Data dictionary · JDBC · ODBC · Query language · Query optimizer · Query plan
Database products: Object-oriented (comparison) · Relational (comparison) · Document-oriented
Retrieved from "http://en.wikipedia.org/wiki/Relational_database_management_system"
Categories: Database management systems | Relational model | Relational database management systems
Hidden categories: Articles with limited geographic scope | Articles needing additional references from March 2009 | All articles needing additional references | Articles to be expanded from March 2009 | All articles to be expanded
Personal tools

* New features
* Log in / create account

Namespaces

* Article
* Discussion

Variants

Views

* Read
* Edit
* View history

Actions

Search
Search
Navigation

* Main page
* Contents
* Featured content
* Current events
* Random article

Interaction

* About Wikipedia
* Community portal
* Recent changes
* Contact Wikipedia
* Donate to Wikipedia
* Help

Toolbox

* What links here
* Related changes
* Upload file
* Special pages
* Permanent link
* Cite this page

Print/export

* Create a book
* Download as PDF
* Printable version

Languages

* Deutsch
* Español
* Italiano
* Magyar
* 日本語
* Polski
* Русский
* Српски / Srpski
* Türkçe
* Українська
* Tiếng Việt

* This page was last modified on 9 August 2010 at 06:17.
* Text is available under the Creative Commons Attribution-ShareAlike License; additional terms may apply. See Terms of Use for details.
Wikipedia® is a registered trademark of the Wikimedia Foundation, Inc., a non-profit organization.
* Contact us

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License