Hugh Bin-Haad

Hugh is both a distinguished expert in object-oriented conmputer languages, and a DBA who has spent sixteen years working with financial applications in the UK and the Middle-East, and been a delegate on the international ANSI committee for the standardisation of Relational Theory. Hugh is well-known in the Database world. He lectures in Relational Theory at Chiltern University UK. He is the author of many Journal articles and has co-authored several books on UML, SOLID, DRY, Object Modelling techniques and relational theory, as well as a definitive criticism of the black-and-white films of Ingmar Bergman.

Follow Hugh Bin-Haad via

Hugh Bin-Haad 01 April 2016

Relational Algebra and its implications for NoSQL databases

Opinion Pieces

With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the data-document model's hierarchical nature causing a fundamental conflict with relational theory? We asked our relational expert, Hugh Bin-Haad to expound a difficult area for database theorists.… Read more

Opinion Pieces

Hugh Bin-Haad 01 April 2014

We don’t need Source Control: we’re Database Developers

Opinion Pieces

As part of our long-running series of articles where we ask working database developers how database source control improves their work within development teams, we made the mistake of asking Hugh Bin-Haad, Database dev and relational theorist.… Read more

Opinion Pieces

Hugh Bin-Haad 01 April 2013

TSQL Pivot Rotations using only REPLACE

T-SQL Programming

Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the job done without GROUP BY or PIVOY, here is a way to do it using only REPLACE.… Read more

T-SQL Programming

Hugh Bin-Haad 01 April 2012

Introducing IM#1: The Final One?

Opinion Pieces

Our resident expert in current advances in Computer Science, Professor Bin-Haad, reviews the first details to emerge about the experimental language IM1, which has been a remarkable University project jointly sponsored by the major players in the battle for the Desktop. On this special day, we hear about the radical features of the new language, designed once and for all to resolve the apparently irreconcilable demands of the proponents of all the different computer languages required in order to create portable applications.… Read more

Opinion Pieces

Hugh Bin-Haad 01 April 2008

The Concept of Cardinal Reciprocity- A Primer

Learn SQL Server

Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a number of subtle problems with database design in terms of its derivability, redundancy, and consistency. . Increasingly, this little-understood aspect of relational theory, that emphasises the cardinality of the attributes of tuples in a relation and the reciprocity with isomorphic foreign key restraints, is becoming a hot forum topic.… Read more

Learn SQL Server