Edgar Frank "Ted" Codd (19 August 1923 – 18 April 2003) was an English

computer scientist A computer scientist is a person who is trained in the academic study of computer science. Computer scientists typically work on the theoretical side of computation, as opposed to the hardware side on which computer engineers mainly focus (a ...

who, while working for IBM, invented the

relational model 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 t ...

for

database In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases ...

management, the theoretical basis for

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. A system used to maintain relational databases is a relational database management system (RDBMS). Many relati ...

s and

relational database management system A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relati ...

s. He made other valuable contributions to

computer science Computer science is the study of computation, automation, and information. Computer science spans theoretical disciplines (such as algorithms, theory of computation, information theory, and automation) to Applied science, practical discipli ...

, but the relational model, a very influential general theory of data management, remains his most mentioned, analyzed and celebrated achievement.

Biography

Edgar Frank Codd was born in

Fortuneswell Fortuneswell is a village in Underhill on the Isle of Portland, in Dorset, England. It lies on steeply sloping land on the northern edge of the island, known as Underhill, where Chesil Beach connects the island to the mainland. Adjoining Fortu ...

, on the

Isle of Portland An isle is an island, land surrounded by water. The term is very common in British English. However, there is no clear agreement on what makes an island an isle or its difference, so they are considered synonyms. Isle may refer to: Geography * Is ...

Dorset Dorset ( ; archaically: Dorsetshire , ) is a county in South West England on the English Channel coast. The ceremonial county comprises the unitary authority areas of Bournemouth, Christchurch and Poole and Dorset. Covering an area of , ...

, England. After attending

Poole Grammar School Poole Grammar School (commonly abbreviated to PGS) is a selective, all‐boys grammar school and academy in the coastal town of Poole in Dorset, on the south coast of England. It is a member of the South West Academic Trust (SWAT). The school w ...

, he studied mathematics and

chemistry Chemistry is the scientific study of the properties and behavior of matter. It is a natural science that covers the elements that make up matter to the compounds made of atoms, molecules and ions: their composition, structure, proper ...

Exeter College, Oxford (Let Exeter Flourish) , old_names = ''Stapeldon Hall'' , named_for = Walter de Stapledon, Bishop of Exeter , established = , sister_college = Emmanuel College, Cambridge , rector = Sir Richard Trainor ...

, before serving as a pilot in the

RAF Coastal Command RAF Coastal Command was a formation within the Royal Air Force (RAF). It was founded in 1936, when the RAF was restructured into Fighter, Bomber and Coastal Commands and played an important role during the Second World War. Maritime Aviation ...

during the Second World War, flying

Sunderland Sunderland () is a port city in Tyne and Wear, England. It is the City of Sunderland's administrative centre and in the Historic counties of England, historic county of County of Durham, Durham. The city is from Newcastle-upon-Tyne and is on t ...

s. In 1948, he moved to New York to work for IBM as a mathematical

programmer A computer programmer, sometimes referred to as a software developer, a software engineer, a programmer or a coder, is a person who creates computer programs — often for larger computer software. A programmer is someone who writes/creates ...

. In 1953, angered by Senator

Joseph McCarthy Joseph Raymond McCarthy (November 14, 1908 – May 2, 1957) was an American politician who served as a Republican United States Senate, U.S. Senator from the state of Wisconsin from 1947 until his death in 1957. Beginning in 1950, McCarth ...

, Codd moved to

Ottawa, Ontario Ottawa (, ; Canadian French: ) is the capital city of Canada. It is located at the confluence of the Ottawa River and the Rideau River in the southern portion of the province of Ontario. Ottawa borders Gatineau, Quebec, and forms the core ...

, Canada. In 1957 he returned to the US working for IBM and from 1961 to 1965 pursuing his doctorate in computer science at the

University of Michigan , mottoeng = "Arts, Knowledge, Truth" , former_names = Catholepistemiad, or University of Michigania (1817–1821) , budget = $10.3 billion (2021) , endowment = $17 billion (2021)As o ...

Ann Arbor Anne, alternatively spelled Ann, is a form of the Latin female given name Anna. This in turn is a representation of the Hebrew Hannah, which means 'favour' or 'grace'. Related names include Annie. Anne is sometimes used as a male name in the ...

. Two years later he moved to

San Jose, California San Jose, officially San José (; ; ), is a major city in the U.S. state of California that is the cultural, financial, and political center of Silicon Valley and largest city in Northern California by both population and area. With a 2020 popu ...

, to work at IBM's San Jose Research Laboratory, where he continued to work until the 1980s. He was appointed

IBM Fellow An IBM Fellow is an appointed position at IBM made by IBM's CEO. Typically only four to nine (eleven in 2014) IBM Fellows are appointed each year, in May or June. Fellow is the highest honor a scientist, engineer, or programmer at IBM can achiev ...

in 1976. During the 1990s, his health deteriorated and he ceased work. Codd received the

Turing Award The ACM A. M. Turing Award is an annual prize given by the Association for Computing Machinery (ACM) for contributions of lasting and major technical importance to computer science. It is generally recognized as the highest distinction in compu ...

in 1981, and in 1994 he was inducted as a

Fellow A fellow is a concept whose exact meaning depends on context. In learned or professional societies, it refers to a privileged member who is specially elected in recognition of their work and achievements. Within the context of higher education ...

of the

Association for Computing Machinery The Association for Computing Machinery (ACM) is a US-based international learned society for computing. It was founded in 1947 and is the world's largest scientific and educational computing society. The ACM is a non-profit professional member ...

. Codd died of heart failure at his home in Williams Island, Florida, at the age of 79 on 18 April 2003.Edgar F Codd Passes Away
IBM Research, 2003 Apr 23.

Work

Codd received a PhD in 1965 from the University of Michigan, Ann Arbor, advised by

John Henry Holland John Henry Holland (February 2, 1929 – August 9, 2015) was an American scientist and Professor of psychology and Professor of electrical engineering and computer science at the University of Michigan, Ann Arbor. He was a pioneer in what became ...

. His thesis was about

self-replication Self-replication is any behavior of a dynamical system that yields construction of an identical or similar copy of itself. Biological cells, given suitable environments, reproduce by cell division. During cell division, DNA is replicated and c ...

cellular automata A cellular automaton (pl. cellular automata, abbrev. CA) is a discrete model of computation studied in automata theory. Cellular automata are also called cellular spaces, tessellation automata, homogeneous structures, cellular structures, tessel ...

, extending on work of

von Neumann Von Neumann may refer to: * John von Neumann (1903–1957), a Hungarian American mathematician * Von Neumann family * Von Neumann (surname), a German surname * Von Neumann (crater), a lunar impact crater See also * Von Neumann algebra * Von Ne ...

and showing that a set of eight states was sufficient for universal computation and

construction Construction is a general term meaning the art and science to form objects, systems, or organizations,"Construction" def. 1.a. 1.b. and 1.c. ''Oxford English Dictionary'' Second Edition on CD-ROM (v. 4.0) Oxford University Press 2009 and ...

. His design for a self-replicating computer was implemented only in 2010. In the 1960s and 1970s he worked out his theories of data arrangement, issuing his paper "A Relational Model of Data for Large Shared Data Banks" in 1970, after an internal IBM paper one year earlier. To his disappointment, IBM proved slow to exploit his suggestions until commercial rivals started implementing them. Initially, IBM refused to implement the relational model to preserve revenue from IMS/DB. Codd then showed IBM customers the potential of the implementation of its model, and they in turn pressured IBM. Then IBM included in its

Future Systems Future Systems was a London-based architectural and design practice, formerly headed by Directors Jan Kaplický and Amanda Levete. Future Systems was founded by Kaplický and David Nixon after working with Denys Lasdun, Norman Foster, Renzo ...

project a System R subproject – but put in charge of it developers who were not thoroughly familiar with Codd's ideas, and isolated the team from Codd. As a result, they did not use Codd's own

Alpha Alpha (uppercase , lowercase ; grc, ἄλφα, ''álpha'', or ell, άλφα, álfa) is the first letter of the Greek alphabet. In the system of Greek numerals, it has a value of one. Alpha is derived from the Phoenician letter aleph , whi ...

language but created a non-relational one, SEQUEL. Even so, SEQUEL was so superior to pre-relational systems that it was copied, in 1979, based on pre-launch papers presented at conferences, by

Larry Ellison Lawrence Joseph Ellison (born August 17, 1944) is an 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 ...

, of Relational Software Inc, in his

Oracle Database Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online ...

, which actually reached market before SQL/DS – because of the then-already proprietary status of the original name, SEQUEL had been renamed SQL. Codd continued to develop and extend his relational model, sometimes in collaboration with

Christopher J. Date Chris Date (born 1941) is an independent author, lecturer, researcher, and consultant, specializing in relational database theory. Biography Chris Date attended High Wycombe Royal Grammar School (U.K.) from 1951 to 1958 and received his BA i ...

. One of the normalised forms, the Boyce–Codd normal form, is named after him.

Codd's theorem Codd's theorem states that relational algebra and the domain-independent relational calculus queries, two well-known foundational query languages for the relational model, are precisely equivalent in expressive power. That is, a database query can ...

, a result proven in his seminal work on the relational model, equates the expressive power of

relational algebra In database theory, relational algebra is a 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. The main application of relational algebr ...

and

relational calculus The relational calculus consists of two calculi, the tuple relational calculus and the domain relational calculus, that are part of the relational model for databases and provide a declarative way to specify database queries. The raison d'être ...

. As the relational model started to become fashionable in the early 1980s, Codd fought a sometimes bitter campaign to prevent the term being misused by database vendors who had merely added a relational veneer to older technology. As part of this campaign, he published his 12 rules to define what constituted a relational database. This made his position in IBM increasingly difficult, so he left to form his own consulting company with Chris Date and others. Codd coined the term '' Online analytical processing (OLAP)'' and wrote the "twelve laws of online analytical processing".Providing OLAP to User-Analysts: An IT Mandate by E F Codd, S B Codd and C T Salley, ComputerWorld, 26 July 1993. Controversy erupted, however, after it was discovered that this paper had been sponsored by Arbor Software (subsequently Hyperion, now acquired by Oracle), a conflict of interest that had not been disclosed, and ''

Computerworld ''Computerworld'' (abbreviated as CW) is an ongoing decades old professional publication which in 2014 "went digital." Its audience is information technology (IT) and business technology professionals, and is available via a publication website ...

'' withdrew the paper. In 2004,

SIGMOD SIGMOD is the Association for Computing Machinery's Special Interest Group on Management of Data, which specializes in large-scale data management problems and databases. The annual ACM SIGMOD Conference, which began in 1975, is considered one of ...

renamed its highest prize to the

SIGMOD Edgar F. Codd Innovations Award The ACM SIGMOD Edgar F. Codd Innovations Award is a lifetime research achievement award given by the ACM Special Interest Group on Management of Data, at its yearly flagship conference (also called SIGMOD). According to its homepage, it is given " ...

, in his honour.

Publications

* * * * *

References

External links

* {{DEFAULTSORT:Codd, Edgar F. 1923 births 2003 deaths Database researchers British computer scientists Turing Award laureates IBM employees IBM Fellows IBM Research computer scientists Alumni of Exeter College, Oxford People from San Jose, California University of Michigan alumni People from the Isle of Portland Fellows of the Association for Computing Machinery Cellular automatists People educated at Poole Grammar School People from Aventura, Florida Royal Air Force pilots of World War II Researchers of artificial life

Biography

Work

Publications

See also

References

Further reading

External links