Home History Design Papers New ideas Nulls OWA Links

A new approach to relational database management

One of the earliest relational systems actually incorporated many ideas which are needed today - but are expressly condemned by a number of relational puritans.


G-EXEC was one of the first relational database management systems, developed in the 1970s by a team in the UK Institute of Geological Sciences (now the British Geological Survey), but its ideas and design concepts are still just as valid today.

One of the big problems in relational database management has always been the treatment of missing data. The SQL 'NULL' is generally accepted to be an abomination, but Date, Pascal, and others have reacted by attempting to forbid the use of any missing data representation in relational databases. They have done this by re-defining the relational database in terms of the 'closed world assumption'. This states that anything not included within the database is false.

However, it was never Codd's intention that the relational model should be restricted in this way, and he explicitly accepted that both closed-world and open-world assumptions have their place. Using the open world assumption may require the use of multi-valued logic, but this is not the insuperable obstacle which Chris Date presents.

New software is to be developed using the relational principles as defined by E.F. Codd, rather than the much narrower 'revisionist' principles of Date, Pascal, and others.

Copyright © Resources Computing International Ltd
This site is prepared and managed by Resources Computing International Ltd.