Raymond F. Boyce
Raymond F. Boyce | |
|---|---|
| Born | 27 August 1946 New York City, U.S. |
| Died | 18 June 1974 (aged 27) |
| Occupation | Computer scientist |
| Known for | Development of SQL, Boyce-Codd normal form |
Raymond Francis Boyce (August 27, 1946 – June 18, 1974) was a prominent American computer scientist recognized for his pioneering work in relational database systems. He played a key role in the creation of the SQL language and the formulation of the Boyce-Codd normal form.
Biography
Boyce was born in New York City on August 27, 1946. He completed his undergraduate studies at Providence College in 1968 and obtained a PhD in computer science from Purdue University in 1972. During college, he met and later married Doris Ann ("Sanndy"), who worked as a nurse. After finishing his doctorate, Boyce joined IBM's Yorktown Heights facility, where he engaged in database-related projects. Within two years, he co-created the Boyce–Codd normal form. Subsequently, as the head of IBM’s Relational Database development team located in San Jose, California, he collaborated with Donald D. Chamberlin to develop Structured Query Language (SQL). Boyce passed away on June 18, 1974, due to an aneurysm, leaving behind his wife Sanndy and their young daughter Kristin.
SQL
In the early 1970s at IBM, Boyce and Donald D. Chamberlin jointly developed SQL. Originally called SEQUEL (Structured English Query Language), this language evolved from their previous work on SQUARE (Specifying Queries As Relational Expressions) and was intended for managing and retrieving data within relational databases. By 1974, they published “SEQUEL: A Structured English Query Language,” which described its capabilities for data querying. This language was among the first to implement the relational model proposed by Edgar F. Codd. The name SEQUEL was later shortened to SQL after vowels were removed because SEQUEL was already trademarked by the Hawker Siddeley aircraft manufacturer. Today, SQL stands as the dominant language for relational database management.
Boyce-Codd normal form
The Boyce–Codd normal form (BCNF), introduced in 1974 by Boyce alongside Edgar F. Codd, represents a normalization criterion designed to remove redundancy through functional dependency analysis. BCNF is a more rigorous refinement of the third normal form, enhancing relational database schema design to ensure efficient storage and eliminate unnecessary data duplication.
Further reading
- The 1995 SQL Reunion: People, Projects, and Politics (early history of SQL)
- “SEQUEL: A Structured English Query Language” D.D. Chamberlin and R.F. Boyce, Proc. ACM SIGMOD Workshop on Data Description, Access and Control, Ann Arbor, Michigan (May 1974) pages 249-264.