Reginald Braithwaite blogs that Relational Calculus is about Relations, not Rows, quoting from this entry at Enfranchised Mind:
To faithfully model SQL we must, on some level, faithfully model the relational calculus. And this is where I think the Object Oriented programmers go astray in trying to interface to SQL. In their hurry to make things into objects, they immediately (and without fail) declare the rows to be objects–and thus miss the fact that relational calculus and thus SQL is about relations, not rows.
I’ve often said that complex problems are just simple problems which are not well defined or correctly articulated. OO-heads rage against the ORM problem because they’re not solving the ORM problem, they’re solving something else. To solve the ORM problem, you have to understand that the basis of the problem is in adequately representing the fundamental operators of relational calculus–join, selection, projection–then combining them in ways that produce higher-order behaviors which implement the functionality required.
Simply serializing objects into a matrix representation is not “solving the ORM problem.” This is my biggest criticism of the ActiveRecord in Ruby on Rails: if your problem is so simple that pregenerated scaffolds and ActiveRecord is adequate, then your problem is so trivial it’s non-interesting. The challenge is for an OO language to facilitate representing the relations between objects, the semantic information about how one object’s data values can be derived using the three relational calculus operators from other data. At that point, why not simply learn and use SQL directly, rather than extending your favorite language with what is essentially a dialect of SQL?
Of course, when the majority of software developers are just tool users and not artisans who actually create things, it’s really a moot point. “Web 2.0″ has brought us a lot of new applications, but they’re all fundamentally the same. Ruby on Rails and ActiveRecord offers a solution to the CRUD problem to the tool users, but that hasn’t been interesting for years now. What’s needed now is a way to provide the mass of tool users to create novel permutations of the tools they have, not just continue to replicate slightly varied instances of them.
Tags:
Reginald Braithwaite,
programming,
relational calculus,
object-relational mapping,
Ruby on Rails,
ActiveRecord
March 12th, 2010 at 10:30 pm
Mikki: I would hazard a guess that any reasonably experienced technician should do an adequate job. Obviously, every individual ...
March 12th, 2010 at 9:52 pm
Okay...now you have me worried...I've had my WONDERFUL Bosch washer/condensation dryer for about 8 years without a problem (okay so ...
March 11th, 2010 at 8:45 am
I'm not sure, but I'm guessing it's the belt that turns the drum - may be too tight, may be ...
March 11th, 2010 at 6:57 am
Hello all. I now have a different problem. The drum groans as it spins. When you try ...
March 10th, 2010 at 9:35 pm
Hi Dossy, Thanks much for sharing the knowledge with others. This article helps me to avoid DISM errors : ...