Relational database
From open-encyclopedia.com - the free encyclopedia.
A relational database is a database based on the relational model.
Strictly speaking, this means a relational database takes the form of a specific collection of data. The database software that is used to manage the data is called a relational database management system, or RDBMS. (However, common usage doesn't always preserve this distinction.)
See also
Experimental Variations
Dynamic Relational extrapolates the concept of "dynamically-typed programming languages" to relational databases. It includes concepts such as on-the-fly column creation, on-the-fly table creation, and perhaps could double as an OODBMS if entity-designation is optional or not used. Every record has a unique "record ID" or "object ID" that could serve as a primary key if an entity-based one is not available. Typing for columns (designation as numeric, date, etc.) would be optional, but would be stored with the schema instead of per-cell if included. Columns could also be designed as "required" if needed. With enough specification (types, limits, etc.), it could act just like a traditional RDBMS if needed.
External links
- A Relational Model of Data for Large Shared Data Banks: By E. F. Codd
- Relational Database Principles by Colin Ritche. ISBN 0826457134 This is Very Helpful for courses where databases are a course module.
This article was originally based on material from the Free On-line Dictionary of Computing, which is used under the GFDL.
cs:Relační databáze de:Relationale Datenbank fr:Base de données relationnelle nl:Relationele database ja:リレーショナルデータベース pl:Relacyjna baza danych pt:Banco de dados relacional ru:Реляционная база данных
