A report on Edgar F. Codd

English computer scientist who, while working for IBM, invented the relational model for database management, the theoretical basis for relational databases and relational database management systems.

- Edgar F. Codd

22 related topics with Alpha

Overall

Relational database terminology

Relational database

8 links

Relational database terminology
The general structure of a relational database

A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970.

An SQL select statement and its result

Database

7 links

Organized collection of data stored and accessed electronically.

Organized collection of data stored and accessed electronically.

An SQL select statement and its result
Basic structure of navigational CODASYL database model
In the relational model, records are "linked" using virtual keys not stored in the database but defined as needed between the data contained in the records.
Collage of five types of database models
Traditional view of data

The relational model, first proposed in 1970 by Edgar F. Codd, departed from this tradition by insisting that applications should search for data by content, rather than by following links.

Relational model concepts.

Relational model

6 links

Relational model concepts.

The relational model (RM) is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by English computer scientist Edgar F. Codd, where all data is represented in terms of tuples, grouped into relations.

An update anomaly. Employee 519 is shown as having different addresses on different records.

Database normalization

3 links

Process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity.

Process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity.

An update anomaly. Employee 519 is shown as having different addresses on different records.
An insertion anomaly. Until the new faculty member, Dr. Newsome, is assigned to teach at least one course, their details cannot be recorded.
A deletion anomaly. All information about Dr. Giddens is lost if they temporarily cease to be assigned to any courses.

It was first proposed by Edgar F. Codd as part of his relational model.

SQL

4 links

Domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

Domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

SQL was one of the first commercial languages to use Edgar F. Codd’s relational model.

Relational algebra

3 links

Theory that uses algebraic structures with a well-founded semantics for modeling data, and defining queries on it.

Theory that uses algebraic structures with a well-founded semantics for modeling data, and defining queries on it.

The theory was introduced by Edgar F. Codd.

Ellison in 2010

Larry Ellison

1 links

American business magnate and investor who is the co-founder, executive chairman, chief technology officer (CTO) and former chief executive officer (CEO) of the American computer technology company Oracle Corporation.

American business magnate and investor who is the co-founder, executive chairman, chief technology officer (CTO) and former chief executive officer (CEO) of the American computer technology company Oracle Corporation.

Ellison in 2010
Larry Ellison lecturing at the Oracle OpenWorld, San Francisco 2010
Ellison in 2009
Ellison (right) with Secretary of State Mike Pompeo in 2020

While working at Ampex in the early 1970s, he became influenced by Edgar F. Codd's research on relational database design for IBM.

IBM Fellow Donna Dillenberger

IBM Fellow

0 links

Appointed position at IBM made by IBM's CEO.

Appointed position at IBM made by IBM's CEO.

IBM Fellow Donna Dillenberger

Edgar F. Codd (1976)

Codd's 12 rules

2 links

Codd's twelve rules are a set of thirteen rules (numbered zero to twelve) 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.e., a relational database management system (RDBMS).

The one-way street through Fortuneswell.

Fortuneswell

1 links

Village in Underhill on the Isle of Portland, in Dorset, England.

Village in Underhill on the Isle of Portland, in Dorset, England.

The one-way street through Fortuneswell.
The play area of Victoria Gardens.

Edgar F. Codd, invented relational model for databases while working for IBM.