Edgar (TED) CODD, 1923-2003
Commemorative relationship database of the father
Everyone said that Edgar F. CODD (usually known as TED) is a talented person. One of his achievements is to develop a relational data management model in the 1970s - a complex and complete theory of storage and operation of a large number of business data. According to the relational database of CODD, the database has become the foundation of today's enterprises; bank relies on relational databases to track funds; retailers use them to monitor inventory level; human resources department uses them to manage employee accounts; libraries, hospitals and government agencies There are millions of records in which millions of records are stored; in fact, almost all companies in the world are using a certain capacity relationship database. Since CODD announced its theory, the relational database has become an industry with nearly $ 13 billion in industries.
early life
Ted Codd was born in 1923 in a big family in Portland, England, England. He once studied in Oxford University, majoring in mathematics and chemistry, serving in the Royal Air Force during the Second World War. After the Second World War, CODD went to New York and became a mathematics programmer of IBM. The first project made by CODD is to help build an early computer called an optional sequence electronic calculator (SSEC), which is said to have two layers of a city office building.
In the mid-1960s, CODD received a Ph.D. in Computer Science in Michigan University. After that, he transferred to IBM's development laboratory located in San Jose, California, where he began to develop relational data management models (this is a large extent to a model of mathematics).
Improve database
The early computer is too big, too pair, so that it is not widely used in the enterprise. In the 1960s, the computer began to become economically effective and gradually be adopted by the private sector, and many standards and languages were developed specifically for enterprise applications. Two of these are two models for processing data: hierarchical models and relational network models.
In the hierarchy model, the data record is associated with each other in a hierarchy; mainly records at the upper layer, subsequent record types in the lower branch. In the network model, the record set in the layer may belong to two different contained hierarchies in the adjacent upper layer. For these two models, writing query statements to retrieve information requirements to understand the navigation structure of the data itself, so this is a complex task, generally done by specialized programmers.
CODD proposes a new solution. In a series of reports in the 1970 innovative technical papers - "a relational model of data for larding data banks" (Relationship data model of large shared database), CODD recommends that data is independent of hardware. Store, programmers use a non-process language to access data. The key to the CODD solution is to save the data in a simple table consisting of rows and columns (in this table, the columns of similar data interacts each table) instead of saving data in a hierarchy. . According to the idea of CODD, database users or applications do not need to know the data structure to query the data. Soon after the paper issued the paper, CODD released a more detailed guiding principle and put forward 12 principles of its guidance to create relational databases.
After the theoretical disclosure of CODD, it was not adopted immediately by IBM. IBM has made a lot of investment in a hierarchy database called IMS, so it allows other companies and entrepreneurs to consider how to further develop the theory of CODD. The leader of the leader is Larry O Ellison. He has developed the world's first commercial relational database management system in 1977. In the process, a company has founded a company, and later became oracle. the company. The rest is to say is the history of the database. But for TED CODD, history does not stay there. Although until the early 1980s, CODD has been working in IBM, but he also creating a consulting service company with long-term collaborators Chris Date, and until he died this year, CODD has also continued to study And publish an article about the standardization, analysis and data modeling of data.
Learn more about Edgar (TED) CODD www.wikipedia.org/wiki/edgar_f._codd
Article Source: http://www.oracle.com/global/cn/oramag/oRacle/03-jul/index.html? Content.html
