Welcome to EMC Consulting Blogs

Browse by Tags

• Cloud
• Data Modelling
• SQL

• 2 + 2 = ?

  As a concise example of the evils of type coercion I came up with the following: INSERT INTO t VALUES ( CAST(2 AS INT), CAST(2 AS INT)); SELECT CASE WHEN x + z = 4 THEN '4' ELSE 'NOT 4' END xPLUSz FROM t; Result: xPLUSz ------ NOT 4 It is left as an exercise Read More... Posted 26 August 2009 21:02 by David.Portas | 3 Comments Filed under: SQL, Data

• The Relational Model turns 40

  The Relational Data Model is 40 years old. Edgar Codd first described the idea that databases could be constructed from mathematical relations in an internal IBM Research report in August 1969. The following year his more famous paper on the same topic Read More... Posted 18 August 2009 22:55 by David.Portas | 3 Comments Filed under: SQL, Data, Cloud

• Not the model, Bill

  According to InfoWorld , Bill Gates thinks that declarative modelling of business logic has not caught on because of "weak models". This is a surprise. E.F.Codd's earliest papers on the Relational Model described a relational calculus for Read More... Posted 12 February 2008 22:27 by David.Portas | 1 Comments Filed under: SQL, Data, Data Modelling

• Relational database pioneer doesn't quite say technology is obsolete!

  According to Computerworld , Mike Stonebraker says "RDBMSes, are 'long in the tooth' and 'should be considered legacy technology'" . Knowing Stonebraker's work and reputation that seemed like some pretty startling information! Read More... Posted 16 September 2007 21:10 by David.Portas | 0 Comments Filed under: SQL, Data