E. F. Codd
Home > Oracle Database / Applications Definitions - E. F. Codd
SearchOracle.com Definitions (Powered by WhatIs.com)
EMAIL THIS
LOOK UP TECH TERMS Powered by: WhatIs.com
Search listings for thousands of IT terms:
Browse tech terms alphabetically:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

E. F. Codd


Show me everything on Oracle database design and architecture

DEFINITION - E. F. Codd (Edgar F. "Ted" Codd) formed the concepts for organizing and accessing data that are embodied in the relational database, the predominant approach to data organization in today's business world. Critical of IBM's then current data management systems, Codd, as a young IBM programmer working in IBM's San Jose Research Lab in California in 1970, proposed that data be organized according to principles based on identified relations between various kinds of data. The data itself would be organized in two-dimensional (row and column) tables and specific items in a table could be related to data located in other tables. Codd saw the need to reduce or eliminate redundancy in data and to allow data to be accessed through logical rather than physical identification. One of Codd's key ideas was the process for organizing data into the appropriate number of tables, a process known as normalization.

To access data using this relational model, Codd envisioned a relatively easy-to-use query language based on a foundation of relational set theory. Codd also believed that a database management system should provide a standard access approach so that an application program did not have to be aware of how the data was organized. As a result, IBM in 1982 came out with the first version of what later became the Structured Query Language (SQL).

In 1977, Oracle became the first commercial relational database management system. IBM's DB2 followed in 1981. Retiring from IBM after a serious injury in the early 1980s, Codd had his own consulting group until 1999. He died on April 18, 2003 at his home on Williams Island, Florida.

Learn more about Oracle database design and architecture
Spotlight on Oracle performance tuning: Performance tuning is a key task for any Oracle DBA. This spotlight includes tips and advice to help you meet your tuning challenges and keep users happy.
Oracle database performance tuning guide: Learn the tricks of industry experts for identifying and eliminating perfomance problems in this guide.
RDBMS fundamentals: This learning guide can help you to understand the theory that serves as the foundation for Oracle's software and offer practical tips for designing and working with it.
Relational Database Management System (RDBMS) fundamentals tutorial: New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database ...
Database design: Good performance and effective applications begin with efficient database design. Here are a few resources to help you figure out how to arrange and access your data.
Designing database systems: This excerpt from "Designing effective database systems" describes the processes involved in the analysis and design of database systems, starting with project life cycles.

CONTRIBUTORS: Michael Annab
LAST UPDATED: 16 Feb 2009

Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com

More resources from around the web:
- Paul Maxim's 1981 Turing Award presentation summarizes Codd's career.
- The Association for Computing Machinery (ACM) provides the text of Codd's original paper.
- A paper at Yale provides some historical perspective about databases.
- Jegworks provides an illustrated tutorial about various kinds of databases.
- At EBizQ, Beth Gold-Bernstein provides a perspective of Codd's contributions.





FILE EXTENSION AND FILE FORMAT LIST
File Extension and File Format List:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #


RELATED CONTENT
How to use V$SEGMENT_STATISTICS to find the most accessed Oracle table
Learn how to use the V$SEGMENT_STATISTICS view to find the most accessed table in an Oracle database with this query from Oracle expert Brian...
Can I install an Oracle client on Windows 7?
Learn why you would be unable to install an Oracle client on Windows 7 for Oracle 10g, and whether you could install the Oracle 11g client on Windows...
How to use the Oracle Database Upgrade Assistant (DBUA)
Oracle expert Brian Peasland explains in what scenarios to use the Oracle Database Upgrade Assistant and more about the Oracle DBUA in this expert...

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
extent  (SearchOracle.com)
field  (SearchOracle.com)




Research Abstracts - E. F. Codd Articles
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts