Relational Algebra and its implications for NoSQL databases

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

Deploying the same database to many different RDBMSs

With the idea of a generic Dacpac defined by international standard, comes the potential for a Visual Studio developer to use SSDT to create a generic database model to a SQL-92 compliant standard that can then be deployed to any one of the major RDBMSs. The same database model would be deployable to Oracle, MySQL, or SQL Server, for example. Professor Hugh Bin-Haad explains the reasoning and technology behind this.… Read more

Introducing IM#1: The Final One?

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

Insider Insights

From our correspondent with his finger on the pulse… The following rumors have not been confirmed nor denied by anyone: There are performance gains from negatively incrementing identity columns when paired with a decrementing index. The query execution plan’s nested loop joins icon spins counter-clockwise (the other direction) when used in a spatial query with … Read more

The Concept of Cardinal Reciprocity- A Primer

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