Hugh Darwen

Last updated

Hugh Darwen
Hugh-darwen.jpg
Born1943 (age 78–79)
Warwick, England,
NationalityBritish
Occupationauthor, lecturer, researcher, and consultant, specializing in relational database theory
Employer(until 2004) IBM
Known for Relational database theory

Hugh Darwen is a computer scientist who was an employee of IBM United Kingdom from 1967 [1] to 2004, and has been involved in the development of the relational model. [2]

Contents

Work

From 1978 to 1982 he was a chief architect on Business System 12, a database management system that faithfully embraced the principles of the relational model. [3] He worked closely with Christopher J. Date and represented IBM at the ISO SQL committees (JTC1 SC32 WG3 Database languages, [4] WG4 SQL/MM [5] ) until his retirement from IBM. Darwen is the author of The Askew Wall [6] and co-author of The Third Manifesto, a proposal for serving object-oriented programs with purely relational databases without compromising either side and getting the best of both worlds, arguably even better than with so-called object-oriented databases. [7]

From 2004 to 2013 he lectured on relational databases at the Department of Computer Science, University of Warwick (UK), [8] and from 1989 to 2014 was a tutor and consultant for the Open University (UK) [9] where he was awarded a MUniv honorary degree for academic and scholarly distinction. [10] He was also awarded a DTech (Doctor in Technology) honorary degree by the University of Wolverhampton. [11] He later taught a database language designed by Chris Date and himself called Tutorial D. [12]

Bridge

He has written two books on the card game bridge, both on the subject of double dummy problems, on which he has a website. Alan Truscott has called him "the world's leading authority" on composed bridge problems. [13] He was responsible for the double dummy column in Bridge Magazine and other UK bridge publications from 1965 to 2004.

Publications

His early works were published under the pseudonym of Andrew Warden: both names are anagrams of his surname.[ clarification needed ]

Related Research Articles

Database normalization or database normalisation is the 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. It was first proposed by British computer scientist Edgar F. Codd as part of his relational model.

<span class="mw-page-title-main">Martin Fowler (software engineer)</span> American software developer, author and international public speaker on software development

Martin Fowler is British software developer, author and international public speaker on software development, specialising in object-oriented analysis and design, UML, patterns, and agile software development methodologies, including extreme programming.

A relational database is a 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 relational database systems are equipped with the option of using the SQL for querying and maintaining the database.

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. A database organized in terms of the relational model is a relational database.

SQL is a 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). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables.

<span class="mw-page-title-main">Object–relational database</span> Database management system

An object–relational database (ORD), or object–relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language. In addition, just as with pure relational systems, it supports extension of the data model with custom data types and methods.

Fabian Pascal is a Romanian-American consultant to large software vendors such as IBM, Oracle Corporation, and Borland, but is better known as an author and seminar speaker. Born in Romania, Pascal lives in the San Francisco, CA area of the US, and works in association with Christopher J. Date.

<span class="mw-page-title-main">Christopher J. Date</span> British database researcher

Chris Date is an independent author, lecturer, researcher, and consultant, specializing in relational database theory.

<span class="mw-page-title-main">Edgar F. Codd</span> English computer scientist

Edgar Frank "Ted" Codd was an 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. He made other valuable contributions to computer science, but the relational model, a very influential general theory of data management, remains his most mentioned, analyzed and celebrated achievement.

First normal form (1NF) is a property of a relation in a relational database. A relation is in first normal form if and only if no attribute domain has relations as elements. Or more informally, that no table column can have tables as values. Database normalization is the process of representing a database in terms of relations in standard normal forms, where first normal is a minimal requirement. SQL-92 does not support creating or using table-valued columns, which means that using only the "traditional relational database features" most relational databases will be in first normal form by necessity. Database systems which do not require first normal form are often called no sql systems. Newer SQL standards like SQL:1999 have started to allow so called non-atomic types, which include composite types. Even newer versions like SQL:2016 allow json.

Dataphor is an open-source truly-relational database management system (RDBMS) and its accompanying user interface technologies, which together are designed to provide highly declarative software application development. The Dataphor Server has its own storage engine or it can be a virtual, or federated, DBMS, meaning that it can utilize other database engines for storage.

In relational databases, relvar is a term introduced by C. J. Date and Hugh Darwen as an abbreviation for relation variable in their 1995 paper The Third Manifesto, to avoid the confusion sometimes arising from the use of the term relation, by the inventor of the relational model, E. F. Codd, for a variable to which a relation is assigned as well as for the relation itself. The term is used in Date's well-known database textbook An Introduction to Database Systems and in various other books authored or coauthored by him.

<span class="mw-page-title-main">Null (SQL)</span> Marker used in SQL databases to indicate a value does not exist

In SQL, null or NULL is a special marker used to indicate that a data value does not exist in the database. Introduced by the creator of the relational database model, E. F. Codd, SQL null serves to fulfil the requirement that all true relational database management systems (RDBMS) support a representation of "missing information and inapplicable information". Codd also introduced the use of the lowercase Greek omega (ω) symbol to represent null in database theory. In SQL, NULL is a reserved word used to identify this marker.

The object–relational impedance mismatch is a set of conceptual and technical difficulties that are often encountered when a relational database management system (RDBMS) is being served by an application program written in an object-oriented programming language or style, particularly because objects or class definitions must be mapped to database tables defined by a relational schema.

Sixth normal form (6NF) is a term in relational database theory, used in two different ways.

Rel is an open-source true relational database management system that implements a significant portion of Chris Date and Hugh Darwen's Tutorial D query language.

David McGoveran is an American computer scientist and physicist, software industry analyst, and inventor. In computer science, he is recognized as one of the pioneers of relational database theory.

Nikos Lorentzos is a Greek professor of Informatics. He is a specialist on the Relational Model of Database Management, having made contributions in the field of temporal databases, where he has co-authored a book with Hugh Darwen and Christopher J Date.

<span class="mw-page-title-main">Relation (database)</span>

In database theory, a relation, as originally defined by E. F. Codd, is a set of tuples (d1, d2, ..., dn), where each element dj is a member of Dj, a data domain. Codd's original definition notwithstanding, and contrary to the usual definition in mathematics, there is no ordering to the elements of the tuples of a relation. Instead, each element is termed an attribute value. An attribute is a name paired with a domain. An attribute value is an attribute name paired with an element of that attribute's domain, and a tuple is a set of attribute values in which no two distinct elements have the same name. Thus, in some accounts, a tuple is described as a function, mapping names to values.

A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. Such databases have existed since the late 1960s, but the name "NoSQL" was only coined in the early 21st century, triggered by the needs of Web 2.0 companies. NoSQL databases are increasingly used in big data and real-time web applications. NoSQL systems are also sometimes called Not only SQL to emphasize that they may support SQL-like query languages or sit alongside SQL databases in polyglot-persistent architectures.

References

  1. ↑ Date & Darwen (1998b), Foundation for Object-Relational Databases, Reading: Addison-Wesley, archived from the original on 18 July 2011, retrieved 22 January 2011.
  2. ↑ Valles, Jose R. (2008), Oracle database administrators as internal customers: Customer satisfaction criteria applied to technical decision making, performance, and evaluation, p. 10, ISBN   978-0-549-34189-5, The relational model was originally conceived by Dr. Edgar F. Codd and subsequently maintained and developed by Hugh Darwen and Chris Date as a general model of data
  3. ↑ Darwen, Hugh (November 1996), "Business System 12", System R, Paul McJones, retrieved 22 January 2011.
  4. ↑ Mann, Douglas (17–28 May 2004), List of Delegates (MS Word), Xi'an, CN: ISO/IEC JTC 1/SC 32.
  5. ↑ Scarponcini, Paul; Darwen, Hugh, Minutes of the SQL/MM WG4 Meeting and FCD and CD Continuation Editing Meetings (PDF), Document register, Brisbane and Sydney: ISO/IEC JTC1 SC32 committee, 9 and 13–17 July 1998.
  6. ↑ Darwen 2006.
  7. ↑ Date & Darwen 1995.
  8. ↑ Darwen, Hugh, Profile, LinkedIn, archived from the original on 15 July 2012.
  9. ↑ Waugh, Kevin (2007), M359 Course Guide – Relational databases: theory and practice, Milton Keynes: The Open University.
  10. ↑ "Open Eye: Time to honour a degree of openness". The Independent. London. 6 May 1999.
  11. ↑ BCS Prize Winners, University of Wolverhampton, 1998, archived from the original on 9 October 2006.
  12. ↑ Cartwright, David (12 October 2004). "A new approach to querying databases? the ABC of Tutorial D". Techworld .
  13. ↑ Truscott, Alan (3 January 1974). "British Problemist Writes About 114 Game Quandaries". The New York Times .
  14. ↑ "Bridge magic: double dummy problems, single dummy, sure tricks, curios and ...". Library of Congress Catalog Record. Retrieved 17 May 2014.
  15. ↑ "COMPENDIUM OF DOUBLE DUMMY PROBLEMS : double dummy bridge problems from 1896 to 2005". Library of Congress Catalog Record. Retrieved 05 November 2022.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.