|
|
Browse by Tags
All Tags » SQL » Data
-
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 for the reader to work out what types x and z ...
-
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 was published for public consumption. So began a revolution. Data was liberated from its ...
-
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 the purpose of supporting declarative business logic. Even the SQL standards committee added ...
-
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! It was less of a surprise to find that Computerworld hadn't quite got it right ...
|
|
|