|
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. Relational databases are the most common kind of database in use today (assuming one does not count a file system as a database).[citation needed] A database management system (DBMS) is computer software designed for the purpose of managing databases. ...
The relational model for database management is a database model based on predicate logic and set theory. ...
Edgar F. Ted Codd (August 23, 1923 - April 18, 2003) was a British computer scientist who made seminal contributions to the theory of relational databases. ...
In computing, a file system (often also written as filesystem) is a method for storing and organizing computer files and the data they contain to make it easy to find and access them. ...
A short definition of a 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.
History 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: A seminal work [semen = seed (from the Latin seminalis)] is a work from which other works come--it is an engendering work which is so important in its ideas or technique that other people take these up and create new works too. ...
Codds 12 rules are a set of thirteen rules proposed by Edgar F. Codd, a pioneer of the relational model for databases, designed to define what is required from a database management system in order for it to be considered relational, i. ...
- 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. Micro was one of the earliest relational database management systems. ...
IS/1 [1] was the worlds first relational database system, implemented at the IBM United Kingdom Scientific Centre in Peterlee in the years 1970-1972. ...
PRTV (Peterlee Relational Test Vehicle [1,2]) was the worlds first relational database management system that could handle significant data volumes -- it was really a relational query system as it had very powerful query facilities, but very limited update facility and no simultaneous multiuser facility. ...
Multics Relational Data Store was the first commercial relational database management system. ...
Year 1978 (MCMLXXVIII) was a common year starting on Sunday (link displays the 1978 Gregorian calendar). ...
This article is about a relational database system. ...
Business System 12, or simply BS12, was one of was the first fully relational database management systems, designed and implemented by IBMs UK Bureau Service subsidiary. ...
The most popular definition of an RDBMS is a product that presents a view of data as a collection of rows and columns not based strictly upon relational theory. The majority of real world popular RDBMS products implement some of Codd's 12 rules. The relational model for database management is a database model based on predicate logic and set theory. ...
Codds 12 rules are a set of thirteen rules proposed by Edgar F. Codd, a pioneer of the relational model for databases, designed to define what is required from a database management system in order for it to be considered relational, i. ...
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 RDBMSs as Truly-Relational Database Management Systems (TRDBMS), naming others Pseudo-Relational Database Management Systems (PRDBMS). Christopher J. Date became involved with Edgar F. Codds relational model for database management while working at IBM. He is the current principal maintainer and developer of the relational model, together with Hugh Darwen. ...
Hugh Darwen, employee of IBM UK from 1967 to 2004, has been involved in the history of the relational model since the beginning. ...
Almost all DBMSes employ SQL as their query language. Alternative query languages have been proposed and implemented, but very few have become commercial products. The related Category:SQL statements has been nominated for deletion, merging, or renaming. ...
Query languages are computer languages used to make queries into databases and information systems. ...
Criticisms | | The neutrality or factuality of this article or section may be compromised by weasel words.
You can help Wikipedia by improving these statements. | Here are criticisms and complaints that can be found with regard to current RDBMS: Image File history File links Unbalanced_scales. ...
- Vendors don't explore optional query languages outside of SQL. Many feel that SQL needs an update or overhaul, being about 30 years old and not being relational in the first place[1].
- They are usually statically-typed. Some feel that dynamically-typed or optional columns may make RDBMS more useful for prototyping or for domains where being nimble in a market is important. (Optional columns are implemented by returning null or blank for columns not defined in a given record.)
- Over-ubiquity — Not all data models require a relational data store, but most developers will pick one up and run with it anyway. As a result, most non-relational DBMS have been starved of development time and innovation.
The related Category:SQL statements has been nominated for deletion, merging, or renaming. ...
See also | Topics in database management systems (DBMS) ( view • talk • edit ) | | Concepts
Database • Database models • Database storage • Relational model • Distributed DBMS • ACID • Null
Relational database • Relational algebra • Relational calculus • Database normalization • Referential integrity • Relational DBMS
Primary key, Foreign key, Surrogate key, Superkey, Candidate key A database management system (DBMS) is computer software designed for the purpose of managing databases. ...
In computing , a database can be defined as a structured collection of records or data that is stored in a computer so that a program can consult it to answer queries. ...
A data model is not just a way of structuring data: it also defines a set of operations that can be performed on the data. ...
Database tables/indexes are typically stored in memory or on hard disk in one of many forms, ordered/unordered Flat files, ISAM, Heaps, Hash buckets or B+ Trees. ...
The relational model for database management is a database model based on predicate logic and set theory. ...
According to Elmasri and Navathe (2004, p. ...
Acidity redirects here. ...
Columns in Relational database management systems (RDBMS) can optionally store NULL values. ...
A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ...
Relational algebra, an offshoot of first-order logic, is a set of relations closed under operators. ...
The relational calculus refers to the two calculi, the tuple calculus and the domain calculus, that are part of the relational model for databases and that provide a declarative way to specify database queries. ...
Database normalization is a design technique for structuring relational database tables. ...
An example of a database that has not enforced referential integrity. ...
In database design, a primary key is a value that can be used to identify a unique row in a table. ...
In the context of relational databases, a foreign key is a referential constraint between two tables[1]. The foreign key identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. ...
A surrogate key is a unique primary key generated by the relational database management system that is not derived from any data in the database and whose only significance is to act as the primary key. ...
A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. ...
In the relational model a candidate key of a relation variable (relvar) is a set of attributes of that relvar such that (1) at all times it holds in the relation assigned to that variable that there are no two distinct tuples with the same values for these attributes and...
| | Objects
Trigger • View • Table • Cursor • Log • Transaction • Index
Stored procedure • Partition A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. ...
In database theory, a view is a virtual or logical table composed of the result set of a query. ...
In relational databases, SQL databases, and flat file databases, a table is a set of data elements (values) that is organized using a model of horizontal rows and vertical columns. ...
In database packages, the term cursor refers to a control structure for the successive traversal (and potential processing) of records in a result set as returned by a query. ...
In in the field of databases in computer science, a transaction log (also database log or binary log) is a history of actions executed by a database management system to guarantee ACID properties over crashes or hardware failures. ...
A database transaction is a unit of interaction with a database management system or similar system that is treated in a coherent and reliable way independent of other transactions that must be either entirely completed or aborted. ...
It has been suggested that Bitmap index be merged into this article or section. ...
A stored procedure is a subroutine available to applications accessing a relational database system. ...
A partition is a division of a logical database or its constituting elements into distinct independent parts. ...
| Topics in SQL
Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop
Begin work • Commit • Rollback • Truncate • Alter The related Category:SQL statements has been nominated for deletion, merging, or renaming. ...
A SELECT statement in SQL returns a result set of records from one or more tables. ...
An SQL INSERT statement adds one or more records to a table in a relational database. ...
An UPDATE statement in SQL changes data in one or more records in a relational database management system. ...
Wikipedia does not have an article with this exact name. ...
A DELETE statement in SQL removes records in a relational database management system. ...
A join combines records from two tables in a relational database and results in a new (temporary) table, also called joined table. ...
In SQL the UNION operator combines the results of two SQL queries into a single table of all matching rows. ...
A CREATE statement in SQL creates an object inside of a relational database management system (RDBMS). ...
A DROP statement in SQL removes an object from a relational database management system (RDBMS). ...
A BEGIN WORK statement in SQL starts a transaction within a relational database management system (RDBMS). ...
A COMMIT statement in SQL ends a transaction within a relational database management system (RDBMS) and makes all changes visible to other users. ...
In database technologies, a rollback is an operation which returns the database to some previous state. ...
The Truncate statement removes all the data from a table. ...
An ALTER statement in SQL changes the properties of an object inside of a relational database management system (RDBMS). ...
| | Implementations of database management systems | | Types of implementations
Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Object relational • Temporal • XML data stores A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ...
A simple diagram depicting conversion of a CSV-format flat file database table into a relational database table. ...
A deductive database system is a database system which can make deductions (ie: infer additional rules or facts) based on rules and facts stored in the (deductive) database. ...
A dimensional database is one which, rather than storing data in multiple two dimensional tables (as a relational databases does), represents key data entities as different dimensions. ...
In a hierarchical data model, data are organized into a tree-like structure. ...
In an object oriented database, information is represented in the form of objects like in object oriented programming. ...
An object-relational database (ORD) or object-relational database management system (ORDBMS) is a relational database management system that allows developers to integrate the database with their own custom data types and methods. ...
A temporal database is a database management system with built-in time aspects, e. ...
In Software engineering, an XML database is a data persistence software system that allows data to be imported, accessed and exported in the XML format. ...
| | Database products
Object-oriented (comparison) • Relational (comparison) The following is a list of object-oriented database management systems. ...
This article or section is not written in the formal tone expected of an encyclopedia article. ...
// 4th Dimension Greenplum CA-Datacom Dataphor Daffodil database EnterpriseDB eXtremeDB DB2 FileMaker Greenplum Helix database Informix InterBase Kognitio, WX2 Linter Matisse Microsoft Jet Database Engine (part of Microsoft Access) Microsoft SQL Server Microsoft Visual FoxPro Mimer SQL mSQL Netezza NonStop SQL Openbase Oracle Oracle Rdb for OpenVMS OpenLink Virtuoso Universal...
The following tables compare general and technical information for a number of relational database management systems. ...
| Components
Query language • Query optimizer • Query plan • ODBC • JDBC Query languages are computer languages used to make queries into databases and information systems. ...
The query optimizer is a component of database management system that is used to analyzes queries submitted to database server for execution, and then determines the optimal way to execute the query. ...
A query plan (or query execution plan) is an set of steps used to access information in a SQL relational database management system. ...
In computing, Open Database Connectivity (ODBC) provides a standard software API method for using database management systems (DBMS). ...
Java Database Connectivity, or JDBC, is an API for the Java programming language that defines how a client may access a database. ...
| The following tables compare general and technical information for a number of relational database management systems. ...
The following tables compare general and technical information for a number of relational database management systems. ...
This article or section is not written in the formal tone expected of an encyclopedia article. ...
Structured Query Language (SQL) is the most popular computer language used to create, modify and query databases. ...
The life cycle of a relational database typically consists of several stages. ...
Navigational databases incorporate both the network model and hierarchical model of database interfaces. ...
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.
|
Feeds |
Contact